As is well known, the underlying database of Odoo uses PostgreSQL, but many factories in China use MSSQL databases. It is also impossible for many factories to fully adopt Odoo integration all at once. At this point, it is necessary to connect to other platforms to retrieve data into Odoo for specific business operations.
Another situation is that hardware devices originally obtain information and transfer it to the Mssql database, such as the weighbridge at a cement plant;
The cement weighbridge already has a relatively complete system for obtaining data; we just need to read it directly in Odoo.
How does Odoo connect to MSSQL database?
1. The MSSQL runtime platform—freetds software—needs to be properly installed on the server; brew install freetds
2. Correctly install pymssql; pip3 install pymssql
3. Use the code we have developed to integrate.
