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:
ODBC-connector

ODBC-connector

  • Configure it using the proper parameters for the postgres ODBC driver:
params

params

💡 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:
odbc-datasource

odbc-datasource

Other datasources