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.4.0 or later |
|
|
Data Collector 5.2.0 or later |
|
|
Data Collector 4.0.0 or later |
|
| Transformer 4.0.0 or later |
|
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. |