Invantive Data Replicator logo

Invantive Data Replicator

General Information

Invantive Data Replicator allows you to replicate data from cloud applications such as Freshdesk, Exact Online, Visma Severa, Nmbrs and over 50 other platforms in a relational database such as Microsoft SQL Server or PostgreSQL. Invantive Data Replicator manages that the data is of sufficient "freshness" for your reporting purposes by applying a combination of techniques, including near real-time synchronization using webhooks (where available and supported).

The performance gain is typically 50-2.500 times compared to repeatedly querying the cloud application's APIs directly.

The replicated data is made available through configurable views, including consolidation across multiple companies such as on with Exact Online and Nmbrs. Effectively you get a so-called "ODS" (Operational Data Store). These database views can be used in your Power BI reports, Microsoft Access, custom reports or traditional SQL of the platform. Data Replicator also automatically maintains indexes for optimal performance even with very large data sets and ad-hoc queries.

The advanced Invantive SQL engine included with Invantive Data Replicator enables you to configure the cloud sources for Data Replicator and triggering downloads. Data Replicator also includes Invantive Data Hub and Invantive Data Cache, so you can also run ad-hoc queries directly on over 50 cloud platforms, including cross-company and cross-country queries and uploads in Exact Online.

Data Replicator runs on 64 bit Windows devices. For compliance with data management and Exact Online guidelines you can only replicate data in a database managed by the owner of the Exact Online companies or by the legal entity administered.

  • The first subscription period includes 1 hours of Getting Started consultancy.
  • Subscription per 100 companies.
  • Support available 9:00-17:00 CET through phone +31 88 00 26 599 or support@invantive.com.

Invantive Data Replicator offers you benefits such as:

  • Replication ensures use of fresh data.
  • Consolidation into one reporting environment.
  • Fresh data using a combination of techniques.
  • Run on inexpensive PostgreSQL and Microsoft SQL Server databases.
  • Large number of possible on-premise and cloud platforms.

Samples

Download

Getting Started

In this instruction you will learn how to replicate your first Exact Online environment within 15 minutes.

First make sure you have the following preparations finished:

  • You have an empty database on SQL Server or PostgreSQL sized 4 times the size of a backup in Exact Online.
  • You have a database user, preferrably with SQL authentication, and a password.
  • The database user has access to the empty database.
  • The database user was able to successfully execute "create table test(col1 varchar(1))" to create a table in that database.

Then execute the following steps:

  • As a next step, download Invantive Data Hub with integrated Data Replicator from this site.
  • Connect to Exact Online.
  • TO DO: describe how to set the backing database with one statement.
  • Enter "alter persistent cache load" to replicate all data sets.
  • Or enter "select count(*) from exactonlinerest..journals" to replicate only the journals.
  • Once started, open your PgAdmin (PostgreSQL) or Microsoft SQL Server Management Studio.
  • Check the number of views in your previously empty database grow.
  • Query a view and be amazed on the performance!

Contact

Invantive
  • Invantive® BV
  • Biesteweg 11
  • 3849 RD Hierden
  • the Netherlands
  • Bank: IBAN NL 42 RABO 01 23 4097 80, BIC RABO NL 2U.
  • PayPal: sales@invantive.com
  • Rabobank Groep N.V., Branch: Rabobank Peel, Maas en Leudal.
  • Sint Antoniusstraat 40, 6093 GC, Heythuysen, the Netherlands