Completing the JDCB connection details - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

Procedure

  1. Fill in the connection details as follows:
    • Fill in the JDBC URL used to access the database server.

    • 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 Talend Type. For more information, see Accessing mapping files and defining type mappings.
  2. Click Test connection to check your connection.
  3. 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.