ODBC (Open Database Connectivity) is a standard programming language middleware API for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. It is especially helpful to connect to older systems and applications. Please make use of the 32-bit version of the Layer2 Cloud Connector to integrate such type of databases (even under 64-bit operating systems). For newer systems please check for availability of ADO.NET-based providers instead of ODBC for more features and better performance depending on implementation.
To connect to an ODBC compliant data the data source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:
Fig.: Sample connection configuration to connect to FileMaker data via ODBC.