Configuring the Content Data Store for Tracking
The cd_storage_conf.xml file is the Content Delivery Storage Layer configuration file. You need to configure the Tracking database for Online Marketing Explorer in this file, and you can also configure metadata caching to improve tracking performance.
Procedure
- Open the
cd_storage_conf.xmlconfiguration file in a text editor. - In the
<Storages>element, add the following<StorageBindings>:<StorageBindings> <Bundle src="TrackingRequestDAOBundle.xml"/> </StorageBindings> - In the
<ItemTypes>element, add the following<Item>s:
Where<ItemTypes defaultStorageId="defaultFile"> <Item typeMapping="TrackedRequest" cached="true" storageId="defaultdb"/> <Item typeMapping="TrackingBatch" cached="true" storageId="defaultdb"/> <Item typeMapping="SynchronizationRecord" storageId="defaultdb"/> <Item typeMapping="TrackingItem" storageId="defaultdb"/> </ItemTypes>storageIdindicates the Tracking database where data is stored. - In the
<Storages>element, configure the Tracking database for Online Marketing Explorer, for example:To enable storage of content in a Microsoft SQL Server database, ensure the presence of the following
<Storage>element, uncommented:<Storage Type="persistence" Id="MSSQL_01" dialect="MSSQL" Class="com.tridion.storage.persistence.JPADAOFactory"> <Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" /> <DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource"> <Property Name="serverName" Value="SERVER_NAME" /> <Property Name="portNumber" Value="1433" /> <Property Name="databaseName" Value="DATABASE_NAME" /> <Property Name="user" Value="USER_NAME" /> <Property Name="password" Value="PASSWORD" /> </DataSource> </Storage>To enable storage of content in an Oracle database, ensure the presence of the following
<Storage>element, uncommented:<Storage Type="persistence" Id="Oracle_01" dialect="ORACLESQL" Class="com.tridion.storage.persistence.JPADAOFactory"> <Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" /> <DataSource class="oracle.jdbc.pool.OracleDataSource"> <Property Name="driverType" Value="thin" /> <Property Name="networkProtocol" Value="tcp" /> <Property Name="serverName" Value="SERVER_NAME" /> <Property Name="portNumber" Value="1521" /> <Property Name="databaseName" Value="DATABASE_NAME" /> <Property Name="user" Value="USER_NAME" /> <Property Name="password" Value="PASSWORD" /> </DataSource> </Storage>
- To improve tracking performance significantly, it is recommended to cache metadata for different Content Delivery items by adding
<Item>elements in the<ItemTypes>element. For example:<ItemTypes defaultStorageId="defaultdb" cached="true"> <Item typeMapping="ComponentMeta" cached="true" storageId="defaultdb"/> <Item typeMapping="ComponentPresentationMeta" cached="true" storageId="defaultdb"/> <Item typeMapping="PageMeta" cached="true" storageId="defaultdb"/> <Item typeMapping="ItemMeta" cached="true" storageId="defaultdb"/> <Item typeMapping="BinaryMeta" cached="true" storageId="defaultdb"/> </ItemTypes>Where
defaultdbis the value of theIdattribute of the<Storage>element configured for Online Marketing Explorer.
What to do next
For information on how to encrypt passwords, see the SDL Tridion documentation on the implementer's documentation portal.