Leverage existing skills by using the JDBC standard to read and write to LDAP:Through drop-in integration into ETL tools like Oracle Data Integrator (ODI), the CData JDBC Driver for LDAP connects real-time LDAP objects to your data warehouse, business intelligence, and Big Data technologies.JDBC connectivity enables you to work with LDAP just as you would any other database in ODI. As with an RDBMS, you can use the driver to connect directly to the LDAP APIs in real time instead of working with flat files.This article walks through a JDBC-based ETL - LDAP to Oracle.
After reverse engineering a data model of LDAP entities, you will create a mapping and select a data loading strategy - since the driver supports SQL-92, this last step can easily be accomplished by selecting the built-in SQL to SQL Loading Knowledge Module. Install the DriverTo install the driver, copy the driver JAR and.lic file, located in the installation folder, into the ODI userlib directory:On Unix:/.odi/oracledi/userlibOn Windows:%APPDATA%RoamingodioraclediuserlibRestart ODI to complete the installation.Reverse Engineer a ModelReverse engineering the model retrieves metadata about the driver's relational view of LDAP objects.
Oct 28, 2014 This article illustrates how to connect ODI on premise to Oracle in the cloud (OPC), specifically the Database as a Service (DBaaS, see doc here) offering.You will see how easy it is to configure connectivity from within ODI and the use of familiar tools gives you the same consistency from on premise use to the cloud.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |