Help

3

How to integrate Microsoft SQL Server with Odoo?

Avatar
Ashish Singh

Hi, All


I would like to integrate Microsoft SQL server with Odoo. Is it the same configuration as postgres have? 


Thanks
Ashish Singh
Webkul Software Private Limited
الصورة الرمزية
تجاهل
3 الإجابات
2
Avatar
Niyas Raphy
Best Answer

Hi,

Is the question about how to use the odoo database as Ms SQL instead of the postgres  or to sync the data between these two databases.

If the second is the case you can use the python package pymssql and connect to the MsSql database and fetch the datas into the odoo database.


import pymssql
con = pymssql.connect(host=my_server, server=instance, user=my_user, password=my_password,
database=my_database, port=port)
cursor = con.cursor()
query = ''
cursor.execute(query)
records = cursor.fetchall()


Also you check this module: https://www.odoo.com/apps/modules/10.0/base_external_dbsource_mssql/

and also see this link: https://www.odoo.com/forum/help-1/question/odoo-on-microsoft-sql-server-instead-postgres-sql-142328


Thanks

1 تعليق
الصورة الرمزية
تجاهل
Avatar
Ashish Singh
-

Hi, Niyas

Thanks for sharing the above solution. I will definitely look on to that solution. But yes question is the first one. I want to use Microsoft Sql instead of postgres in Odoo.

So please help me to connect my Odoo with Microsoft Sql Server.

Thanks,.

Ashish Singh

0
Avatar
Essam Muhana
Best Answer

hi , 

i did 5 project same like this integration , all what you need to do is to create link server in Ms SQL and install the odbc connector , then you can map postures db to sql and create your queries , if you need more details ping me again and i can support you for this .

regards


الصورة الرمزية
تجاهل
0
Avatar
Ravi Gadhia
Best Answer

Due to ORM odoo doesn't support any other database.  ORM designed the way it can only support Postgres 

1 تعليق
الصورة الرمزية
تجاهل
Avatar
Ashish Singh
-

Hi, Ravi

Thanks for your response. Is there any way to override the existing ORM to make it compatible with the Microsoft SQL server?

Thanks,