Invantive Software B.V. Subscription Invantive Data Replicator for All Cloud

Replicate data from cloud applications in a relational database

Invantive Data Replicator replicates data from cloud applications in a relational database for up to 2.500 times faster reports.

Invantive Data Replicator allows you to replicate data from Exact Online and over 50 other platforms in a relational database such as Microsoft SQL Server or PostgreSQL. Invantive Data Replicator ensures the presence of sufficiently "fresh" data for your reporting purposes by applying a combination of techniques, including near real-time synchronization using webhooks (where available and supported).

The replicated data is made available through configurable views, including consolidation across multiple companies such as with Exact Online and Nmbrs. Effectively you get a so-called "ODS" (Operational Data Store). The performance gain compared with repeatedly accessing the cloud APIs is between 50 and 2.500.

These database views can be used in your Power BI reports, Microsoft Access, custom reports and from traditional SQL. 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 trigger 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 such as for Exact Online.

Data Replicator runs on 32 and 64 bit Windows devices.

Optimize your large scale reporting with the Invantive Data Replicator

Invantive Data Replicator provides the following benefits to optimize your business reporting:

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

Supported Platforms

Invantive Data Replicator supports over 50 database platforms and (cloud) applications such as:

• Microsoft SQL Server
• MySQL
• Oracle RDBMS
• Teradata
• IBM DB2 UDB
• ANSI SQL
• ODBC
• PostgreSQL
• Exact Online
• Salesforce
• Freshdesk
• Dynamics CRM
• Nmbrs
• Loket.nl
• Teamleader

Please consult the minimum system requirements for full details.