Anvaigo 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 Anvaigo Mobile App. For this purpose, data changes in Dynamics are determined on the fly and made available to the Anvaigo Mobile App client via the Anvaigo App Service.

The Delta Service is used for all Anvaigo A and B installations. More information about the possible Anvaigo installation variants can be found here.

Please note for previous Anvaigo installations (Anvaigo 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 Anvaigo Delta Service for this.

In the Anvaigo Mobile App on the mobile device, only the data defined by the Anvaigo 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 Anvaigo Mobile App.

For our Anvaigo Sales App as well as for the Anvaigo 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 Anvaigo Delta Service

You can use the search in Microsoft Dynamics to find the Anvaigo Delta Service facility.

The setup of the Anvaigo 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 Anvaigo 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 Anvaigo 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 Anvaigo 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.

---

Anvaigo 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 Anvaigo Delta Service Change Log.

The Anvaigo Delta Service Change Log records all changes to records stored in the Anvaigo 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 “Anvaigo Delta Service Transfer”.

---

Anvaigo Delta Service Transfer

By running a regular job in the task queue and starting a synchronization in the Anvaigo Mobile App, all data changes registered in the Anvaigo Delta Change Log table are packed into packages and transferred to the Anvaigo Delta Service. Subsequently, the packages are transferred to the PostgreSQL database and transmitted to the Anvaigo Mobile App client by the Anvaigo App Service.

The Anvaigo 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.