If you have already created a database connection in Talend Studio, you
can import this connection into Talend Data Mapper to
generate structures and use this database in maps.
Before you begin
- You are using the non-Eclipse runtime. This feature is not supported by the old
Eclipse-based runtime.
- You have created a database connection in Talend Studio. For more information, see Setting up a database connection.
- Your database is supported by Talend Data Mapper. For more information, see Working with databases.
Procedure
-
In the
Mapping
perspective of Talend Studio, right-click and click .
The next steps are also available when you click .
-
Select Database From Studio and click
Next.
-
Select the database connection that you want to import and click
OK, then click Next.
All database connections appear in the list, even if they are not supported by
Talend Data Mapper. If you select an unsupported database, you will get an error message.
-
Click Test Connection to make sure the connection works
and click Next.
-
Select the tables that you want to import and click
Next.
-
Select the folder in which you want to import the table structures and click
Next, then click Finish.
Results
Your database connection has been created in
Talend Data Mapper and
the selected tables have been imported as structures.
