Working with databases - 7.3

Talend Data Mapper User Guide

Version
7.3
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development > Designing Jobs
Last publication date
2023-01-05

The database support allows you to read from and write to databases using a map.

You can import or read any number of database tables in a single map by creating an enclosing structure that inherits from the desired database table structures. Database lookup functions are provided to find and update values in database tables.

In order to import database tables and use the Test Run feature on a map using the DatabaseLookup function, you need provide the relevant database drivers in the classpath. You can add them in the advanced properties of the database connection wizard. You also need to include this Jar file in your runtime classpath.

JDBC4 drivers are also required at runtime when using the new non-Eclipse runtime.