Understanding Data Synchronization from Financial Management to Analytics Link

In This Section:

About Analytics Link Software Components

About Analytics Link Software Components

Analytics Link consists of these components:

Analytics Link Server

Analytics Link Server is a Web server that integrates Financial Management applications with Essbase databases and manages all operations of Analytics Link.

Analytics Link Repository

The Analytics Link repository is a relational database user/schema in which Analytics Link Server stores its internal data.

The location of the Analytics Link repository is specified during the Analytics Link configuration process. Whether using an existing relational database or creating a new database for the Analytics Link repository, you should create an Analytics Link user with permission to create and maintain tables within the schema.

Analytics Link Data Synchronization Server

Data Synchronization Server creates a database based on the data and metadata extracted from the Financial Management application. This database is a replica of the Financial Management application.

As an aggregation engine, Data Synchronization Server performs data aggregation on demand. Data Synchronization Server performs the same aggregations as the Financial Management application (except as noted below), so it returns matching results.

Note:

Data Synchronization Server does not perform consolidations of the Entity dimension, which is the consolidation dimension of the Financial Management application. Consolidations of the Entity dimension must be performed in Financial Management.

Analytics Link Administration Services Console Plug-in

Analytics Link Administration Services Console Plug-in is the Analytics Link Server client, which provides the user interface for defining and managing Analytics Link Servers and bridges.

See Analytics Link Servers Node and Analytics Link Bridges.

Analytics Link Financial Management Connector

The Analytics Link Financial Management Connector enables Analytics Link Server to extract Financial Management application metadata.

Data Store

The Data Store is a relational database user/schema. The Data Store may contain:

Analytics Link Servers Node

When the Analytics Link Administration Services Console plug-in component is enabled in Administration Services Console, the Analytics Link Servers node is displayed in the Enterprise View. When an Analytics Link Server is added to the Analytics Link Servers node, the server node is populated with these subnodes: HFM Servers, Essbase Servers, Data Synchronization Servers, Data Stores, and Bridges.

Figure 1, Analytics Link Servers node with Analytics Link Server named localEAL shows the tree hierarchy of the Analytics Link Servers node after the Analytics Link Server named localEAL is added.

Figure 1. Analytics Link Servers node with Analytics Link Server named localEAL

This image of the Enterprise View shows the tree hierarchy of the Analytics Link Server named localEAL.

Analytics Link Bridges

A bridge enables you to build a whole, partial, or transformed replica of a Financial Management application in an Essbase database, or extract Financial Management application data to an RDBMS database.

After a bridge is created, the bridge target cannot be changed. See Determining the Type of Bridge Target Database.