Working with relational database tables - the Import option

We will first start working on the relational tables. You can import or create the table structure in the Source Analyzer. After you add these source definitions to the repository, you use them in a mapping.

Perform the following steps to import the table source definition:

1. In the Designer, go to Tools | Source Analyzer to open the Source Analyzer.
2. Go to Sources | Import from Database.

1. From the ODBC data source button, select the ODBC data source that you created to access source tables.
2. Enter the username and password to connect to the database. Also, enter the name of the source table owner, if necessary.
3. Click on Connect.
4. In the Select tables list, expand the database owner and the TABLES heading.
5. Select the tables you wish to import, and click on OK.
   

The structure of the selected tables will appear in the workspace as shown in the following screenshot:

We will now have a look at working with the Import option.