Overview of Data Synchronization

From Connect
Jump to: navigation, search

Go Up to Administrator Guide

Embarcadero Connect provides features on top of data from ER/Studio Repository, which can store data from ER/Studio Business Architect and ER/Studio Data Architect.

However, the data you see in Embarcadero Connect does not come directly from ER/Studio Repository. Instead, Embarcadero Connect has a repository of its own, the Reporting Repository, which holds a copy of the data from ER/Studio Repository. As data changes in ER/Studio Repository (ER objects, users and roles are added, deleted or updated), you must update Embarcadero Connect to keep both repositories in sync.

For example, when a user is assigned to a role in ER/Studio Business Architect or ER/Studio Data Architect, the new permissions of the user are not available to that user when he logs in to Embarcadero Connect, until you run a synchronization process. Similarly, a new user added to Embarcadero Connect does not have access to any ER object of the Reporting Repository until you synchronize Embarcadero Connect with ER/Studio Repository.

You can synchronize the data shared between the ER/Studio Repository database and the Embarcadero Connect Reporting Repository database on demand or in a schedule, and you can perform the synchronization continuously or periodically.

You should start by configuring which content you want to synchronize, and then proceed to synchronize it. See in ER/Studio Repository Data that Embarcadero Connect Supports which data you can synchronize with Embarcadero Connect.

Notepad blue icon 2.pngNote: Files saved in later versions of ER Studio Data Architect may not work with Embarcadero Connect if they use new features. For example, if you use SQL Server 2014 for your Physical Model in ER Studio DA 9.7, you will need to update to the corresponding version of Embarcadero Connect for those files to synchronize.


See Also