Acumatica To AnterraBI Synchronization Process and Timing

Acumatica To AnterraBI Synchronization Process and Timing

Introduction

This article provides an overview of how your data is synchronized from Acumatica to the Anterra Platform.
sync infographic
Most data is delivered from the source ERP within minutes after changes are made. That information is transformed and loaded into the Anterra Platform's data warehouse within just a few seconds of being received. This means that information at the transaction level (lowest drill level) within Anterra's data warehouse is up-to-date very quickly.

For performance reasons, there are two limitations we have placed on near real-time systems:
  1. Data shown at all levels except the transaction level* in the Anterra Platform comes from our analytical cubes, which are updated every two hours (on even-numbered hours) when we detect that new data has arrived.
  2. The transaction level data may still show cached information, if you know that an adjustment has been made and you are at the transaction level in Anterra, you can manually force refresh the grid by clicking the force refresh button shown at the top right of every grid under the save icon.

*The analytical cubes power all summarized information throughout the Anterra Platform, such as project level and cost code level grids in construction or information in accounting & financial statements.

How does Acumatica know what and when to transfer my data?

For Acumatica clients, we install a customization project within your Acumatica instance which actively monitors updates to nearly 80 areas within Acumatica and relays those changes. Shortly after one of these changes is made, the Acumatica software compares the data that has already been sent against the newly changed data, and sends the updates to Anterra within a few minutes.

Anterra immediately places this updated information in our data warehouse, which is used in the Anterra Platform when you drill down to the lowest level, such as transactions; it also flags that the analytical cube processing needs to take place (covered in further detail below).

acumatica connection

Anterra Platform Analytical Data Processing

Around the top of every evenly numbered hour (Noon, 2p, 4p, etc...), Anterra checks whether new data has arrived and queues the processing of our analytical cubes.  Once our system has an available slot for your data processing, the analytical cube processing is automatically initiated. The cubes pre-calculate aggregations of data across various dimensions to allow Anterra to rapidly display information. Once that processing has completed without errors, we also flush the temporary cache storage that holds any data which has been recently accessed on your site, which makes the data available throughout the entire Anterra Platform. 

Available Data Processing E-Mail Notifications

The following are optional notifications which you can turn on through your Anterra Platform by clicking on your name at the top right corner and selecting E-Mail Management and selecting one or more of the highlighted checkboxes and finally clicking Save Changes.
e-mail notifications

anterraDataCenter - Anterra Platform

Notification Type
Description
Job Queued
This notification is sent when new data has been received by Anterra and we have queued your data processing. Expected to occur within 15 minutes of receiving new data from a client unless data was received in the last two hours or within the client’s configured cool-down period, whichever is longer.
Job Started
This notification is sent when we have started the processing of your new data. This also includes any custom processing that has been added to your system. By default our processing involves all of your data, however with coordination we can configure mid-day syncs to only process certain aspects of your data (GL, AP, AR, JC) to reduce the processing time and make updated information accessible on the platform more quickly.
Job Succeeded
This notification is sent when we have successfully completed the processing of your new data and it is now available in the Anterra Platform. The next time you various features of the Anterra Platform they may take a little longer since the new data has to be fetched, filtered based on your particular security, grouped, sorted, and have your filters applied to it from scratch.
Job Failed
This notification is sent when Anterra encounters a problem with processing the data we received. Anterra is automatically notified about these events as a high priority (P0) and resources are immediately assigned to identify and attempt to correct the issue. While these issues are rare, we often find that unexpected changes by a 3rd party (such as a consultant) working on your data directly is the root cause.


    • Related Articles

    • Acumatica AnterraBI Customization Project Features

      Installed Version The currently installed version of the AnterraBI customization project can be found by visiting the Customization Projects (SM204505) in Acumatica. The description has the version in it formatted as yyyy.MM.## which indicates the ...
    • Data Synchronization - Status display in the AnterraBI™ Menu Bar

      Version 25 Release Anterra has added a data synchronization status icon on the AnterraBI menu bar. The icon is to the left of the Alerts Icon and rotates when your data or your cube is updating: When you click on the icon, you will see the status of ...
    • Release Notes - Acumatica Customization v2023.11.01 for AnterraBI

      In addition to general improvements to the AnterraBI user interface and features, the v2023.11.01 Customization includes the following enhancements and improvements: Improved Labor hour type classifications Improvements to mapping labor pay item to ...
    • Anterra's Acumatica Customization Project (AnterraBI)

      Latest Acumatica Customization Version: 2023.11.02 Downloading the latest version Choosing the right customization project for your Acumatica environment Depending on the structure of your cost codes there are unique versions of Anterra's ...
    • Acumatica Connected Application Authentication (SM303010)

      This process is often performed on your behalf by Anterra's staff during our initial implementation. Setup Acumatica Connected Application (SM303010) Login to your Acumatica instance as an administrator Go to the Connected Applications screen ...