Import data sources from PowerCenter, the Model repository, or from an external database to a project in Test Data Manager.
To view a list of the projects in Test Data Manager, click
Projects
.
Click a project in the list to open it.
Click
Actions
Import Metadata
.
The
Import Metadata
window appears.
Choose one of the following options:
PowerCenter Repository. Import metadata from PowerCenter.
Model Repository. Import metadata from the Model repository.
Datasource Connection. Import metadata from a database connection.
To import metadata from a flat file source or a JDBC connection, you must import metadata from the Model repository
Choose whether you want to review the metadata changes before you import the data sources. Test Data Manager displays the information before the import runs. You can choose to skip the import option.
Test Data Manager shows you the metadata you are importing and the impact on rules and domain assignments or entities and groups in Test Data Manager.
Optional. If you select an Oracle database connection, you can choose to ignore the tables that do not contain any data.
Test Data Manager excludes all the empty tables in the Oracle database and lists the tables that contain data.
Click
Next
.
Choose one of the following options:
If you selected
PowerCenter Repository
, select the PowerCenter folder that contains the data source you want to import. You can filter folders by the folder name or the description.
If you selected
Model Repository
, select the Model Repository folder that contains the data source you want to import. You can filter folders by the folder name or the description.
If you selected
Datasource Connection
, select the schema to import. You can filter schemas by schema name.
Click
Next
.
Select the files or tables that you want to import. You can filter the tables by data source, table name, or table description. If you choose a Hive database and if there are temporary junk tables present in the schema, ensure that you do not select those tables.
Click
Next
.
Choose when to import the sources. Choose one of the following options:
Import Now. Import the data source immediately. To run the import in the background, select
Run import in the background
.
Schedule Later. Schedule the import to occur at a specific date and time. Click the calendar to select a date. Use the hour and minute sliders to set the time.
Click
Finish
.
The
Import Progress
dialog box appears with the import progress bar.
If you chose to review metadata changes before importing, the
Impact Review
dialog box appears with the metadata, assignments, and project objects. Review the impact, and click
Approve
to approve the changes or click
Reject
to reject the changes. If you approve the changes, TDM imports the metadata successfully.
After the job finishes, access the imported metadata through the