Installing tracking retrieval (Java)

The Synchronization Server retrieves tracking information from the Tracking database on the presentation side. This task describes how to set up a Synchronization Server on a Java-based Web Application Server.

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. Create a new Web application in your Java/JSP Web and Application Server.
  2. Create the Web application directory structure:
    1. Create a WEB-INF/ directory.
    2. In the WEB-INF/ directory create subdirectories:
      • classes/
      • lib/
      • syncComponent/ (example)
    The Web application should have the following directory structure:
    WEB-INF/
          +--classes/
          +--lib/
          +--syncComponent/
  3. Install the Content Delivery API Server Role:
    1. Installing a server role as a JSP Web application—universal procedure
  4. Access the SDL Tridion installation media.
  5. 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.
  6. Install JSP for Tracking retrieval: navigate to Outbound E-Mail\Presentation System\Java\Tracking\Web and copy trackingsync.jsp to a directory in your Web site, for example syncComponent\.
  7. 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
  8. 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).
  9. Test the installation by opening a browser and running the trackingsync page.
  10. 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.