Assume that TBC has several databases, such as Inventory, Payroll, Marketing, and Sales. Users viewing the Sample.Basic database want to share data with and navigate to those other databases. You, the DBA, want to synchronize related data. It is impractical to combine all of the databases into one database, for the following reasons:
By connecting the databases instead, you can:
To connect multiple databases:
Determine which data to connect. First, connect the Inventory database.
Replicate the Opening_Inventory and Ending_Inventory members from the Measures dimension of the Inventory database into the Measures dimension of the Sample.Basic database.
Do not replicate the Number_On_Hand, Number_Shipped, and Number_Returned members in the Measures dimension of the Inventory database to the Sample.Basic database.
Add a link to the Inventory database so that users can view these more-detailed measures, if necessary.
Create a partition containing data from the Payroll, Marketing, and Sales databases in the Sample.Basic database.
Choose the data source and data target.
In the case of the Opening_Inventory and Ending_Inventory members, the Inventory database is the data source and the Sample.Basic database is the data target.
Decide which type of partition to use.
Use a replicated partition for the Opening_Inventory and Ending_Inventory members because the network connection is slow.
Connect the Payroll, Marketing, and Sales databases. Perform steps step 1 through step 3 for each database.
Create the partitioned databases by performing the following tasks:
Now that the Sample.Basic database is partitioned, users and DBAs see the following benefits: