Importing metadata into the metadata repository
You import metadata when you want to add metadata into the metadata repository for use in projects. Imported metadata is viewable by all suite users and can be used by all suite components.
About this task
Before you can import metadata, you must know how to connect to the data source. The metadata is obtained from the data source. You can use Source Configuration to connect to the data source. After you create the connection, you can use the connection to import metadata into the metadata repository. You import metadata only if the data sources that you want to use in your mapping specification are not yet in the metadata repository.
You must have the role of FastTrack Common Metadata Administrator in order to create, delete, or update any physical data, such as hosts, databases, schemas, tables and columns, and to import metadata and create a new connection.
Procedure
- Click on the Workspace Navigator.
- Select the connection to the metadata and provide the database access ID and password that is required to access the data source.
- Expand the hierarchical tree to view the metadata that you want to import. You can import schemas or tables.
- Select the metadata that you want to import by pressing the Shift key or Ctrl key and clicking each one. From the Task list, click Import Metadata.
- Select an Existing Host or New Host. If you select New Host, provide a name for the new host. Click Next.
- Select an Existing Database or New Database. If you select New Database, provide a name for the new database.
- Click Finish.