Configuring the Tracking database for the Audience Manager service
Configure your Tracking database in the Storage Layer configuration file, cd_storage_conf.xml, in the configuration location of the Audience Manager Service.
Procedure
- Open the
cd_storage_conf.xmlconfiguration file. - In the
<ItemTypes>element, add the following<Item>element:
where TRACKDBID is the ID of the Tracking database where data is stored.<Item typeMapping="AudienceManagerTracking" storageId="TRACKDBID"/> - In the
<Storages>element, add the following<StorageBindings>:<StorageBindings> <Bundle src="AudienceManagerTrackingDAOBundle.xml" /> </StorageBindings> - In the
<Storages>element, configure the Outbound E-mail Tracking database:- For Microsoft SQL database:
<Storage Id="trackingdb" 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="trackingdb" 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: