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>
  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.