Working with MobiLink

MobiLink is a relational database synchronization engine which helps you to synchronize data contained in a consolidated database with one or more remote databases. PowerDesigner supports modeling for MobiLink version 9.0 and higher, including round-trip engineering.

Synchronization begins when a MobiLink remote site opens a connection to a MobiLink server. The MobiLink client at the remote site uploads changes made to the remote database since the previous synchronization. On receiving this data, the MobiLink server updates the consolidated database, and then downloads changes from the consolidated database to the remote database.

The following example shows an information liquidity diagram representing a synchronization of data from a consolidated database through the MobiLink synchronization server to three remote databases, each of which are modeled in Physical Data Models (PDMs):

• Modeling for MobiLink
  PowerDesigner supports the modeling of all the components required to deploy a MobiLink solution in your environment.
• Creating a Basic MobiLink Environment with the Replication Wizard
  The Replication Wizard provides a quick way to configure a MobiLink server for synchronizing data between remote and consolidated databases. You can synchronize the entire database or choose specific tables to synchronize. You can run the wizard as many times as necessary to create additional synchronizations on a MobiLink server.
• MobiLink Object Properties
  When modeling for a MobiLink environment, you use standard ILM objects with additional properties.
• MobiLink Article Properties
  MobiLink article property sheets contain all the standard article tabs, along with the Upload and Download tabs, the properties of which are listed below:
• MobiLink Connection Scripts/Table Scripts Properties
  MobiLink connection script and table script property sheets contain all the standard event script tabs and an additional property on the General tab, along with the MobiLink tab, the properties of which are listed below:
• MobiLink Subscriptions
  PowerDesigner models MobiLink subscriptions as standard subscriptions with additional properties.
• MobiLink Connection Scripts/Table Scripts
  PowerDesigner models MobiLink connection scripts and table scripts as standard event scripts with additional properties.
• Generating for MobiLink
  You can generate MobiLink scripts (*.sql) for the replication process, and/or for the consolidated and remote databases.
• Reverse Engineering for MobiLink
  You can reverse engineer an existing MobiLink synchronization definition into an ILM using a live connection for both the remote and the consolidated databases. The process of reverse engineering MobiLink synchronization definitions equals to retrieving MobiLink objects from the embedded Replication Server System Database (RDSS) via a live connection to create or update the corresponding ILM objects.