Example: Using a list of configurations

If you use the preferred “list of configurations” method, where the system uses information from the database into which users are logged, ensure that the local site has Site User Map rows associated with each of the “From Sites” from which the local site will receive non-transactional data. This scenario is illustrated by this example:

You have three databases:

  • DB1 has one site, Shanghai.
  • DB2 has one site: Windsor.
  • DB3 has two sites, CMH and CIN.

Communication between the sites is set up like this:

  • CMH and CIN communicate through synchronous (transactional) replication with each other.
  • CMH and CIN communicate through asynchronous (non-transactional) replication with Shanghai and Windsor.
  • Shanghai and Windsor communicate through asynchronous (non-transactional) replication with CMH and CIN and with each other.

Each database contains five site records:

  • Shanghai
  • Windsor
  • CMH
  • CIN
  • INFORBUS (used for communications with ION)

The Sites or Sites/Entities form includes these Site User Map rows for each database:

DB1 site record Contains these Site User Map rows
Shanghai From Site: Windsor

From Site: CMH

From Site: CIN

Windsor
CMH
CIN
INFORBUS From Site: Shanghai

From Site: Windsor

From Site: CMH

From Site: CIN

DB2 site record Contains these Site User Map rows
Shanghai
Windsor From Site: Shanghai

From Site: CMH

From Site: CIN

CMH
CIN
INFORBUS From Site: Shanghai

From Site: Windsor

From Site: CMH

From Site: CIN

DB3 site record Contains these Site User Map rows
Shanghai
Windsor
CMH From Site: Shanghai

From Site: Windsor

CIN From Site: Shanghai

From Site: Windsor

INFORBUS From Site: Shanghai

From Site: Windsor

From Site: CMH

From Site: CIN