Configuring the Tracking and Subscription databases

The cd_storage_conf.xml file is the Content Delivery Storage Layer configuration file. You need to configure your Tracking and Subscription databases in this file.

Procedure

  1. Open the cd_storage_conf.xml configuration file.
  2. In the <Storages> element, add the following <StorageBindings>:
    <StorageBindings>
    	<Bundle src="AudienceManagerDAOBundle.xml"/>
    </StorageBindings>
  3. In the <ItemTypes> element, add the following <Item>s:
    <ItemTypes defaultStorageId="defaultFile">
    	<Item typeMapping="AudienceManagerProfile" storageId="profiledb"/>
    	<Item typeMapping="AudienceManagerTracking" storageId="trackingdb"/>
    </ItemTypes>
    Where storageId indicates the Subscription or Tracking database where data is stored.
  4. In the <Storages> element, configure the Outbound E-mail Tracking database:
    • For Microsoft SQL database:
      <Storage Id="trackingdbmssql" 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="trackingdbOracle" 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.

  5. In the <Storages> element, configure the Audience Manager Subscription database:
    • For Microsoft SQL database:
      <Storage Id="profiledbmssql" 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_submgmt"/>
      		<Property Name="user" Value="TMSSMUSER"/>
      		<Property Name="password" Value="PASSWORD"/>
      	</DataSource>
      </Storage>
    • For Oracle database:
      <Storage Id="profiledbOracle" 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="TMSSMUSER" />
      		<Property Name="password" Value="PASSWORD" />
      	</DataSource>
      </Storage>

What to do next

For information on cd_storage_conf.xml and how to encrypt passwords, refer to Configuring content storage and Encrypting sensitive strings.