Documentation Center

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 tracking retrieval 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 Web Application Server.
  2. Create the following Web application directory structure:
    1. In the root folder, create a WEB-INF/ directory.
    2. In the WEB-INF/ directory, create subdirectories classes/ and lib/.
  3. In the WEB-INF/ directory, create a subdirectory called for example syncComponent/.
  4. Install and configure the Content Delivery API Server Role: see Installing the API Server Role for a Java Web application
  5. Access the SDL Tridion installation media.
  6. 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.
  7. 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\.
  8. Download the JDBC driver (JAR file) required for your specific database vendor and Java version, and copy it into the lib folder:
    Database vendorJDBC DriverRequired JAR
    Microsoft SQL ServerMicrosoft JDBC Driver 4.0 for SQL Serversqljdbc4.jar
    OracleOracle JDBC driver 11.2.0.3ojdbc6.jar for Java 6 or Java 7
    OracleOracle JDBC driver 12.1.0.1

    ojdbc6.jar for Java 6

    ojdbc7.jar for Java 7

  9. 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).
  10. Test the installation by opening a browser and running the trackingsync page.
  11. 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.