External Database Sources
by Daniel Reis https://github.com/OCA/server-backend , LasLabs https://github.com/OCA/server-backend , Odoo Community Association (OCA) https://github.com/OCA/server-backend
Odoo
Availability |
Odoo Online
Odoo.sh
On Premise
|
Technical Name |
base_external_dbsource |
License | LGPL-3 |
Website | http://launchpad.net/addons-tko |
Versions | 7.0 9.0 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 |
This module allows you to define connections to foreign databases using ODBC, Oracle Client or SQLAlchemy.
Database sources can be configured in Settings > Configuration -> Data sources.
- Depending on the database, you need:
- to install unixodbc and python-pyodbc packages to use ODBC connections.
- to install FreeTDS driver (tdsodbc package) and configure it through ODBC to connect to Microsoft SQL Server.
- to install and configure Oracle Instant Client and cx_Oracle python library to connect to Oracle.
Contributors
- Maxime Chambreuil <[email protected]>
Please log in to comment on this module