Problem Statement:
This article contains assistance in setting up the ShowCase 9.1 integration with JD Edwards World, OneWorld and EnterpriseOne.
Solution:
Note: In our examples which follow, we reference a typical JDE EnterpriseOne 9.0 installation and SUP9104 as the ShowCase Server Library name.
The process actually begins when ShowCase is installed on the iSeries. One of the parameters that the installer is prompted for is whether support for JD Edwards should be enabled. If the installer initially replied no, but now wishes to change that, they must reinstall ShowCase.
To verify that JDE Edwards was enabled, review the install.properties file located within your ShowCase server library and make sure SCINSTYPE=*JDE. Issue the command: WRKLNK 'sup9104\install.properties, press ENTER, and then select Option 5=Display to display the fololowing screen:
Note: If SCINSTYPE=*SC, then you will need to reinstall the ShowCase Server. At this point, users who have both JD Edwards and iSeries profiles should be recognized as JD Edwards users.
Set JDE OneWorld/E1 Attributes (SETJDEOWA) Command
This command is required before non-iSeries user profiles will be recognized by ShowCase. It configures the Warehouse Manager Server on the iSeries for JDE OneWorld or EnterpriseOne integration. The command has a number of parameters, each of which will be discussed in this article.
The SETJDEOWA can only be run for one valid installation of JD Edwards OneWorld or EnterpriseOne per ShowCase Server. This means whichever version of the JD Edwards application (XE, 8.0, 8.12, 9.0, 9.1) that SETJDEOWA has been run for is the only version recognized by ShowCase.
The print screen below contains all parameters for SETJDEOWA, which are explained below:
SETJDEOWA Command Parameters:
JDE Release (JDEOWRLS): Enter the JDE OneWorld or EnterpriseOne release installed on this IBM i system.
*XE - enables ShowCase to operate with JDE OneWorld XE
*ERP8.12 - enables ShowCase to operate with JDE EnterpriseOne 8.12
*ERP9.0 - enables ShowCase to operate with JDE EnterpriseOne 9.0
*ERP9.1 - enables ShowCase to operate with JDE EnterpriseOne 9.
JDE System Library (JDEOWSYSLB): Enter the name of the JDE OneWorld or EnterpriseOne system library. This is the name of the library where JDE system control files reside. When you are entering this value, pressing F4 provides a list of possible library names. You can search the system for the JDE system library or explicitly specify the library name. The system library will include the F98OWSEC file, which contains a list of enabled JD Edwards application users.
Use JDE Application Security (APPSECOPT): This option enables or disables the JDE OneWorld or EnterpriseOne application security integration feature. (*DISABLE is the default setting). Enabling application security forces the honoring of any OneWorld or EnterpriseOne application security for tables that the OneWorld or EnterpriseOne administrator has set up for users and groups.
The possible values are:
*ENABLE - JDE Application Security Integration is enabled. Application security defined in JDE OneWorld or EnterpriseOne will be honored. (A server restart is required.)
*DISABLE - Application security defined in JDE OneWorld or EnterpriseOne will not be honored. (A server restart is required.).
Run Authority Override (RUNAUTHOVR): Controls how application security is applied for tables that are shared by multiple OneWorld or EnterpriseOne applications. The Run Authority Override parameter only applies to the enabling of application security. If two OneWorld or EnterpriseOne applications use the same database table, and the application security conflicts (the user is authorized to one OneWorld or EnterpriseOne application but not to the other), this option allows the administrator to select the default authorization for the application in question.
If this parameter is set to *YES, the table is available to the user if the user has run authority for at least one application that uses the database table. If this parameter is set to *NO, the user is restricted from the database table if the user is restricted from at least one application that uses the database table. The default value is *YES.
JDE Application Users (SNGLUSRPRF): This prompt allows you to enable or disable JDE OneWorld or EnterpriseOne Application User signon.
*ENABLE - JDE application user signon is enabled. (A server restart is required.)
*DISABLE - JDE application user signon is disabled. (A server restart is required.)
Authentication System Name (AUTHSYSNAM): This is the name of the IBM i system used to authenticate the JDE OneWorld or EnterpriseOne user.
*LOCAL - The authentication system is the local IBM i system.
Character Value - The name of the authentication IBM i system.
Authentication User (AUTHSYSUSR): This is the IBM i database user used to authenticate the JDE OneWorld or EnterpriseOne user.
*NONE - The database user is not required (only for a local IBM i system).
Character Value - The user profile for the IBM i system used for JDE OneWorld or EnterpriseOne authentication.
Authentication Password (AUTHSYSPWD): This is the iSeries database password used to authenticate the JDE OneWorld or EnterpriseOne user.
*NONE - The database password is not required (only for a local IBM i system).
Character Value - The password for the IBM i system used for JDE OneWorld or EnterpriseOne authentication
JDE Program Library (JDEOWPGMLB): Enter the name of the JDE OneWorld or EnterpriseOne program library. This is the name of the library where JDE program files reside. If you are using remote authentication, specify the name of the program library on the remote IBM i system. Otherwise, specify the name of the program library on the local IBM i system. When entering this value, pressing F4 provides possible library names. The program library includes the JDEKRNL program, which contains the API that ShowCase uses for JD Edwards recognition.
JDE Remote System Library (JDEOWRSYLB): This is the name of the JDE OneWorld or EnterpriseOne system library on a remote IBM i system when using the remote system for authentication.
*LCLSYSLB - The name is the same as the local JDE OneWorld or EnterpriseOne system library.
Character Value - The name of the JDE OneWorld or EnterpriseOne system.
IASP Name (IASPNAME): This is the name of the IASP where JDE OneWorld or EnterpriseOne libraries reside.
*NONE - JDE OneWorld or EnterpriseOne libraries are not stored on an IASP.
Character Value - The name of the IASP where JDE OneWorld or EnterpriseOne libraries reside.
IASP User (IASPUSER): This is the user profile for ShowCase to access JDE OneWorld or EnterpriseOne libraries on the IASP.
*NONE - JDE OneWorld or EnterpriseOne libraries are not stored on an IASP.
Character Value - The IBM i user profile used for ShowCase Reporting to access JDE OneWorld or EnterpriseOne libraries on the IASP.
IASP Password (IASPPASS): This is the password for the IBM i user profile for ShowCase Reporting to access JDE OneWorld or EnterpriseOne libraries on the IASP.
*NONE - JDE OneWorld or EnterpriseOne libraries are not stored on an IASP.
Character Value - The password for the IBM i user profile for ShowCase Reporting to access JDE OneWorld or EnterpriseOne libraries on the IASP.
Once SETJDEOWA has been run, any OneWorld users trying to connect to ShowCase will not be recognized as JDE OneWorld users. Note: SETJDEOWA requires that the iSeries interactive job CCSID is not set to 65535 (*HEX).
