JDBC
Available when using an authoring Data Collector version 3.19.0 or later.
- JDBC stage library,
streamsets-datacollector-jdbc-lib
- SingleStore stage library,
streamsets-datacollector-singlestore-lib
For a description of the JDBC connection properties, see JDBC Connection Properties.
Engine | Stages |
---|---|
Data Collector 5.5.0 or later |
|
Data Collector 3.19.0 or later |
|
Transformer 3.16.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. Select 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. |