The Remote Protocol Connector utility is designed to improve the system performance by optimizing the work with the database while generating general and Time and Attandance reports by event protocol, both in the Time and Attendance module and in the Web Report System.

The utility enables the following actions:

  1. Expose the events protocol in a separate database.
  2. Create a protocol database.
  3. Transfer data from the old protocol table to a new one in a separate database.
  4. Delete the old protocol table.
  5. Create synonyms for a new protocol database, which will enable the work of Time and Attendance module and its reports subsystem.

The utility is located in the /Intellect/ Tools folder.

Before starting work with the utility, Intellect must be shut down.

Working with the utlity is as follows:

  1. In the Intellect connection string field, specify the path to the Intellect database (1).

  2. In the Protocol connection string, specify the path to the events protocol table. (2)
    The Config button for both fields enables automatic generation of connection strings to the database and to the protocol table (3). When you click on the button, the connection settings window opens, where you can select the server name and the name of the database or table.

  3. Check the Create Protocol database box if you want to create a separate database for the events protocol. By default, the name of the database is Intellect_Protocol, however, it can be changed (4).
  4. Check the Create revers connect box if you want to keep the old event protocol table, but associate it with the new database that will be created by the utility (5).
  5. Check the Move events to a new database box if you want to migrate all entries from the old event protocol table to the new database (6).
  6. In the Events moving timeout (ms), specify the timeout for transferring entries in milliseconds (if the event transfer setting is enabled). (7)

  7. Check the Delete old protocol table box if you do not want to save the old event table (8).

  8. Check the Add WT synonyms in protocol box if you want to transfer the links of the old event protocol table to the other Time and Attendance tables to the new database (9).

    It is recommended to migrate the events to a new database beforehands.

  9. Click Start to run the utility (10).

The migratiom progress and possible errors will be displayed in the field below the settings panel.