Audience Manager requires you to create a Subscription database to store Contact subscription data. In an in-process setup, configure your Subscription database in the Storage Layer configuration file, cd_storage_conf.xml, in the configuration location of your web application.
Procedure
- Open the
cd_storage_conf.xml configuration file.
- In the
<Storages> element, add the following <StorageBindings>:
<StorageBindings>
<Bundle src="AudienceManagerProfileDAOBundle.xml"/>
</StorageBindings>
Note: The AudienceManagerDAOBundle.xml is embedded in the oe_utils.jar file.
- 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.
- 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>
- Restart your web application.