OLEDB Integration and Synchronization
OLEDB compliant data sources can be
integrated and synchronized codeless with various other data sources using the
Cloud Connector via the OLEDB Data Provider. Please take a look here for supported systems and
OLEDB (Object Linking and Embedding,
Database, sometimes written as OLEDB or OLE-DB), an API designed by Microsoft,
allows accessing data from a variety of sources in a uniform manner. The API
provides a set of interfaces implemented using the Component Object Model (COM).
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 OLEDB for
more features and better performance depending on implementation.
To connect to an OLEDB compliant data source the data source entity must be
configured as follows in the Layer2 Cloud Connector Connection Manager:
Fig.: Sample connection
configuration to connect to Microsoft Access data via OLEDB.