Setting up a JDBC connection

Talend Studio Developer Guide

EnrichVersion
Cloud
EnrichProdName
Talend Integration Cloud
task
Design andĀ Development
  1. To create a JDBC connection from scratch, expand Metadata in the Repository tree view, right-click Db Connections and select Create connection from the contextual menu to open the database connection setup wizard.

    To centralize database connection parameters you have defined in a Job into a JDBC connection, click the icon in the Basic settings view of the relevant database component with its Property Type set to Built-in to open the database connection setup wizard.

    To modify an existing JDBC connection, right-click the connection item from the Repository tree view, and select Edit connection to open the connection setup wizard.

  2. Fill in the schema generic information, such as the connection Name and Description, and then click Next to proceed to define the connection details.

    For further information, see the section on defining general properties in Setting up a database connection.

  3. Select General JDBC from the DB Type list.

  4. Fill in the connection details as follows:

    • Fill in the JDBC URL used to access the database server.

    • In the Driver jar field, select the jar driver validating your connection to the database.

    • In the Class name field, fill in the main class of the driver allowing to communicate with the database.

    • Fill in your User name and Password.

    • Fill the Mapping File field with the mapping allowing the database Type to match the Java type of data on the schema by clicking the [...] button to open a dialog box and selecting the mapping file from the Mapping list area according to the type of database you are connecting to.

      Note

      The mapping files are XML files that you can manage via Window > Preferences > Talend > Specific Settings > Metadata of TalendType. For more information, see Type mapping.

  5. Click Check to check your connection.

  6. Fill in, if needed, the database properties information. Click Finish to close the connection setup wizard.

    The newly created JDBC connection is now available in the Repository tree view and it displays several folders including Queries (for the SQL queries you save) and Table schemas that will gather all schemas linked to this DB connection upon schema retrieval.