Creating Synonyms for JD Edwards EnterpriseOne

Before you can use the Adapter for JD Edwards EnterpriseOne, you must create synonyms for the data you will be reporting against using one of the data adapters that is supported on your platform, and set the paths required to access those synonyms:

Procedure: How to Create Synonyms for JD Edwards EnterpriseOne

From the Web Console or the Data Management Console:

Configure the adapter you wish to use to create synonyms for the JD Edwards EnterpriseOne data.
Use the configured adapter to create synonyms for the JD Edwards EnterpriseOne tables you wish to use. During this process, you will select the tables for which you wish to create synonyms and specify the application in which the tables will be stored.

For details about configuration and synonym creation steps for supported data adapters, see Using the Adapter for DB2, Using the Adapter for Microsoft SQL Server, or Using the Adapter for Oracle.

Reference: Ensuring Master File Compatibility Between i5/OS and Windows

Before you begin the configuration procedure, it is advisable to consider whether you have procedures that were designed to run on the i5/OS platform, which you may wish to run in a Windows environment. If you anticipate this need, your first task is to synchronize the Master Files generated on Windows with those generated on i5/OS using the amper variable &MFDCOMP in the jdegdinc.fex file.

The default variable setting is:

-DEFAULT &MFDCOMP='N';

To ensure matching field names on i5/OS and Windows, revise the setting to:

-DEFAULT &MFDCOMP='Y';