Data Event Poller MSSQLServerPublishByReference: Setting Up the Project

Before running the project, you must set it up.

Prerequisites

  • Run the database scripts located in the TIBCO_HOME/bw/palettes/adb/version_number/Samples/Data Event Poller/PublishByReference directory in the following order:
    1. MSSQLPubByRef.cleanup.sql – cleanup script
    2. MSSQLPubByRef.sql – DDL script
    3. pubbyref_ins_ms.sql – insert script
  • Import the MSSQLPublishByReference 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.sqlserver.SQLServerDriver
    4. Set the value of the dbUrl field to the database URL name. For example: jdbc:tibcosoftwareinc:sqlserver://<host>:<port>;DatabaseName=<dbname>
    5. Set the value of the dbSchema field to the default schema name.
  4. From the menu bar, click File > Save to save the project.