Importing database metadata - Cloud

Talend Cloud Data Management Platform Studio User Guide

English (United States)
Talend Cloud
Talend Management Console
Talend Studio
Design and Development

About this task

Before importing database connection metadata from a CSV file, make sure that your CSV file format is valid. The file columns should be filled as follows:
Nullable;Pattern;Precision;Talend Type;DBType.

-it is recommended to use either Talend Type or DBType, not both.

-tableName is the name displayed in Talend Studio, originalTableName is the original table name in the database. (You can choose to fill only the originalTableName).

-label is the column name used in Talend Studio, originalLabel is the column name in the table. (You can choose to fill only the originalLabel).

To import database connection metadata from a defined CSV file, do the following:


  1. In the Repository tree view, expand the Metadata node and right-click Db connections.
  2. In the contextual menu, select Import connections from CSV.
    The Import connections from CSV dialog box displays.
  3. Click Browse... and go to the CSV file that holds the metadata of the database connection.
  4. Click Finish to close the dialog box.
    The Show Logs dialog bow displays to list imported and rejected metadata, if any.
  5. Click OK to close the dialog box.
    The imported metadata displays under the DB connections node in the Repository tree view.