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
any Master 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 folder of the Data Management Console:
-
Right-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 DB2: [location.]owner
- For SQLORA: owner
-
In the Connection
input boxes, enter the same connection name you used when configuring
the selected DBMS.
-
Click Refresh
Now. The refresh occurs transparently. A message indicates
the process was successful.
x
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:
-
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.