Data Requester MSSQLDataRequester: Setting Up the Project

Before running the project, you must set it up.

Prerequisites

  • Run the database script - MSSQLDataRequester.sql, located in the TIBCO_HOME/bw/palettes/adb/version_number/Samples/Data Requester directory.
  • Import the MSSQL_DataRequester 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.mssql.SQLServerDriver.
    4. Set the value of the dbUrl field to the database URL name. For example: jdbc:tibcosoftwareinc:sqlserver://<host>:<port>;DatabaseName=<databaseName>
  4. From the menu bar, click File > Save to save the project.