Overview - 6.3

Talend Data Mapper User Guide

Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Design and Development
Talend Studio

The database support allows you to read and write from databases using a map. To use the database support, you must first import the database using the Import mechanism (File -> Import) in the studio. This reads all of the tables of the database into a set of structures, one for each table. Each database structure has a loop (with an element called Row) that corresponds to each selected or written row.

To read from the database, use the structure corresponding to the table as the input structure of a map. If you are reading from multiple tables using a database join, you can create a new structure representing the joined tables using the [New Structure] wizard (select the create a database join table option). When creating the map you can specify a SQL select statement using a DatabaseSelect function. You can also use DatabaseJoin function(s) to specify conditions on join(s) as required. All database functions are placed in the IO/Database expression tab.

To write to a database, use a structure corresponding to the table as the output structure of a map. Use a DatabaseInsert or DatabaseUpdate function as required.

You can read from or write to any number of database tables in a single map by creating an enclosing structure that inherits from the desired database table structures.

Lookup functions are also provided to find and update values from database tables. To use these, import the database as described below, and then use the functions in your mapping expressions, specifying the required database and tables.