Creating the Data Synchronization Server Database and Synchronizing Data

In This Section:

Creating the Data Synchronization Server Database for the Bridge

Managing Updates to Financial Management Data and Metadata

Creating the Data Synchronization Server Database for the Bridge

The first time you open a bridge, you must create the Data Synchronization Server database for the bridge.

  To create the Data Synchronization Server database for the bridge:

  1. Open a bridge.

    See Opening an Analytics Link Bridge.

  2. On the Data Synch tab, under Data Status, select a region from the Region list.

  3. Click Create.

Analytics Link extracts the Financial Management application data and metadata to the Data Synchronization Server database and sets the status of Analytics Link Data to On.

To recreate Analytics Link Data, first click Delete, to remove the data from the Data Synchronization Server database for the bridge, and then click Create.

To make the Analytics Link Data inaccessible, click Off. Then click Resume when you want the data to be accessible again.

Note:

When you create the Data Synchronization Server database using a user-defined region, you cannot edit or delete this region while it is in use. To change the definition of a user-defined region that is in use, you must delete the Data Synchronization Server database, then edit the region definition (see Editing User-Defined Data Regions), and then recreate the Data Synchronization Server database.

Managing Updates to Financial Management Data and Metadata

When Financial Management application data or metadata changes, you must synchronize those updates with the Data Synchronization Server database. You can view information about the last time data and metadata was synchronized on the Data Synch tab, under Updates Status.

See:

Synchronizing Data Synchronization Server with Financial Management Application Data Updates

Data Update Agent synchronizes Financial Management application data updates with Data Synchronization Server. When active, Data Update Agent synchronizes data updates based on a specified interval. Only updated Financial Management data, not metadata, is synchronized.

  To set Data Update Agent to synchronize data automatically:

  1. Open a bridge.

    See Opening an Analytics Link Bridge.

  2. To set the data updates interval:

    1. Under Agent Status, click Modify.

    2. In the Modify Update Interval dialog box, select an option:

      • HFM Clusters Synch Maximum Delay

      • Custom Update Interval—Enter the time interval (in seconds) at which data synchronization between Financial Management and Data Synchronization Server should occur.

    3. Click OK.

  3. To activate Data Update Agent, click Start.

Note:

When Data Update Agent status is Active, you cannot manage the Data Synchronization Server database, as the UI controls under Data Status are not available.

Synchronizing Data Synchronization Server with Financial Management Application Metadata and Data Updates

When Financial Management application metadata changes, you must manually synchronize Financial Management application metadata updates with Data Synchronization Server. You can also manually synchronize Financial Management application data updates.

  To synchronize Financial Management application metadata and data updates with Data Synchronization Server:

  1. Open a bridge.

    See Opening an Analytics Link Bridge.

  2. Under Agent Status, if the status of Data Update Agent status is Active, click Stop.

    When Data Update Agent status is Active, you cannot manage the Data Synchronization Server database, as the UI controls under Data Status are not available.

  3. Under Data Status, select an update option:

    • Data Update—Synchronizes only Financial Management data updates that were made since the previous synchronization with Data Synchronization Server. (See Last Data Update under Updates Status.)

    • Metadata Update—Recreates the entire Data Synchronization Server database with Financial Management data and metadata.

      Note:

      Use this option only when there have been metadata updates to the Financial Management application.

Note:

If the bridge target database is Essbase, you must recreate the Essbase database after performing a metadata update or recreating the Data Synchronization Server database to ensure that the Essbase database is created with the updated Financial Management metadata.