Exact Integration makes it possible to synchronize data in real time between Exact Globe and Exact Synergy Enterprise. This means you can enter data in both products. For instance, after saving the data in Exact Globe, this solution will copy the data over to Exact Synergy Enterprise, so you can continue working on it in Exact Synergy Enterprise.
The process of the data integration is presented in the diagram below:
The process starts when you save the data. Saving the data means Exact Globe or Exact Synergy Enterprise will instruct Exact Integration to copy the data over to the other product. The trigger to Exact Integration is provided by our business logic. This means that all changes made via Exact Globe or Exact Synergy Enterprise will be synchronized. Note that changes made directly in the SQL database will not be synchronized by this solution.
This document is divided into the following sections for better viewing:
Once all the prerequisites have been met, you can begin the installation process.
There are two versions of ExactIntegrator.msi. One for 32-bit (x86 installer) installation and one for 64-bit (x64 installer) installation.
Under the Integration settings section, define the server name at Server. Exact Data Integration needs to register the location where it is located. This is needed to ensure all Exact Globe Next workstations can inform Exact Data Integration when they have changed the data.
At the SQL Server field, define the SQL server name. Exact Synergy Enterprise and Exact Integration can be installed on a different server. A separate database called Exact Synchronization Framework (ESF) will be created so that the data will be synchronized properly. The ESE installation folder field refers to the environment whereby both Exact Synergy Enterprise and Exact Integration are installed on the same server. In the Check restored db (mins) field, type the number of minutes you want the configurator to check for restored databases. The configurator will automatically synchronize the data based on the number of minutes defined. By default, "180" is defined.
Under the Exact Synergy Enterprise Connection section, in the SQL Server column, define in the Exact Synergy Enterprise SQL server name, and in the Database column, define the Exact Synergy Enterprise database name. In the Web address column, define your web address of your Exact Synergy environment.
Under the Exact Globe Connection section, define the information for Exact Globe. The additional column, Company, lets you fill in the synchronization company.
Note: The SQL server instance is case sensitive.
Under the User Credentials to access Exact Globe and Exact Synergy Enterprise section, type your domain name and user name at User ID. This user will be used to synchronize the data. In Exact Globe and Exact Synergy Enterprise, this user will be mentioned as the modifier when the data is synchronized. That is why the user needs to have the rights to synchronize the data. Type in a password at Password.
After the installation, the user will not be able to see Exact Integration. The synchronization process will run in the background. To get visibility on the synchronization process, the following data sources can be analyzed:
1. Messaging Queue
After the installation of Exact Integration, three queues are created. The fourth is created when you install Exact Globe. Those queues store all messages that are sent from and to Exact Globe and Exact Synergy Enterprise. In the queues, you get visibility if a trigger is given (queue message) and if it is executed by our Synchronization Framework (Journal message).
The queues can be found by right-clicking on My computer and selecting Manage. See the following screen:
2. Windows services
The installation also installs Windows services. Exact Integration installs five of them. Exact Globe also installs two services. Those services must run to get the data synchronized. See the following screen for an example:
3. Baco log tables
The entity layer logs all actions that have been read and written in the Baco log tables of Exact Globe or Exact Synergy Enterprise. Exact Integration uses those entities to read and write the data to Exact Globe and Exact Synergy Enterprise.
When the services are running and the queues have processed the trigger, you can check the database to see whether the data has been synchronized. See the following screen for an example: