Configuring Database Connection

Configure the database before running SmartMapper command-line tools, if you want to save the manual typing works for all parameters each time you connect to the database.

TIBCO ActiveMatrix BusinessWorks Plug-in for SmartMapper provides a db.properties file to set up database configurations. Therefore, each time the SmartMapper tools are run, you are only required to enter the database alias which points to the database that you want to use.

Procedure

  1. Locate the db.properties file in the TIBCO_HOME\bw\palettes\smartmapper\7.1\tools directory.
  2. Open the db.properties file. The supported database types are MySQL, Oracle, and Microsoft SQL Server. For more details, see the readme file.
  3. Set up database connection parameters according to the information listed in the following table.
    Database Property Description
    *.type The type of the database.
    *.driver The name of the driver class.
    *.url The URL to use to connect to the database.
    *.username The username to use when connecting to the database.
    *.password The password to use when connecting to the database.
    Note: The asterisk (*) represents the alias of the database. It can be any character you want to use and cannot be omitted, which is used to locate the database. In the given example, the database alias is mysql.
  4. Save your configurations.