Database Reference
In-Depth Information
9. If all the values mentioned by you are correct, the test connection will be success-
ful.
With this, we have added a new database connection to our repository, and we can import
the tables using the new connection.
You can add different type of databases to your repository. This is just a one-time process
that you need to perform before you can start using the tables.
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 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
screen, navigate to
Tools
|
Source Analyzer
to open the Source
Analyzer tool.
2. Navigate to
Sources
|
Import from Database
:
