Documentation Center

Configuring the Subscription database for the Audience Manager service

Audience Manager requires you to create a Subscription database to store Contact subscription data. Configure your Subscription 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 <Storages> element, add the following <StorageBindings>:
    <StorageBindings>
    	<Bundle src="AudienceManagerProfileDAOBundle.xml"/>
    </StorageBindings>
  3. In the <ItemTypes> element, add the following <Item> element:
    <ItemTypes defaultStorageId="defaultFile">
    	<Item typeMapping="AudienceManagerProfile" storageId="SUBDBID"/>
    </ItemTypes>
    where SUBDBID indicates the Subscription database where data is stored. The default is profiledb.
  4. In the <Storages> element, configure the database:
    • For Microsoft SQL database:
      <Storage Id="profiledb" 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="profiledb" 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>