IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > Oracle E-Business Suite > Configure the module for deployment

Setting connection properties for the external service wizard

For the external service wizard to connect to the database instance to discover database objects, connection properties must be specified.

Before you can configure the connection properties, start the external service wizard.

The external service wizard requires these properties to connect to the database for discovery and for creating the service description. For more information about the properties, see Connection properties for the wizard.


Procedure

  1. In the Select the Processing Direction window, select Outbound to pass data from your service import to the adapter or Inbound to pass data from the adapter to your service export, and then click Next. The Specify the Discovery Properties window is displayed.

  2. In the Specify the Discovery Properties window, specify the connection properties for the wizard to connect to the Oracle database.

    1. In the list of database software, select your product and version. The Properties area displays fields where you specify database-specific connection properties.

    2. In the JDBC driver type field, select the type of JDBC driver you want to use.

    3. In the System ID field, specify the database name.

    4. In the Host name field, specify the host name or IP address of the database server. If you specify the IP address in IPv6 format, enclose the address within square brackets ([]).

    5. In the Port number field, specify the port number for connecting to the database. If you select a named driver in the JDBC driver type field, the wizard provides a default value for the Port number field.

      If you select the driver Other, the port number is not enabled.

    6. If you select a named driver in the JDBC driver type field, the wizard provides a default value for the JDBC driver class name field and builds the value for the Database URL field from other connection fields. If you select the driver Other, you must specify the driver class name and database URL (although part of the database URL is available).

    7. In the Additional JDBC driver connection properties field, specify additional properties to be set when connecting to the database. Specify one or more name: value pairs, separated by the semicolon character (;).

      For example: 

      loginTimeout:20;readOnly:true;
securityMechanism:USER_ONLY_SECURITY

    The connection information is used only for the discovery process. Later in the wizard, you can specify different connection information to be used at run time.

  3. In the User name and Password fields, type the user name and password to use to connect to the database from the wizard. This user name is used only during the discovery process and is not saved. Later in the wizard, you can specify a different user name and password or a different authentication method to be used at run time.

  4. In the Prefix for business object names field, type a string to be placed at the beginning of business object names. This prefix field does not require a value, and can be left blank.

  5. To set additional advanced properties, click Advanced.

  6. To enable bidirectional support for the adapter at run time:

    1. In the Bidi properties area, select Bidi transformation.
    2. Set the ordering schema, text direction, symmetric swapping, character shaping, and numeric shaping properties to control how bidirectional transformation is performed.

  7. If you want to turn on AUTOCOMMIT for the database, select the Set auto commit on database connection check box.

  8. To change the location of the log files or the amount of information included in the logs, select the Change logging properties for wizard check box, and then provide the following information:

    • In the Log file output location field, specify the location of the log file for the wizard.

    • In the Logging level field, specify the severity of errors that you want logged.

    This log information is for the wizard only; at run time, the adapter writes the error messages and the trace information into the standard log and trace files for the server.

  9. Click Next.

    If the wizard generates the com.ibm.adapter.framework.BaseException exception, the adapter cannot connect to the database server. The message contains additional information about a possible cause for the problem. In addition, you can check the logs, which are in the directory specified in the Log file output location field. Make sure that the connection information is correct.


Results

The external service wizard connects to the database and displays the Find Objects in the Enterprise System window.


What to do next

Continue working in the wizard. The next step is to examine the database to locate the objects for which you want the wizard to create business objects.

Configure the module for deployment


Previous topic: Adding external software dependencies


Next topic: Configure the module for outbound processing


Related concepts:

Globalization and bidirectional transformation


Related reference:

Connection properties for the wizard