JDBC connection

Last updated: Aug 01, 2025

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.

Choose the method for creating a connection based on where you are in the platform

In a project: Click Assets > New asset > Connect to a data source. See Adding a connection to a project.
In a deployment space: Click Import assets > Data access > Connection. See Adding data assets to a deployment space.
In the Platform assets catalog: Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

See Add data from a connection in a project.

Parent topic: Supported connections

Was the topic helpful?

0/1000