Creating the Tracking database on Microsoft SQL Server

This task describes how to create the Tracking database on Microsoft SQL Server. The Tracking database stores raw data about Web site visitors interaction with Assets in online Initiatives.

Before you begin

The prerequisites for the Tracking database are the same as the Content Data Store, except Online Marketing Explorer does not support IBM DB2.

You need to run the scripts on a machine that has SQL Server Management tools installed.

About this task

Setting up your Tracking database entails running the database scripts provided. The scripts support the following scenarios:

  • You can create a new database for Tracking—strongly recommended for good database performance.
  • You can update an existing Content Data Store—for small Web sites only where overall database load is low.

Procedure

  1. Open a command prompt.
  2. Navigate to the Online Marketing Explorer installation media Database\Tracking\MSSQL directory.
  3. Run the CreateTrackingDatabase.cmd file with the following parameters:
    • username—database system administration user (mandatory)
    • password—password of the database system administration user (mandatory)
    • server—server name (optional—default is local)
    • database—name of Tracking database (optional—default is Tridion_Tracking)
    • dbuser—the Tracking database user (optional—default is TridionTrackingUser)
    • dbpwd—password of the Tracking database user (optional—default is password)
    For example:
    CreateTrackingDatabase.cmd sa password ServerName Tridion_Tracking TridionTrackingUser password
    If you specified an existing database, the database is updated otherwise a new Tracking database is created including a database user with the appropriate set of rights and permissions.
  4. Close the command prompt.