Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →Connect to JDBC-ODBC Bridge Data in CloverDX (formerly CloverETL)
Transfer JDBC-ODBC Bridge data using the visual workflow in the CloverDX data integration tool.
The CData JDBC Driver for JDBC-ODBC Bridge enables you to use the data transformation components in CloverDX (formerly CloverETL) to work with JDBC-ODBC Bridge as sources and destinations. In this article, you will use the JDBC Driver for JDBC-ODBC Bridge to set up a simple transfer into a flat file. The CData JDBC Driver for JDBC-ODBC Bridge enables you to use the data transformation components in CloverDX (formerly CloverETL) to work with JDBC-ODBC Bridge as sources and destinations. In this article, you will use the JDBC Driver for JDBC-ODBC Bridge to set up a simple transfer into a flat file.
Connect to JDBC-ODBC Bridge as a JDBC Data Source
- Create the connection to JDBC-ODBC Bridge data. In a new CloverDX graph, right-click the Connections node in the Outline pane and click Connections -> Create Connection. The Database Connection wizard is displayed.
- Click the plus icon to load a driver from a JAR. Browse to the lib subfolder of the installation directory and select the cdata.jdbc.jdbcodbc.jar file.
- Enter the JDBC URL.
To connect to an ODBC data source, specify either the DSN (data source name) or specify an ODBC connection string: Set Driver and the connection properties for your ODBC driver.
Built-in Connection String Designer
For assistance in constructing the JDBC URL, use the connection string designer built into the JDBC-ODBC Bridge JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.
java -jar cdata.jdbc.jdbcodbc.jar
Fill in the connection properties and copy the connection string to the clipboard.
A typical JDBC URL is below:
jdbc:jdbcodbc:Driver={ODBC_Driver_Name};Driver_Property1=Driver_Value1;Driver_Property2=Driver_Value2;...
Query JDBC-ODBC Bridge Data with the DBInputTable Component
- Drag a DBInputTable from the Readers selection of the Palette onto the job flow and double-click it to open the configuration editor.
- In the DB connection property, select the JDBC-ODBC Bridge JDBC data source from the drop-down menu.
- Enter the SQL query. For example:
SELECT Id, Name FROM Account WHERE Id = '1'
Write the Output of the Query to a UniversalDataWriter
- Drag a UniversalDataWriter from the Writers selection onto the jobflow.
- Double-click the UniversalDataWriter to open the configuration editor and add a file URL.
- Right-click the DBInputTable and then click Extract Metadata.
- Connect the output port of the DBInputTable to the UniversalDataWriter.
- In the resulting Select Metadata menu for the UniversalDataWriter, choose the Account table. (You can also open this menu by right-clicking the input port for the UniversalDataWriter.)
- Click Run to write to the file.