Add a JDBC connection
With DataFlow, you can add a connection to any database when you have the appropriate JDBC driver.
To add a new connection through JDBC, follow these steps:
-
Click Connections in the top navigation bar.
-
In the Connections interface, click Add connection in the upper right corner.
-
In the Create Connection interface, select the Connection type.
-
After you select the JDBC Connection type, the rest of the connection properties appear.
See Connection properties for details, defaults, and examples.
- Connection name
-
Name your connection.
- Connection type
-
Choose the JDBC connection type.
- Driver name
-
Specify the JDBC driver class for the database connection.
- JDBC URL
-
Specify the jdbc url for database connection.
- JDBC driver jar
-
Upload the jdbc jar available in local system.
- JDBC options
-
Select if custom JDBC options to be appended to the JDBC extract command.
- Key
-
Define the key parameter.
- Value
-
Specify the value for key parameter.
- Encrypt
-
Encrypt the details for secured authentication. Select the check-box to encrypt the details.
- Schema object name enclosing character
-
Specify the schema object name enclosing character.
-
Click Create connection.
