Configuring the Storage Layer
You configure the Storage Layer configuration file of the Content Deployer in order to grant your Archive Manager Modules access to the Archiver database.
Procedure
- Open the Storage Layer configuration file,
cd_storage_conf.xml, as used by Content Deployer, for editing. This file is in one of the following locations:- If your Content Deployer runs as a Java Web application, navigate to WEB-INF/classes/.
- If your Content Deployer runs as a .NET Web application, navigate to lib\config\.
- If your Content Deployer runs as a Windows service or a Java process, go to the location where you stored cd_storage_conf.xml.
- In the
<Storages>element, add the following<StorageBindings>:<StorageBindings> <Bundle src="resources/am_dao_bundle.xml"/> </StorageBindings>Note:am_dao_bundle.xmlis bundled in thecd_archivemanager.jarfile. - In the
<Storages>element, configure the Archiver database, for example:To enable storage of content in a Microsoft SQL Server database, add the following
<Storage>element:<Storage Type="persistence" Class="com.tridion.storage.persistence.JPADAOFactory" Id="archivemanager" dialect="MSSQL"> <Pool Type="jdbc" Size="100" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" /> <DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource"> <Property Name="serverName" Value="localhost"/> <Property Name="portNumber" Value="1433"/> <Property Name="databaseName" Value="TridionArchiveManager"/> <Property Name="user" Value="TridionArchiver"/> <Property Name="password" Value="tridion"/> </DataSource> </Storage>To enable storage of content in an Oracle database, add the following
<Storage>element:<Storage Type="persistence" Id="archivemanager" dialect="Oracle" 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="localhost" /> <Property Name="portNumber" Value="1521" /> <Property Name="databaseName" Value="TridionArchiveManager" /> <Property Name="user" Value="TridionArchiver" /> <Property Name="password" Value="tridion" /> </DataSource> </Storage>
- Encrypt the database password using the tool provided—for more information, see Encrypting sensitive strings.
- In the
<ItemTypes>element, add the following<Item>elements:<Item typeMapping="Archive" storageId="archivemanager"/> <Item typeMapping="ArchiveRelations" storageId="archivemanager"/> <Item typeMapping="ArchivedComponent" storageId="archivemanager"/> <Item typeMapping="Content" storageId="archivemanager"/> <Item typeMapping="LinkOrigin" storageId="archivemanager"/> <Item typeMapping="Path" storageId="archivemanager"/> <Item typeMapping="TmpContentId" storageId="archivemanager" /> <Item typeMapping="ArchiveAction" storageId="archivemanager" /> <Item typeMapping="ArchiveStatus" storageId="archivemanager" /> - Save and close
cd_storage_conf.xml. - If you use integrated authentication with a SQL Server database, configure the location of the file sqljdbc_auth.dll as a JVM parameter if you have not already done so. For example, define the Java library path as follows:
-Djava.library.path=c:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\auth\x86.