Anveo Delta Service
To enable the user to synchronize quickly, only the data changes and not always all data (so-called full load) are transferred between Dynamics and the Anveo Mobile App. For this purpose, data changes in Dynamics are determined on the fly and made available to the Anveo Mobile App client via the Anveo App Service.
The Delta Service is used for all Anveo A and B installations. More information about the possible Anveo installation variants can be found here.
Please note for previous Anveo installations (Anveo Type C3): In Microsoft Business Central Online and due to Microsoft’s Universal Code Initiative, we do not have the ability to have the Delta data determined by the existing Microsoft SQL Server, so we need the Anveo Delta Service for this.
In the Anveo Mobile App on the mobile device, only the data defined by the Anveo synchronization packages and the Delta Service Setup is available. The setup of the synchronization packages can be found here.
Data defined in synchronization packages must also be present in the Delta Service Setup, otherwise they will not be transferred to the device. Setting up the data in only one place will in any case result in them not being displayed in the Anveo Mobile App.
For our Anveo Sales App as well as for the Anveo Service App, the setup of the synchronization packages and the Delta Service Setup is already done. This setup is thus only necessary if you add new tables and/or fields to your app.
Setup of the Anveo Delta Service
You can use the search in Microsoft Dynamics to find the Anveo Delta Service facility.
The setup of the Anveo Delta Service takes place on table level without hierarchical structures as you know them from the synchronization packages. Select the table and table fields you need and define filters for the table, if necessary, so that not all records are considered for replication. For each table you need to specify a “company name”, unless they are company-independent tables. Only tables that are not currently activated can be changed.
You get a quick overview of the tables selected for replication. The following information is displayed for each table:
- “Dynamics Table number”
- “Dynamics Company Name”
- “Dynamics Table name”
- whether the table is enabled for replication
- Table type
- Number of fields set up
- Number of records according to the filter set up
- Timestamp of the last calculation of the number of records
Several functions are available in the Setup tab.
Edit setup
To customize the Delta Service Setup, this button must be enabled.
Attention: While the setup is being processed, no initialization or synchronization is possible on the Anveo Mobile App clients. Therefore, this task must be performed outside of normal working hours.
Activate Setup
To complete the setup, you must confirm it by Activate Setup.
Edit Filters
Apply filters to the table so that only selected records are replicated.
Edit Fields
Specify the fields of the selected table to be replicated.
Please note: We strongly recommend reducing the amount of data as best as possible to optimize speed. Therefore, check which tables and fields are really needed and also check if a record filter is possible.
Activate selected
Activates the selected tables for replication.
Please note: The data is transferred live to the Anveo Delta Service during activation. This can take a lot of time if you have a large amount of data, so we strongly recommend that you also perform this task outside of normal working hours.
Deactivate selected
Disables the selected tables for replication. The table will be deleted on the delta service and will not be transferred in the future.
Copy and set “company” for selected
Copies the selected tables for another company
Remove company for selected
Removes the company for selected tables
Calculate Record Count
Calculates the number of records that are in the filter for replication for the selected setup row.
Why is no hierarchy of tables possible in this setup as in the synchronization packages?
Replication from Dynamics to the delta service must be very performant so that all data is available quickly in the delta service even in the case of large data changes. For this reason, a complex check for replication of the data set via a hierarchy is too time-consuming. We have therefore only allowed a simple data filter.
What triggers a replication of a record?
We use the global OnInsert, OnModify and OnDelete events. In these events the change is registered with minimal code. Thus, for performance reasons, even fields that are not replicated trigger a change. The sending of the data changes is done in a later process in order not to slow down the system. For details see below.
Important! Re-login after configuration changes
Due to some Microsoft Dynamics limitations, it is necessary to log off and log on again all users after you have made some configuration changes (like adding new tables) to the Anveo Delta Service Setup. Therefore, we recommend making changes outside of working hours. Today, downtime is required for mobile users while changes are resynchronized. In future releases, you will be able to automatically resynchronize changes at night without downtime.
Anveo Delta Service Change Log
Please note: The information in the following sections is not normally required for a setup. They serve to make replication easier to understand and, in the event of support, as an aid to finding a solution.
The search will take you to the Anveo Delta Service Change Log.
The Anveo Delta Service Change Log records all changes to records stored in the Anveo Delta Service facility. The following information is available here:
- Change Type
Which change – insert, modify, delete, etc. – was performed - Table No
Which table is affected by the change - RecId
Unique identification of the data set - “company name”
In which client was the change made. - Status
Has the change already been processed
Searching in Microsoft Dynamics will take you to the overview of transferred data packages, just type “Anveo Delta Service Transfer”.
Anveo Delta Service Transfer
By running a regular job in the task queue and starting a synchronization in the Anveo Mobile App, all data changes registered in the Anveo Delta Change Log table are packed into packages and transferred to the Anveo Delta Service. Subsequently, the packages are transferred to the PostgreSQL database and transmitted to the Anveo Mobile App client by the Anveo App Service.
The Anveo Delta Service Transfer Page contains the following information:
- Package status
- Message
In the event of an error during transmission, further information is available. - Subtype of the package
There is a data package (DATAUPDATE) or a structure update if changes have been made to the setup (TABLEUPDATE). - Datetime Sent
Timestamp when the packet was transmitted - Datetime Processed
Timestamp when the packet was processed. - Log Entries
If something went wrong during the transfer, the cause can be viewed via the log entries.