Oracle

Available when using an authoring Data Collector version 4.0.0 or later.

To create an Oracle connection, one of the following stage libraries must be installed on the selected authoring Data Collector:
  • JDBC Oracle, streamsets-datacollector-jdbc-oracle-lib, to use the connection with the Oracle CDC origin
  • JDBC streamsets-datacollector-jdbc-lib, to use the connection with the Oracle CDC Client origin and SQL Parser processor

For a description of the Oracle connection properties, see Oracle Connection Properties.

After you create an Oracle connection, you can use the connection in the following stages:
Engine Stages

Data Collector 5.10.0 or later

  • Oracle destination

Data Collector 5.4.0 or later

  • Oracle CDC origin

Data Collector 5.2.0 or later

  • SQL Parser processor

Data Collector 4.0.0 or later

  • Oracle CDC Client origin
Transformer 4.0.0 or later
  • Oracle JDBC Table origin

Oracle Connection Properties

When creating an Oracle connection, configure the following properties on the JDBC tab:
Oracle JDBC Properties
JDBC Connection String Connection string used to connect to the database.
Use Credentials Enables entering credentials. Use when you do not include credentials in the JDBC connection string.
If you configured the connection to enter JDBC credentials separately from the JDBC connection string, then configure the following properties on the Credentials tab:
Credentials Property Description
Username User name for the JDBC connection. The user account must have the correct permissions or privileges in the database.
Password Password for the account.
Tip: To secure sensitive information, you can use credential stores or runtime resources.