Overview of the Set Up Process

How to:

The setup process is comprised of the following basic steps:

  1. Add the Adapter for JD Edwards World to the server configuration.
  2. Refresh the metadata repository.
  3. Create an Application directory to contain Master Files. You can use the APP MAP command to assign an application name to a non-approot directory anywhere in the file system. For information about this command, see Creating and Working With Applications in the Server Administration for UNIX, Windows, OpenVMS, i5/OS, and z/OS manual.

    On the i5/OS platform this step is not necessary because the default baseapp application must be used in all cases.

  4. Create the JD Edwards World synonyms from the Web Console. To create the required synonyms, use the synonym creation facility for the Adapter for DB2.

    For details on creating the synonym, see Synonym Creation Parameters for DB2.

  5. Convert synonyms.
  6. Configure security options.

    For a detailed description of this process, see How to Set Up the Adapter for JD Edwards World From the Web Console and How to Set JD Edwards World Security.

Note that this process is not supported from the Data Management Console since the adapter runs only on i5/OS, where the DMC is not available.
Top of page
x
Procedure: How to Set Up the Adapter for JD Edwards World From the Web Console
x

To configure the adapter from the Web Console:

  1. From the Web Console menu bar, click Adapters.

    The Adapters folder opens.

  2. Expand the Available folder, if it is not already expanded.
  3. Expand the ERP group folder, then expand the JD Edwards World folder and click a connection.

    The Add JD Edwards World to Configuration pane opens.

  4. Leave Security options unchecked (OFF) at this point. You will add them as the final step in this process.
  5. Select a profile from the drop-down list to indicate the level of profile that the server is running: global, service, group, user. The standard server global profile, edasprof.prf, is the default.
  6. Click Configure.

    The adapter is added to the Configured folder in the navigation pane.

  7. You are now ready to refresh metadata. Right-click the configured JD Edwards World adapter and select Refresh Metadata Repository. The Refresh Metadata Repository pane opens.
    1. In the JD Edwards World Version field, choose 7.x or 8.x.
    2. Enter the location of each of the following JDE files in the space provided. Only the library name is needed.

      For Version 7

      For Version 8

      File Use

      F0004 Library

      F0004 Library

      Contains JDE user-defined code types

      F0005 LIbrary

      F0005 LIbrary

      Contains JDE user defined codes file

      F9202 Library

      F9202 Library

      Contains JDE data field specifications

      F9201 Library

      F9210 Library

      Contains JDE data field display text
    3. Click Submit to create the files.
  8. Create synonyms for the tables you plan to report on using the Adapter for DB2.
  9. You are now ready to convert synonyms for JD Edwards World. From the Adapters list in the navigation pane, click JD Edwards World, and select Convert Master Files from the menu. The Master Files Conversion pane opens at Part 1 of 2.

    From the drop-down list, select the application in which you created the DB2 synonyms, then click Next.

  10. On the second Master Files Conversion pane:
    1. Select a date format from the drop-down list. The options are: YMD, YYMD, DMY, MDY, MDYY, DMYY, MYY, YYM. (YYMD is the default setting.) The selected format will be used only if the field is described as a DATE in the Data Dictionary.
    2. Click the Presumptive Joins check box to include additional DEFINEs (virtual fields) for presumptive join fields in the synonym.
    3. Select Long (the default) for Fieldnames to display the field descriptions as names on reports; select Short Fieldname to use the JDE aliases as field names on reports.
    4. Enter the appropriate Language Code, which exists in the JDE F9292 file. (Leave the field blank for English.)
    5. Select N for Redefines. (Y is used only for compatibilty with earlier releases.)
    6. Check the UDC box to ensure that UDC description fields are generated as DEFINEs (virtual fields) in the synonym.
    7. Check the Combine UDC box if it is needed for compatibilty with earlier releases.)
    8. Under Options, do one of the following:

      Click the Select Master File from a list radio button, then from the drop-down list either select a file or choose All.

      or

      Click the Enter specific filename to process radio button and type a file name in the box provided.

  11. Click Convert Master File(s) to start the conversion. A message is displayed when the process is successfully completed.
  12. The final step is setting JD Edwards World security options.

    For details, see How to Set JD Edwards World Security.

iWay Software