Insights on Exact Online Synced Tables

In general all data in a Silver Essence Portal comes from the connected databases or webservices in real-time. But with a webservice like the Exact Online API, there are cases where you might want one or more topics synchronized into your local database. Usually that is for reporting purposes. Or to create joins on multiple topics, which is impossible through the API itself. 

In the upcoming Release we have added a new feature to get more insights on the status of the synchronization.

Insights on Exact Online Synced Tables

In the EOL Import section of the ReportViewer, you will see an additional button to log the Synched Tables:

When you press that button, the following will happen:

  • Stored Procedure will be added
    A Stored Procedure spLogSilverSyncedDate will be added to the selected database if not already present.
  • A Table will be added
    A Table SilverSyncedTables will be added to the selected database if not already present.
  • The Stored Procedure will be executed
    The Stored Procedure will be executed on the selected database.

The spLogSilverSyncedDate Stored Procedure will identify all the Synced Tables, gets the most recent Synchronisation Date and the number of Rows in the Table. The result will be added in the SilverSyncedTables Table. That way you can see what the details on the synchronization on specific points in time.

Schedule the Stored Procedure

We deliberately handled this through a Stored Procedure, so you can use the same Procedure in a SQL Agent Job to run it on desired intervals. Of course, if you have access to the Microsoft SQL Server that is. Otherwise you can request the Procedure to be scheduled with your Essence Hosting Provider.

Use the results

Since the results are stored in your local database, you can use them for reporting or notifications. Or you can use the Quick Editor and extract the Table to a BusinessController and check the data in the Portal itself.