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.
Information noteNote: 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.
Click Test connection
to check your connection.
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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
