Importing tables from a database - 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

Create a connection to a database and import tables as new structures.

Before you begin

You have downloaded the relevant driver for your database.

Procedure

  1. In the Data Mapper tab of the Mapping perspective, right-click Hierarchical Mapper > Databases.
  2. Click New > Database.
  3. Enter a Name and select the Database type.
  4. Enter the required database information.

    Example

  5. Click the Show More button and click Edit Classpath at the bottom of the dialog box.
  6. Add the driver you downloaded, then click Apply and Close.
  7. Click Test Connection to check that your configuration is correct, then click Next.
  8. Select the tables that you want to import and click Next.
  9. Select the folder in which you want to import the table structures and click Next, then click Finish.

Results

Your database tables have been imported as structures in the selected folder.