Setting Up Integrations in the Integration Server

This chapter provides overviews of the Integration Server, integration options, and cross references, and discusses how to:

Click to jump to parent topicUnderstanding the Integration Server

The Integration Server is the primary engine for the carrying out of integration logic. It is the connection point between PeopleSoft Enterprise and the JD Edwards EnterpriseOne system.

The Integration Server hosts packages that contain flow services (method-like units that operate on documents) and related files, which retrieve data from one system (PeopleSoft Enterprise or JD Edwards EnterpriseOne), transform the data as necessary, and pass the data to another system.

Click to jump to parent topicUnderstanding Integration Options

Integration options enable you to customize values that are used by the integration flows and interface flows.

The JD Edwards EnterpriseOne WSG system supplies default soft-coded values for some integration options. You can modify the values for the integration options if the default values are not appropriate for the environment. It is important that integration options are set up with appropriate values in order for the integration to function correctly in the environment.

You set up integration options using the Configuration Editor tool that is included with the Integration Server.

Click to jump to parent topicUnderstanding Cross-References

Many of the JD Edwards EnterpriseOne application integrations with PeopleSoft Enterprise applications use cross references. You set up cross references in the JD Edwards EnterpriseOne WSG cross-reference database. These integrations use two different types of cross references: key and code.

Key cross references enable the system to reconcile the values used in the PeopleSoft Enterprise system and the JD Edwards EnterpriseOne system and to keep a record of the values that have been integrated. Some key cross references are created automatically by the system while some must be set up manually.

Code cross references enable the system to reconcile the values used in the PeopleSoft Enterprise system and the JD Edwards EnterpriseOne system. Code cross references must be set up manually.

You can set up and view cross references using the Configuration Editor tool that is included with the Integration Server.

Click to jump to parent topicSetting Up Dependent Packages

The Integration Server hosts dependent packages that must be enabled in order for integrations to function. For JD Edwards EnterpriseOne application integrations with PeopleSoft Enterprise applications, enable these dependent packages:

Dependent Package

Usage

PSFT_Utils

Provides utility functions.

PSFT_E1_Adapter

Performs queries on the JD Edwards EnterpriseOne database.

PSFT_Dispatcher

Communicates with the PeopleSoft Enterprise Integration Broker for transporting messages.

PSFT_XRefAndSoftCoding

Provides cross-referencing services.

PSFT_JD Edwards EnterpriseOne_AdapterServices

Communicates with the PSFT_E1_Adapter to perform queries on the JD Edwards EnterpriseOne database, calls JD Edwards EnterpriseOne functions, or reads JD Edwards EnterpriseOne realtime events.

PSFT_JDBCAdapterServices

Provides database connectivity for cross-referencing services.

Click to jump to parent topicSetting Up the JD Edwards EnterpriseOne Adapter

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up the JD Edwards EnterpriseOne Adapter

Access these pages in the Integration Server application.

Page Name

Navigation

Usage

JD Edwards EnterpriseOne Adapter Connections

Adapters, JD Edwards EnterpriseOne Adapter

Enable the JD Edwards EnterpriseOne Adapter.

JD Edwards EnterpriseOne Adapter Listener

Adapters, JD Edwards EnterpriseOne Adapter, Listeners

Enable the JD Edwards EnterpriseOne Adapter Listener.

JD Edwards EnterpriseOne Adapter Listener Notifications

Adapters, JD Edwards EnterpriseOne Adapter, Listener Notifications

Enable the JD Edwards EnterpriseOne Adapter listener notifications.

Click to jump to top of pageClick to jump to parent topicEnabling the JD Edwards EnterpriseOne Adapter

Access the JD Edwards EnterpriseOne Adapter Connections page.

If the JD Edwards EnterpriseOne and the JD Edwards EnterpriseOne Event connections are not already enabled, click No in the Enabled column for each connection to change it to Yes.

Click to jump to top of pageClick to jump to parent topicEnabling the JD Edwards EnterpriseOne Adapter Listener

Access the JD Edwards EnterpriseOne Adapter Listeners page.

  1. For each listener that needs to be enabled, click the word No in the Enabled column to change it to Yes.

  2. If Pending enable appears, click Listeners under JD Edwards EnterpriseOne Adapter in the navigation pane.

Note. You will likely need to bounce (deactivate and reactivate) the listener after deactivating or activating a listener notification for the change to take effect.

Click to jump to top of pageClick to jump to parent topicEnabling JD Edwards EnterpriseOne Adapter Listener Notifications

Access the JD Edwards EnterpriseOne Adapter Listener Notifications page.

For each listener notification that needs to be enabled, click the word No in the Enabled column to change it to Yes.

See the chapter for your specific integration for a list of required listener notifications for that integration.

Click to jump to parent topicSetting Up Integration Options and Cross References

This section discusses how to:

See Also

JD Edwards EnterpriseOne Tools 8.96 Web Services Gateway Guide: Configuration Editor, "Using the Configuration Editor,”

Click to jump to top of pageClick to jump to parent topicSetting Up Integration Options

To set up integration options:

  1. Access the Integration Server.

  2. Click Management under Packages.

  3. Click the Home button for the PSFT_ConfigurationEditor package.

  4. On the Configuration Editor page, click Integration Options.

  5. In the left pane, navigate to the integration option that you want to set up and click the last entry in the navigation.

  6. In the right pane, click the Edit button for the integration option you want to change.

  7. Enter a value for the integration option in the Value field and then click Save.

  8. When you are finished setting up integration options, click the Close Window link in the upper-right corner of the Configuration Editor page.

Click to jump to top of pageClick to jump to parent topicSetting Up Cross References

To set up cross references:

Click to jump to parent topicSetting Up for High-Volume Transactions

To efficiently process the high volume of transactions involved in this integration, you should configure the JDBC Adapter and the Integration Server with the specific settings explained in this section.

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up for High-Volume Transactions

Access these pages in the Integration Server application.

Page Name

Navigation

Usage

Edit Connection (for the JDBC Adapter)

Adapters, JDBC Adapter

Click Edit on the PSFT_JDBCAdapterServices.
JDBCAdapterServices.connection:
connectToDB row.

Set Connection Management Properties for the JDBC Adapter connection.

Edit Connection (for the JD Edwards EnterpriseOne Adapter)

Adapters, JD Edwards EnterpriseOne Adapter

Click Edit on the appropriate connection row.

Set Connection Management Properties for a JD Edwards EnterpriseOne Adapter connection.

Click to jump to top of pageClick to jump to parent topicSetting Connection Management Properties for the JDBC Adapter

Access the Edit Connection page for the JDBC Adapter.

Note. You set up Connection Management Properties for the JDBC Adapter before you enable the PSFT_JDBCAdapterServices package.

Set the Connection Management Properties for the PSFT_JDBCAdapterServices connection in this way:

Enable Connection Pooling

true

Minimum Pool Size

5

Maximum Pool Size

30

Pool Increment Size

5

Click to jump to top of pageClick to jump to parent topicSetting Connection Management Properties for the JD Edwards EnterpriseOne Adapter

Access the Edit Connection page for the JD Edwards EnterpriseOne Adapter.

Note. Set up Connection Management Properties for the JD Edwards EnterpriseOne Adapter before you enable the PSFT_JD Edwards EnterpriseOne_AdapterServices package.

Set the Number of milliseconds before a manual transaction expires field to 1200000.

Click to jump to top of pageClick to jump to parent topicSetting the Integration Server Memory Size

Access the server.bat file.

The server.bat file is typically located in . . . \IntegrationServer\bin\server.bat.

Specify the minimum and maximum size of the Integration Server in this way:

SETLOCAL set JAVA_MIN_MEM=512M set JAVA_MAX_MEM=1024M