Setting up a JDBC connection - 7.0

Talend ESB Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.0
EnrichProdName
Talend ESB
task
Design and Development
EnrichPlatform
Talend Studio

Procedure

  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 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 Drivers table, specify the driver jars needed. To do this, click the [+] button under the table to add as many rows as needed, each row for a driver JAR, then select the cell and click the [...] button at the right side of the cell to open the Module wizard from which you can select the driver JAR of your interest.

    • In the Driver Class field, specify the main class of the driver allowing to communicate with the database.

    • Fill in your database user authentication data in User Id and Password fields.

    • In the Mapping file list, select the mapping that allows the database Type to match the Java type of data on the schema 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 Accessing mapping files.

  5. Click Test connection to check your connection.
  6. 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.