Importing from a Database
-
Select Data Transformation folder and select Database.
and open the -
Select the directory to contain the database table structures. The default selection will put the database under the name of the database at the top level structure folder.
-
Fill in the Database Properties required to connect to the database. Once you have filled this in, press the Test Connection button to verify the connectivity to the database. If there is a problem connecting, resolve it by specifying the correct database name, user and password information, or resolving any underlying connectivity problem. Press next to continue the import. All of the tables will be imported.