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;TalendType;DBType.
-it is recommended to use either TalendType 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:
In the Repository tree view, expand the Metadata node and right-click Db connections.
In the contextual menu, select Import connections from CSV.
The [Import connections from CSV] dialog box displays.
Click Browse... and go to the CSV file that holds the metadata of the database connection.
Click Finish to close the dialog box.
The [Show Logs] dialog bow displays to list imported and rejected metadata, if any.
Click OK to close the dialog box.
The imported metadata displays under the DB connections node in the Repository tree view.