- Home
- invantiveget my report
- invantivecurrency toolsFree
- invantiveauthenticatorFree
- invantivecloudfor Power BI
- invantivecontrolfor Excel
- invantivecompositionfor Word
- invantivebusinessfor Outlook
- invantivebusinessfor Windows
- invantivequery toolFree
- invantiveonline sql editorFree
- invantivedata loaderFree
- invantivedata hub
- invantivedata access point
- invantivedata replicator
- invantivebridge
Business Apps
Office-apps
SQL API
Server
invantivedata replicator
Replicate data from Exact Online in a relational database
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 XML and REST APIs of Exact Online 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 in Exact Online.
Data Replicator runs on 32 and 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 hour 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.
Replicate your Exact Online data with Invantive Data Replicator
The Exact Online Edition of Invantive Data Replicate provides the following benefits to optimize your business processes:
- Replication ensures use of fresh data.
- Fresh data using a combination of techniques.
- Consolidation into one reporting environment.
- Runs on inexpensive PostgreSQL and Microsoft SQL Server databases.
- Over 50 supported on-premise and cloud platforms.
Download
Samples
- Invantive BV
- Biesteweg 11
- 3849RDHierden
- the Netherlands
- Telephone : +31 88 00 26 500
- Support : +31 88 00 26 599
- Office hours : 09:00 - 17:00 CET
- Email : info@invantive.com
- Web: https://invantive.com
- Portal: cloud.invantive.com
- Portaal: cloud.invantive.com
- Privacy Policy
- Privacybeleid
- Report security incident
- Telephone : +31 88 00 26 598
- Email : security@invantive.com
- More information
- More information
Information for use in Microsoft Outlook
- Chamber of Commerce : 130 31 406
- Managing Director : Guido Leenders
- Company domiciled inRoermond.
- VAT : NL812602377B01
- Founded :
- 2012 NAICS: 511210
- 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