5 Synchronizing Oracle WebCenter Analytics

This chapter provides an overview of Oracle WebCenter Analytics synchronization and provides strategies for scheduling synchronization.

• Overview of Oracle WebCenter Analytics Synchronization

• 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. Dimension data is transferred through a JDBC connection.

If you are using Streaming Portal Mode, use the command line to run Analytics sync jobs. To schedule jobs, create scheduled tasks (Windows) or cron jobs (UNIX/Linux). An Analytics sync job exists for each type of portal object. For the commands you use to run sync jobs, see Analytics Sync Jobs. 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's sync.log file. For the location of the Oracle WebCenter Analytics sync.log file, see Overview of Logs.

Analytics Sync Jobs

Oracle WebCenter Analytics is delivered with sync jobs that synchronize your portal's objects with the Oracle WebCenter Analytics database. You can either run all three of the sync jobs at the same time using one command, or run each sync job separately. Separate sync jobs exist for synchronizing desktop, page, and portlet objects with Oracle WebCenter Analytics.

Analytics Sync Jobs (Windows)

To synchronize desktop, page, and portlet objects at the same time, type the following command in the Windows Command Prompt:

• install_dir\ptanalytics\10.3.0.1\bin\AnalyticsRunJobs.bat

By default, install_dir is c:\bea\alui.

Following are the commands you use to run each sync job separately:

• install_dir\ptanalytics\10.3.0.1\bin\AnalyticsRunJobs.bat RUN_COMMUNITY_SYNC

• install_dir\ptanalytics\10.3.0.1\bin\AnalyticsRunJobs.bat RUN_COMMUNITY_PAGE_SYNC

• install_dir\ptanalytics\10.3.0.1\bin\AnalyticsRunJobs.bat RUN_PORTLET_SYNC

To schedule a sync job, create a scheduled task and use one of the above commands appropriate to the sync job you are scheduling.

Analytics Sync Jobs (UNIX/Linux)

To synchronize desktop, page, and portlet objects at the same time, type the following command in the command line:

• install_dir/ptanalytics/10.3.0.1/bin/AnalyticsRunJobs.sh

By default, install_dir is /opt/bea/alui.

Following are the commands you use to run each sync job separately:

• install_dir/ptanalytics/10.3.0.1/bin/AnalyticsRunJobs.sh RUN_COMMUNITY_SYNC

• install_dir/ptanalytics/10.3.0.1/bin/AnalyticsRunJobs.sh RUN_COMMUNITY_PAGE_SYNC

• install_dir/ptanalytics/10.3.0.1/bin/AnalyticsRunJobs.sh RUN_PORTLET_SYNC

To schedule a sync job, create a cron job and use one of the above commands appropriate to the sync job you are scheduling.

Strategizing Synchronization Scheduling

Because some dimension data in you 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 desktop objects rarely change, run the desktop 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 are added to your production portal once per week, schedule the portlet 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 new pages are added to your production portal throughout the day, schedule the pages sync job to run once per hour.