5 Synchronizing Oracle WebCenter Analytics

This chapter describes Oracle WebCenter Analytics synchronization, how to force synchronization, and to strategize its scheduling.

Overview of Oracle WebCenter Analytics Synchronization
Performing Force Synchronizations
Strategizing Synchronization Scheduling

Overview of Oracle WebCenter Analytics Synchronization

Oracle WebCenter Analytics synchronization is a process by which object dimension data is sent from the remote database to the dimension tables of the Oracle WebCenter Analytics database, where the data is stored. The Automation Service runs the synchronization process using the Analytics sync jobs that are delivered with Oracle WebCenter Analytics. Dimension data is transferred through a JDBC connection.

An Analytics sync job exists for each object. The Analytics Jobs subfolder exists within the Analytics subfolder of the Admin Objects directory. For a complete list of synchronized objects and their associated products and Automation Service jobs, see Synchronized Dimension Data and Associated Jobs.

The Automation Service automatically runs all Analytics sync jobs after you have installed or upgraded Oracle WebCenter Analytics (including having added Analytics jobs to the Automation Service). The first synchronization is a full synchronization, in which the sync jobs transfer dimension data about all of the products' reported objects and populate the Oracle WebCenter Analytics database's job records.

After this initial synchronization, the Automation Service automatically and regularly runs partial synchronizations, in which all Analytics sync jobs transfer only dimension data about objects that are new or have been changed since the previous synchronization. Note that if an object is removed from the application on which Oracle WebCenter Analytics is reporting, the record for that object's dimension data remains in the Oracle WebCenter Analytics database. For this reason, Oracle WebCenter Analytics continues to report the events that occurred on this object before it was removed from the application.

By default, the Automation Service performs a partial synchronization once per day. You can, however, edit each sync job's schedule to better suit your environment and its usage patterns. For synchronization scheduling guidelines, see Strategizing Synchronization Scheduling.

You can find details of sync jobs in the portal's job history log or in Oracle WebCenter Analytics' sync.log file. For the location of the Oracle WebCenter Analytics sync.log file, see Overview of Logs.

Synchronized Dimension Data and Associated Jobs

The following tables list the objects whose dimension data is synchronized and the Analytics job that triggers synchronization of that dimension data for each of the products that are synchronized with Oracle WebCenter Analytics. The Analytics Jobs subfolder exists within the Analytics subfolder of the Admin Objects directory.

Table 5-1 Oracle WebCenter Analytics Synchronization - List of Objects and Associated Sync Jobs for Oracle WebCenter Interaction (portal)

Object	Analytics Job
Communities	Community Sync Job
Community Pages	Community Page Sync Job
Portlets	Portlet Sync Job
Auth Sources	Auth Source Sync Job
Community to Portlet Relationships	Community Portlet Map Sync Job
Directory Folders	Directory Folder Sync Job
Document Data Sources	Document Data Source Sync Job
KD Documents	Document Sync Job
KD Document to Directory Folder Relationships	Document Folder Map Sync Job
User Properties	Property Sync Job
User Property Values	User Property Sync Job Note: User property values that are over 255 characters in length are truncated to 255 characters in the Oracle WebCenter Analytics database. The user property values are not altered in the portal database.
Users	User Sync Job

Table 5-2 Oracle WebCenter Analytics Synchronization - List of Objects and Associated Sync Jobs for Oracle WebCenter Collaboration

Object	Analytics Job
Collaboration Message Post Data	Message Post Sync Job
Collaboration Document Upload Data	Document Upload Sync Job

Table 5-3 Oracle WebCenter Analytics Synchronization - List of Objects and Associated Sync Jobs for Oracle-BEA AquaLogic Interaction Publisher

Object	Analytics Job
Content Items	Content Item Sync Job
Content Folders	Content Folder Sync Job

Note:

Besides Analytics sync jobs, the Admin Objects directory includes these Analytics jobs, which are not related to synchronization:

User Status Update Job: Uses the Active User Timeout setting to calculate user activity/inactivity. You configure the Active User Timeout setting in Analytics Administration's Runtime Settings page. For details, see Configuring Runtime Settings.
Host Resolution Job: Resolves the IP addresses that are sent with events that are delivered with Oracle WebCenter Analytics. This job does not resolve the IP addresses that are sent with custom events.

Performing Force Synchronizations

A force synchronization populates the Oracle WebCenter Analytics database with the dimension data of objects that are synchronized by Analytics jobs. These jobs are listed in Synchronized Dimension Data and Associated Jobs.

Performing a Force Synchronization of All Dimension Data

To perform a force synchronization operation for all dimension data:

Execute the following SQL command on the Oracle WebCenter Analytics database:
```
TRUNCATE TABLE ASSYS_JOBLOGS
```
The command deletes all records from the ASSYS_JOBLOG.
Schedule the Automation Service to run all Analytics jobs.

The Analytics jobs populate the Oracle WebCenter Analytics database with current dimension data.

Performing a Force Synchronization of a Single Object's Dimension Data

To perform a force synchronization of a single object's dimension data:

Delete the log records for the object's associated sync job.

The log records are located in the ASSYS_JOBLOGS table.
Schedule the Automation Service to run the object's associated sync job.

The Analytics job populates the Oracle WebCenter Analytics database with the object's dimension data.

Strategizing Synchronization Scheduling

Because some dimension data in your environment might change more frequently than other dimension data, we recommend that you adopt a job scheduling strategy that reflects your environment's unique circumstances.

Following are some examples of scheduling strategies that you can adopt:

If your portal contains objects that rarely change, run the appropriate Analytics sync job manually. For example, if your portal's authentication sources rarely change, run the Auth Source Sync Job manually.
If your portal contains objects that change only once per week, schedule the appropriate Analytics sync job to run once per week. For example, if new portlets and communities are added to your production portal once per week, schedule the Portlet Sync Job and Community Sync Job to run once per week.
If your portal contains data that changes on a constant basis, schedule the appropriate Analytics sync job to run frequently. For example, if your registration Web site creates portal user accounts throughout the day, schedule the User Sync Job to run once per hour.

Note:

Oracle Webcenter Collaboration object data is sent real time to Oracle WebCenter Analytics when Oracle Webcenter Collaboration sends event data. For this reason, you do not need to schedule the Message Post and Document Upload sync jobs to run periodically. Only use these jobs if you have noticed that the BEA AL Analytics Collector service was not running while users posted messages or uploaded documents to Oracle Webcenter Collaboration.

For complete details on how to schedule Automation Service jobs, see Administrator Guide for Oracle WebCenter Interaction.