Documentation Center

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

  1. 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.
  2. In the <Storages> element, add the following <StorageBindings>:
    <StorageBindings>
        <Bundle src="resources/am_dao_bundle.xml"/>
    </StorageBindings>	
  3. 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>
  4. Encrypt the database password using the tool provided—for more information, see Encrypting sensitive strings.
  5. 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" />
  6. Save and close cd_storage_conf.xml.
  7. 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.