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:

1. Click Connections in the top navigation bar.

2. In the Connections interface, click Add connection in the top right corner.

3. In the Create Connection interface, select the Connection type.

4. After you select the JDBC Connection type, the rest of the connection properties appear.

   • 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 paramter
   • Encrypt
     Enrypt the details for secured authentication
     Select the check-box to enrypt the details
   • Schema object name enclosing character
     Specify the schema object name enclosing character.

   See Connection properties for details, defaults, and examples.

5. Click Create connection.