Data Merger OracleDataMergerParentChild: Setting Up the Project

Before running the project, you must set it up.

Prerequisites

  • Run the database script - Oracle_DataMerger_ParentChild.sql, located in the TIBCO_HOME/bw/palettes/adb/version_number/Samples/Data Merger/ParentChild directory in the following order:
  • You have to import the OracleDataMergerParentChild project before setting it up. For more information, see Importing a Sample Project.

Procedure

  1. Expand the imported project in the Project Explorer view.
  2. Expand the Module Descriptors resource, and then double-click Module Properties.
  3. In the Module Properties panel, complete the following tasks:
    1. Set the value of the userName field as the username of the database.
    2. Set the value of the password field to access the database.
    3. Set the value of the dbDriver field to the database driver name. For example: tibcosoftwareinc.jdbc.oracle.OracleDriver
    4. Set the value of the dbUrl field to the database URL name. For example: jdbc:tibcosoftwareinc:oracle://<host>:<port>;ServiceName=<serviceName>
  4. From the menu bar, click File > Save to save the project.