Skip to main content Skip to complementary content

Importing database metadata

Availability-noteDeprecated

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.
Generated CSV file.
Information noteNote:
  • 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 column.

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.
    Import connections from CSV option selected by right-clicking.
    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.
    Import connection tables from a CSV file dialog box.
  4. Click Finish to close the dialog box.
    The Show Logs dialog bow displays to list imported and rejected metadata, if any.
    Show Logs dialog box.
  5. Click OK to close the dialog box.
    The imported metadata displays under the DB connections node in the Repository tree view.
    Imported metadata displayed in the Repository tree view.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!