ODBC Integration and Synchronization
ODBC compliant data
sources can be integrated and synchronized codeless with various other data
sources using the Layer2 Cloud Connector via the ODBC Data Provider. Please take
a look here for
supported systems and applications.
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:
Sample connection configuration to connect to FileMaker data via ODBC.