Welcome to the Exact Product Blog

On this blog we will cover stories from all around the Exact ecosystem.

Exact Integration – Resending data

Written by Michiel Dorjee on . Posted in Exact Synergy

Hi all,

When you are using the Exact Integration solution you sometimes want to to re-send your data from Exact Synergy Enterprise to Exact Globe vice versa. As previously stated you can do this in the background monitor by hitting the re-send button for selected messages.

We also supply you with a tool that can re-send your data based on the entities and the ‘date last modified’.

In your installation folder of Exact Integration (p.e. c:\program files\exact software\exact integration\synchronization framework\bin) you can start up an executable called SendToQueue.exe. This tool allows you to select the entity that you want to re-send and from which date.

This tool makes use of the Integration solution that uses the Web Services on Exact Synergy Enterprise and Entity Windows Services on Exact Globe to exchange data between the two products.

In the upper part of the screen you enter your connection settings, after pressing the button connect, it will fill your list with entities that are currently supported. These settings will be automatically pre-filled based upon your installation of Exact Integration. Please note that you have to point to the services directory when you use the web address.

In the options section you can either select synchronize from ESE (Exact Synergy Enterprise) to Exact Globe or from EG (Exact Globe) to Exact Synergy Enterprise.

With the date filters you can select your range based on the modified data.

In the entities section you can select the entities you want to re-synchronize. You can set the priority with the buttons on the right side of the selected entitiy. When you press the button ‘Retrieve to queue’ the synchronization will be started. Ultimately on the right you can see the progress of your entities selected.

When you decide to use this tool please bare in mind that it’s best to synchronize entities on an individual basis and that you schedule this outside of business hours so that there is no interference with your normal daily activities. And of course we recommend that you make a backup of your database before you start this process so that you can always go back to the situation you had and you don’t loose any valuable information.

When the process in completed you can view the results in your background monitor.

And for the technical people amongst us, you can also view this on a database level in SQL via the following query.
SELECT ID, StartDate, Source, Destination, Success, Message,
EntityName, Action, PrimaryKey,LogicalKey,TransformationProvider
FROM [esf].dbo.SyncResult
WHERE Message <> ‘echo’
ORDER BY StartDate DESC

Should you have any questions about this solution, do not hesitate to contact me at ruud.aalders@exact.com or add comments to this post.

Tags: , ,

Leave a comment