Step 2. Create a TADB Database

About this task

  • Important Notes before creating a TADB Database
  • Create a TADB Database

Important Note Before Creating a TADB Database

This procedure needs to be done on SQL Servers where Tracker Query is going to be installed or upgraded, including both nodes of a cluster and also on a Historical TADB server.  

Tracker Query requires a file, mfc90.dll, in order to operate correctly.

Important: Mfc90.dll must be installed before Proficy CIMPLICITY is installed.

Do the following.


  1. Insert the Proficy CIMPLICITY CD in the CD drive on the SQL Server server.
  2. Expand ...\Setup\Microsoft\VisualStudio.
  3. Double-click vcredist_x86.exe
  4. Follow any installation instructions.

    Result: The required file will be installed.

    Note: You can also search for vcredist_x86.exe at the Microsoft Web site.

    Mfc90.dll is installed automatically on machines where CIMPLICITY is installed.

    Create a TADB Database

  5. Install Proficy SQL

    Note: If you used the Wizard to create a POMS project this step is completed. However, you can also follow all of these steps or start with 3 in this step, if you want to create and assign or assign a different existing TADB database from the one you assigned when you used the Wizard.

  6. Create a new database in the SQL Server that will be used for the TADB.
  7. Open the TrackerCfg_UI in an existing project.

    Note: The project can be on any node.

    If this is the first time you open the TrackerCfg_UI, an Options dialog box displays, in which you select the RCO database.

    Once you have selected the RCO database, a TADB Datasource Specification dialog box opens.

  8. Fill in the fields, as follows.
    Field Description
    Driver SQL Server.
    Server Name of the server that has the database.
    Database Database that was created in the SQL Enterprise
    User ID User who has access to the database.
    Password Required to access the database.
    Build Opens Data Link Properties dialog box, in which you can find or set up the server if it is not already set up. Note: Microsoft help is available for your configuration.
    Enable Historical Database At least a Standard edition of Microsoft SQL Server is required..
  9. Click OK.

    Tracker searches for and connects to the database.

  10. Actions in the remainder of this step depend on the status of the connected database.
    The database is not an established TADB or Query Engine database.
    The database is an existing TADB database with data.

    The database is not an established TADB or Query Engine database.

    The following messages display.

    1. The current not a TADB database. Do you want to create one now?

    Click Yes to create the selected database as a TADB database.

    1. The current not a Query Engine database. Do you want to create one now?

    Click Yes to create the selected database as a Query Engine database.

    1. A Configuration Login dialog box opens.
    1. Enter a user name and password that has privileges to configure Tracker.
    1. Click OK.


The TrackerCfg_UI window becomes available for configuration.


The database is an existing TADB database with data.

  1. Click the Save button  on the TrackerCfg_UI toolbar to save the configuration.
  2. Close the TrackerCfg_UI.
  3. Click the Configuration Update button on the Workbench toolbar.
  4. Re-open the TrackerCfg_UI.

If data has been imported into the TADB database a message displays.

Options are:

A Does not allow you to modify the TADB database.
If you choose this option, this message will display every time you open the TrackerCfg_UI until the PRT Item Types configuration is the same as the configuration in the SQL database.
B Updates the data in PRT Item Types. TADB configuration is used if there is a conflict or differences.
  1. Check (B) Merge display and enable update PRT Item Types with the TADB configuration.
  2. Click OK.
  3. Select PRT>Advanced>Item Types in the TrackerCfg_UI left pane.

The TADB meta data categories display in the TrackerCfg_UI PRT>Advanced>Item Types right pane.