This question has been flagged

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
Avatar
Discard
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

Avatar
Discard
Author

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

Best Answer

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

Avatar
Discard
Author

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,

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


Avatar
Discard

Hi Essam, I need more info, I have a client request to run odoo with MS SQL Server