JDBC connection
Use a JDBC connection to access relational data. You can use JDBC connections in JDBC and Singlestore stages in StreamSets flows. JDBC is a standard API that enables Java applications to interact with relational databases. This connection can only be used in StreamSets flows.
Supported JDBC versions
The JDBC JAR file must be compatible with JDK 8, JDBC version 4.2 or earlier.
Create a connection to JDBC
To create a connection to use in StreamSets flows, you need the following details:
- JDBC connection string: Use the connection string format required by the database vendor.
Credentials
- Username and password
Note: The user account must have the correct permissions or privileges in the database. For example, the user account specified for a source must be able to read data from the database. The user account specified
for a target must be able to write to the database.