Refreshing the Metadata Repository
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 anyMaster Files (synonyms).
x
Procedure: How to Refresh the Metadata Repository on Windows
From the Adapters list in the navigation
pane on the Web Console or the Adapters tab in the Data Management
Console:
-
Click the
configured JD Edwards EnterpriseOne adapter.
-
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.
-
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.
-
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 SQLODBC: owner
- For DB2: [location.]owner
- For SQLORA: owner
-
In the Connection
input boxes, enter the same connection name you used when configuring
the selected DBMS.
-
Click Submit.
The refresh occurs transparently. A message indicates that the process
has been successful.
x
Procedure: How to Refresh the Metadata Repository on i5/OS
From the Adapters list in the navigation
pane on the Web Console or the Adapters tab in the Data Management
Console:
-
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.
-
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.
-
Click Refresh
Now.