Odoo Help

1

Connect mysql with postgresql in odoo

By
vijay
on 2/29/16, 12:54 AM 759 views

How to Fetch data from Mysql and put into Postgressql using Server Action.

eg.select data from the mysql tables and copy into postgressql table.

0
Divya-browseinfo
On 2/29/16, 2:59 AM

hello..

first you have to install pymssql...(pip install pymssql)

Then create one server action by below python code:

conn = pymssql.connect(server=your_obj.url, port=your_obj.port_no, user=your_obj.user_name,password=your_obj.password, database=your_obj.database_name)

cur = conn.cursor()

cur.execute("SELECT col_name from your_table")



Thank You

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 2/29/16, 12:54 AM
Seen: 759 times
Last updated: 2/29/16, 3:06 AM