To Create and Configure the Oracle External System

1. On Enterprise Designer, on the Environment Explorer tree, right-click envA (envB for Berlin) and, on the context menu, click New Oracle External System.

2. Name the new component esOracleand click OK.

   These actions create, for the current Environment, an external system instance for the Oracle eWay in outbound mode.

   ---

   Note –

   The eXchange database uses Oracle. For more information on Oracle requirements for eXchange and ASC X12 PM, see the Readme file that accompanies ASC X12 PM.

   ---

3. Right-click esOracleand select Properties from the context menu.

   The Properties dialog box for the external system appears. See the figure below.

   

4. Configure the Configuration ⇒ Outbound Oracle eWay ⇒ JDBC Connector settings properties for esOracle as follows:

   • Description: Oracle Connection Pool Datasource

   • ServerName: Host name of the Oracle server machine

   • PortNumber: 1521 (change this value only if your Oracle system administrator changed the default)

   • DatabaseName: SID for your current Oracle system

   • User: Valid user ID for the current Oracle system

   • Password: Valid password for the current Oracle system (masked)

   • Driver Properties: Blank, for this sample

   • Delimiter: #

   • TNS Entry: Blank, for this sample

   • MinPoolSize: 0

   • MaxPoolSize: 10

   • MaxIdleTime: 0

5. Configure the Configuration ⇒ Outbound Oracle non-Transactional eWay ⇒ JDBC Connector settings properties for esOracle as follows:

   • Description: Oracle non-Transactional Connection Pool Datasource

   • ServerName: Host name of the Oracle server machine

   • PortNumber: 1521 (change this value only if your Oracle system administrator changed the default)

   • DatabaseName: SID for your current Oracle system

   • User: Valid user ID for the current Oracle system

   • Password: Valid password for the current Oracle system (masked)

   • Driver Properties: Blank, for this sample

   • Delimiter: #

   • TNS Entry: Blank, for this sample

   • MinPoolSize: 0

   • MaxPoolSize: 10

   • MaxIdleTime: 0

6. When all properties have been configured correctly for your site, click OK.