Reporting Server > Using the Adapter for JD Edwards EnterpriseOne > Refreshing the Metadata Repository

Refreshing the Metadata Repository

How to:

The Metadata repository contains the dictionary information for the JD Edwards EnterpriseOne tables.

You must refresh the repository the first time you set up the adapter and repeat the process each time the JD Edwards EnterpriseOne tables change. (At most sites, changes occur infrequently.)

Important: This step must be done before you convert any Master Files (synonyms).

Procedure: How to Refresh the Metadata Repository on Windows

From the Adapters list in the navigation pane on the Web Console or the Adapters folder of the Data Management Console:

  1. Right-click the configured JD Edwards EnterpriseOne adapter.
  2. Choose Refresh Metadata Repository from the menu. The Refresh Metadata Repository pane opens. The JDE tables required for this procedure are listed in the first column.
  3. For each table, select the suffix of a previously configured DBMS from the drop-down list.

    Note: The listed tables may be associated with different DBMSs.

  4. In the Qualifier input boxes enter the qualifier associated with each table, using the syntax required for the selected DBMS:
    • For SQLMSS: [database.]owner
    • For Db2: [location.]owner
    • For SQLORA: owner
  5. In the Connection input boxes, enter the same connection name you used when configuring the selected DBMS.
  6. Click Refresh Now. The refresh occurs transparently. A message indicates the process was successful.

Procedure: How to Refresh the Metadata Repository on IBM i

From the Adapters list in the navigation pane on the Web Console or the Adapters folder of the Data Management Console:

  1. Right-click the configured JD Edwards EnterpriseOne adapter and select Refresh Metadata Repository.

    You will need to perform this step initially, and repeat it only if there are changes in the metadata for tables. This occurs infrequently at most sites.

    The Refresh Metadata Repository pane opens. The JDE tables required for this procedure are listed in the first column.

  2. For each table, select the suffix of a previously configured DBMS from the drop-down list.

    Note: The listed tables may be associated with different DBMSs.

  3. Click Refresh Now.

 WebFOCUS

Feedback