Installing tracking retrieval (ASP.NET)

The Synchronization Server retrieves tracking information from the Tracking database on the presentation side. This task describes how to set up a Synchronization Server for tracking retrieval on Internet Information Service (IIS).

Before you begin

  • It is recommended to install Contact synchronization in a separate Web application that is not publicly available. Refer to Content Delivery prerequisites to learn which Web and Application Servers are supported.

Before installing tracking retrieval:

  • Install the Content Delivery API Server Role in your Web application (for database access only—do not configure the Ambient Data Framework).
  • Create a Tracking database.

About this task

Outbound E-mail provides a tracking synchronization Web page to retrieve tracking information from the Tracking database on the presentation side.

Procedure

  1. Open Internet Information Services (IIS) Manager.
  2. Create a New Web site:
    1. Select the Web sites and node and choose New > Web site from the context menu.
    2. Follow the steps in the Web Site Creation Wizard.
  3. Create the Web application directory structure:
    1. In the root folder, create a bin\ subfolder.
    2. In the bin\ folder, create subfolders:
      • config\
      • lib\
      • syncComponent\ (example)
    The Web application should have the following folder structure:
    
    root\
    	+--bin\
    		+--config\
    		+--lib\
    		+--syncComponent\ 
    
  4. Install the Content Delivery API Server Role:
    1. Installing a server role as a .NET Web application—universal procedure
  5. Access the SDL Tridion installation media.
  6. Install DLLs for Contact Synchronization, Tracking and Tracking retrieval: navigate to Outbound E-Mail\Presentation System\NET\Synchronization\bin and copy the DLLs to the \bin folder of your Web site.
  7. Install ASPXs for Tracking retrieval: navigate to Outbound E-Mail\Presentation System\NET\Synchronization\ and copy Trackingsync.aspx and Trackingsync.aspx.cs (and default Web.config, if necessary) to a directory in your Web site, for example syncComponent\.
  8. Install JARs for Tracking and Tracking retrieval: navigate to the Outbound E-Mail\Presentation System\Java\Tracking directory and copy the JAR files to your Web site \lib directory.
  9. Download the JDBC driver (JAR file) required for your specific database vendor and Java version, and copy it into the lib folder:
    Database vendorJDBC DriverFile to download when using Java 5File to download when using Java 6
    Microsoft SQL ServerMicrosoft SQL Server JDBC Driver 3.0sqljdbc.jarsqljdbc4.jar
    Oracle

    Oracle JDBC driver 11.2.0.2 or

    Oracle JDBC driver 11.2.0.1.0 (deprecated)

    ojdbc5.jarojdbc6.jar
  10. Configure the following files:
    1. cd_storage_conf.xml—see Configuring the Tracking and Subscription databases
    2. cd_audience_manager.conf.xml—see:
    3. logback.xml (configure logging).
  11. Test the installation by opening a browser and running the trackingsync page.
  12. Configure security so that only the Content Manager Server can access this Web application, for example as follows:
    • Create a specific user with limited access, and configure the Web application so that it only allows this user access.
    • Use HTTPS to allow only secure access.
    • Implement IP-based access control.

Results

You have installed the Tracking Retrieval Web page.