Enterprise Data Manager Guide

6.4.4
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Importing Metadata from the Database

Import metadata from the source database to the ILM repository. You must import metadata before you can run an archive or retirement job.

For SAP application retirement, you must initiate the metadata import from a customer-defined application. Run the Copy Application Version for Retirement job to copy the pre-packaged SAP application to a customer-defined application.

To import metadata from any database, a user must have the Import Metadata system-defined role. For more information, see the

Data Archive Administrator Guide

You must also configure the "informia.enable.mining" property in the

conf.properties

file. For more information, see the

Data Archive Administrator Guide

Select an application version and click

File

Import Metadata from Database

The

Connect to Import Metadata from Database

dialog box appears.

Enter the connection details.

To create a connection for Informix sources, use the following syntax for the service name:

<server_name>;databasename=<dbname>

Click

The

Import Metadata from Database Wizard

appears.

Select the schemas to import metadata from.

Click the down arrow button to insert the tables in to the Selected box. Use the control keyboard options to select multiple tables or all tables.

Tables that have special characters in the table name, do not appear in the list. Special characters include:

, and

Click

Choose one of the following options to run the job:

Submit Import Metadata as a Background Job

. Runs the job in the background. If you run the job in the background, you can continue to perform other tasks. Run the job in the background if you have a large volume of metadata to import and to avoid memory errors.

Required to import metadata from SAP applications.

Continue Import Metadata through EDM

. Runs the job in the foreground. If you run the job in the foreground, you must wait until the job completes to perform an other task. Additionally, if you run the job in the foreground and you have a large volume of metadata to import, you may receive memory errors. You may want to run the job in the foreground if you have a low volume of metadata to import.

Click

Enter the mining parameters.

To import metadata from databases for SAP applications, select

SAP Application Metadata

. The Import Metadata job runs steps that are specific to SAP applications. If you import from SAP applications and do not select the parameter, the job will not import metadata for pool tables, cluster tables, and tables that store data in ADK files.

Click

Finish

Click

Basic Operations

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal