Data Sources and Data Targets

Partitioned databases contain at least one data source (the primary site of the data) and at least one data target (the secondary site of the data). One database can serve as the data source for one partition and the data target for another partition. When defining a partition, you map cells in the data source to their counterparts in the data target.

Figure 49. Data Source and Data Target

This image illustrates the shared partitions in the data source and the data target.

An Essbase database can contain many partitions, as well as data that is not shared with any other Essbase database. You can define partitions between the following databases:

You can define only one partition of each type between the same two databases. For example, you can create only one replicated partition between the Sampeast.East and Samppart.Company databases. The East or Company databases can, however, contain many replicated partitions that connect to other databases.

One database can serve as the data source or data target for multiple partitions. To share data among many databases, create multiple partitions, each with the same data source and a different data target, as shown in Figure 50, Data Shared at Multiple Targets:

Figure 50. Data Shared at Multiple Targets

This image illustrates one data source with multiple data targets.

Table 36 lists the combinations of block storage and aggregate storage databases as data target and data source that are supported by each partition type:

Table 36. Combinations of Data Sources and Data Targets Supported by Partition Type

SourceTargetReplicatedTransparentLinked
Block storageBlock storageYesYesYes
Aggregate storageBlock storageNoYesYes
Aggregate storageAggregate storageNoYesYes
Block storageAggregate storageYesYesYes