Documentation Center

Creating the Aggregation Database using the Database Manager tool

You can use the SDL Tridion Database Manager tool to create a Microsoft SQL Server or Oracle database.

Before you begin

The prerequisites for the Aggregation Database are the same as the Content Manager Database. The SDL Tridion Database Manager tool will prompt you to provide database details which you will need when you run the installer to install Online Marketing Explorer.

Procedure

  1. Access the Online Marketing Explorer installation media.
  2. Navigate to the Database\ directory.
  3. Run the executable called DatabaseManager.exe.
  4. Select New Database in the startup screen.
  5. Select Aggregation Database and click Next.
  6. Follow the instructions in the wizard to create the database. The following default values are provided:
    • For Microsoft SQL Server, the default Database name is Tridion_Agg and the default Username is AFUSER.
    • For Oracle, the default Schema name is AFUSER

Results

You have created the Aggregation database.