Documentation Center

Creating the Tracking database on Oracle

This task describes how to create the Tracking database on Oracle. 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 a supported Oracle client installed. For more information, see the SDL Tridion product prerequisites.

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\Oracle directory.
  3. Run the CreateTrackingDatabase.cmd file with the following parameters:
    • username—logon account with the required permissions
    • password—password of the logon account
    • instance—Oracle instance (ORACLE_SID)
    • defaulttablespace—name of the default tablespace
    • temptablespace—name of the tablespace for temporary data
    • indextablespace—name of the tablespace for indexes
    • schemaname—Online Marketing Explorer schema (optional—the default is TRACKINGUSER)
    • schemapwd—Online Marketing Explorer password (optional—the default is password)
    CreateTrackingDatabase.cmd sys password ORACLE_SID USERS TEMP INDX TRACKINGUSER 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.