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 |