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:

  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.

    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.

  5. Click Create connection.