Importing database metadata - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-13

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:
Name;Purpose;Description;Version;Status;DbType;ConnectionString;Login;
Password;Server;Port;Database;DBSchema;Datasource;File;DBRoot;TableName;
OriginalTableName;Label;OriginalLabel;Comment;Default;Key;Length;
Nullable;Pattern;Precision;Talend Type;DBType.
Note:

-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:

Procedure

  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.