How to use the ODBC Generic 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: