Configuring the Tracking database for the Audience Manager service

Configure your Tracking database in the Storage Layer configuration file, cd_storage_conf.xml, in the configuration location of the Audience Manager Service.

Procedure

  1. Open the cd_storage_conf.xml configuration file.
  2. In the <ItemTypes> element, add the following <Item> element:
    <Item typeMapping="AudienceManagerTracking" storageId="TRACKDBID"/>
    where TRACKDBID is the ID of the Tracking database where data is stored.
  3. In the <Storages> element, add the following <StorageBindings>:
    <StorageBindings>
      <Bundle src="AudienceManagerTrackingDAOBundle.xml" />
    </StorageBindings>
  4. In the <Storages> element, configure the Outbound E-mail Tracking database:
    • For Microsoft SQL database:
      <Storage Id="trackingdb" Class="com.tridion.storage.persistence.JPADAOFactory" Type="persistence" dialect="MSSQL">
      	<Pool CheckoutTimeout="120" IdleTimeout="120" MonitorInterval="60" Size="5" Type="jdbc"/>
      	<DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource">
      		<Property Name="serverName" Value="localhost"/>
      		<Property Name="portNumber" Value="1433"/>
      		<Property Name="databaseName" Value="tridion_tracking"/>
      		<Property Name="user" Value="TMSPSUSER"/>
      		<Property Name="password" Value="PASSWORD"/>
      	</DataSource>
      </Storage>
    • For Oracle database:
      <Storage Id="trackingdb" Class="com.tridion.storage.persistence.JPADAOFactory" Type="persistence" dialect="ORACLESQL">
      	<Pool CheckoutTimeout="120" IdleTimeout="120" MonitorInterval="60" Size="5" Type="jdbc" />
      	<DataSource Class="oracle.jdbc.pool.OracleDataSource">
      		<Property Name="driverType" Value="thin" />
      		<Property Name="networkProtocol" Value="tcp" />
      		<Property Name="serverName" Value="servername" />
      		<Property Name="portNumber" Value="1521" />
      		<Property Name="databaseName" Value="databasename" />
      		<Property Name="user" Value="TMSPSUSER" />
      		<Property Name="password" Value="PASSWORD" />
      	</DataSource>
      </Storage>

      If you are connecting to Oracle RAC, use the property name serviceName instead of databaseName.