Configuring the replication of POS databases

The POS Replicator system object is created under the Computer object in the Hardware tab of the System settings dialog box.  Only one POS Replicator object can be created on the Server.

To configure the POS Replicator system object do the following:

1. Go to the settings panel of the POS Replicator object.
   
2. Names of servers in POS PSIM™ on which the Servers of databases are run are specified in the Server column (1). The list is forming automatically and it can’t be edited manually. The server is placed to the list only if one or more POS terminal objects are created.
3. Automatically created string of connection to remote database server is specified in the Connection string column (2). Name of SQL-server is made from the Server name adding the \sqlexpress, on default the name of database is POS. If it is necessary to change the connection strings do the following:
   1. Click the key in the Browse column (6). The Data Link Properties window is opened in order to configure the database connection.
   2. In the Select or enter a server name field select from the list or enter manually the name of MS SQL Server where the connected database is stored (1).
      
   3. Set the switch into the Use a specific user name and password position (2).
   4. In the User name: field enter the user name (login) to connect to the MS SQL server, in the Password field enter the password to access the database (3).
   5. Set the Allow saving password checkbox (4).
   6. Select the name of connected POS PSIM database from the Select the database on the server list (5).
   7. Click OK (6).
4. Specify the replication parameters using one of the following way:
   1. For each server:
      1. User name and password specified the previous step of connection to the database will be automatically entered in the “User” and “Password” fields (3).
      2.  In the Timeout field enter the data replication period in seconds (4).
      3. Set the Active checkbox in case of replication is to be performed from the specified server to the maim server (5).
      4. Repeat 4.a.i – 4.a.iii steps for each server in the list.
   2.  For all servers, if it is necessary to use equal parameters for them:
      1. Select servers from the list for which replication parameters are to be changed.
      2.  Enter the user name and password which are used to connect to all databases in the list (7).
      3. In the Timeout field enter the data replication period in seconds (8).
      4. Set the Active checkbox if it is necessary to use all connections (9).
      5. Click Apply button (10).

      Note.

      It is possible to specify following parameters for several Servers such way: user name and password of connection to the POS database, timeout and state of replication.
5. In the Deep storage: field enter number of days during which data will be saved in the database (11).
6. Click Apply button.

Replication starts automatically when all these actions are completed. Databases with replication time rating are added to the replication queue. Databases with the lowest replication period have the highest priority. Several replication processes can be performed simultaneously depending on the number of cores in the main Server processor.

The replication process can be detected through the terminal window of Pos Aggregator module which is activated by double clicks on module sign in the tray.  

Configuration of the POS Replicator system object is completed.