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 firstname.lastname@example.org.