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
- Open the
cd_storage_conf.xmlconfiguration file. - In the
<Storages>element, add the following<StorageBindings>:<StorageBindings> <Bundle src="AudienceManagerDAOBundle.xml"/> </StorageBindings>Note: TheAudienceManagerDAOBundle.xmlis embedded in theoe_utils.jarfile. - In the
<ItemTypes>element, add the following<Item>s:
Where<ItemTypes defaultStorageId="defaultFile"> <Item typeMapping="AudienceManagerProfile" storageId="profiledb"/> <Item typeMapping="AudienceManagerTracking" storageId="trackingdb"/> </ItemTypes>storageIdindicates the Subscription or Tracking database where data is stored. - 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
serviceNameinstead ofdatabaseName.
- For Microsoft SQL database:
- 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>
- For Microsoft SQL database:
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.