JDBC
Available when using an authoring Data Collector version 4.0.0 or later.
To create a JDBC connection, the JDBC stage library,
streamsets-datacollector-jdbc-lib
, must be installed on the
selected authoring Data Collector.
For a description of the JDBC connection properties, see JDBC Connection Properties.
Engine | Stages |
---|---|
Data Collector 4.0.0 or later |
|
Transformer 4.0.0 or later |
|
JDBC Connection Properties
JDBC Property | Description |
---|---|
JDBC Connection String | Connection string used to connect to the database. Use the
connection string format required by the database vendor. For example, use the following formats for these database vendors:
You can optionally include the user name and password in the connection string. |
Use Credentials | Enables entering credentials on the Credentials tab. Use when you do not include credentials in the JDBC connection string. |
Credentials Property | Description |
---|---|
Username | User name for the JDBC connection. The user account must have the correct permissions or privileges in the database. For example, the user account specified for an origin must be able to read data from the database. The user account specified for a destination must be able to write to the database. |
Password | Password for
the JDBC user name. Tip: To secure sensitive
information, you can use credential stores or runtime resources.
|