🔌Setting up an ODBC Connector
Overview¶
You can use the generic ODBC connector for any of your data source compliant with ODBC.
However, the relevant Driver must be installed and configured on your Toucan Toco instance.
Example with a Postgresql instance¶
First, if you have a On Premise instance install the psql ODBC driver using this script or ask your Toucan Toco contact to install the driver on your instance
Then create an awesome ODBC connector in your small app:
Configure it using the proper parameters for the postgres ODBC driver:
💡 The driver parameters will depend on the data source you want to query. For postgres, the syntax is as such:
Driver={Driver Name};Server=IP address;Port=server-port;Database=Databasename;Uid=Username;Pwd=Password;
You’ll then be able to create and configure your data source:
Other datasources¶
Other driver installation scripts are available for:
For syntax refer to:
For reference, you can check pyodbc
Last updated