IBM Support

How to set up the drivers for the new Oracle CDC origin

How To


Summary

How to set up the drivers for the new Oracle CDC origin

Objective

In this article, we will cover how to install the new drivers required by the new Oracle CDC origin stage.

If you are using the new Oracle CDC stage and get the below error, you will need to install the new drivers.

2023-04-21 14:21:08,118 TestConnectionOracle/TestConne32fb6529-d8cb-4e7e-b400-3e619aer58d8 ERROR Failed to initialize connection pool: {} JdbcUtil *antonioro preview-pool-16-thread-1
java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:oracle:thin:@x.x.x.x:1521:<DB_NAME>
at com.zaxxer.hikari.util.DriverDataSource.(DriverDataSource.java:114) ~[HikariCP-4.0.3.jar:?]
[...]

Steps

There are two ways of installing the drivers: manually or via the UI (recommended).

  1. UI installation (Preferred method)

    1. Download the drivers from the website of Oracle JDBC Downloads. You need to download the ojdbc8-full.tar.gz (Java 8) or the ojdbc11-full.tar.gz (Java 11 and Java 17 ). These packages include the three new drivers that you will need. Uncompress it.

    2. Go to your pipeline in the StreamSets Platform.

    3. Click on the Oracle CDC stage.

    4. Go to the External Libraries tab.

    5. Click on the UPLOAD EXTERNAL LIBRARY button.

    6. Select the files you want to upload for JDBC Oracle.

    7. Click on upload.

    8. You will see the drivers uploaded.

  2.  Manual installation

    1. Download the drivers from the website of Oracle JDBC Downloads. You need to download the ojdbc8-full.tar.gz (Java 8) or the ojdbc11-full.tar.gz (Java 11 and Java 17). These packages include the three new drivers that you will need. Uncompress it.

    2. From Oracle Instant Clients downloads get the JDBC Supplement Package for your specific system and uncompress it.

    3. Create the directory (if it has not yet been created) in the external resources folder of your SDC and copy the files there like this:

      mkdir -p $SDC_DIST/externalResources/streamsets-libs-extras/streamsets-datacollector-jdbc-oracle-lib/lib
cp ojdbc8-full/ojdbc8.jar ojdbc8-full/orai18n.jar instantclient_19_8/orai18n-mapping.jar $SDC_DIST/externalResources/streamsets-libs-extras/streamsets-datacollector-jdbc-oracle-lib/lib

    4. Now just restart the SDC and you are ready to go.

Results

Here is the list of the drivers uploaded

Remember to configure the connection to your Oracle database properly before starting to use the new Oracle CDC origin. You will need to provide the server name, port, database name, username, and password, among other parameters. Once properly configured, you will be able to use this new origin to extract data changes from your Oracle database in real-time and stream them to your data integration pipeline.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSM7CU","label":"IBM StreamSets Data Collector"},"ARM Category":[{"code":"","label":""}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
16 March 2025

UID

ibm17186373

Page Feedback