What I am trying to do: use the base_external_dbsource to gain access to an MS SQL Server database, and query some information to add new records into an odoo model.
What I have done: I have an odoo installation in which I have used the base_external_datasource (odbc) to successfully connect to my ODBC database, and I have set up an odoo model to put the data into.
What I am stuck on: It is not clear how to retrieve information from the connected ODBC datasource using Odoo.
Note: I am happy to develop a module to do this if required, but it is still not clear to me how I could retrieve data using the base_external_dbsource ODBC connection I have set up from within a custom module.
Online documentation for
base_external_dbsource only describes how to obtain a connection to your database and not how to utilize this connection. Many similar forum posts about base_external_dbsource have been left unanswered.Thanks :)
I agree an example would be nice. I would love to have a SQL query that gets turned into a readonly model.