Try 180 days free trialSubscribe



Combine Magento and Invantive Control for Excel now for the optimal experience

A common problem that many Magento users face, is that all your saved data can be quite overwhelming. By using Invantive Control for Excel, you will be provided with all the information you need about a subject of your choice by creating a clear overview of the data. Invantive Control will visualize, analyze and control any data you need, all within Excel. For example, you could put all your information about your current stock, projects, contacts, sales, saved organizations, processes etc. in one clear overview and decide what action you want to take based on that. Manually finding this data using Magento could be a time consuming task, while with Invantive Control for Excel all you need is just a few clicks.

The insightful information that Invantive Control for Excel provides will help you to easily analyze data generated with Magento and as a result help you to make better decisions. You will also get a much better understanding of the threats and opportunities of current and future projects. Invantive Control for Excel will help you to work more efficiently by saving lots of time and showing how easy it can be to analyze the data you want.

The Magento Edition of Invantive Control provides you with benefits such as:

  • Flexibility of Excel paired by an Excel add-in with the data integrity provided by Magento in the cloud.
  • Download and upload facts to Magento using an Excel add-in.
  • Create and execute predictive models such as payroll processes, leave and working time etc. from within Microsoft Excel.
  • Management and control of personnel administration and payroll processes.
  • Open and handle large templates and models within Excel using the integrated document management system (DMS).
  • Design and edit different spreadsheets based upon Magento.





Use Invantive Composition to easily compose complex Word documents with your Magento data

Manually collecting data and making tables in Word usually takes a very long time. The Magento database is very large which makes it hard find and process the data you need. Mainly in the case of regularly needed documents, this can be a very time consuming task. Invantive Composition offers a great solution to this problem. Invantive Composition helps you enter and edit data and tables from the Magento database with ease. You can specify which information and data you are interested in, and simply let Invantive Composition do the rest for you. Invantive Composition for Word will fill your previously created templates with data coming directly from the Magento database. This means that you don’t have to look up all the information manually. Making complex Word documents containing all the specific information you need is now just a matter of a few minutes and has never been easier.

Another great thing about Invantive Composition for Word is that there is no need for specific knowledge, additional training or a programmer. Invantive Composition is simple to operate, just like Microsoft Word. It’s also worth noting that the documents created with Invantive Composition can be used without the application, so recipients do not need the program.

The benefits of using the Magento edition of Invantive Composition for Word

The Magento Edition of Invantive Composition for Word provides you with the following benefits:

  • Optimization of the documenting and communication process.
  • Automatically fill pre-composed templates in Word.
  • Focus on your Magento business, not on technology; without any programming and without software developers.
  • Reduce time-to-market for changing your business by reducing effort by your IT department.
  • Merge unstructured texts in a document with structured data.
  • Directly open documents in Word that were stored in your Magento database, document management system or file system.
  • Internal search engine to search documents on their classification.
  • Reduction of erroneously prepared documents and production costs.




Query Tool

Free Real-time Business Intelligence for Magento using the Invantive Query Tool

When using Magento, it can often be a challenging task to gain access to your crucial company information stored in the Magento cloud. All the information can get overwhelming and cause confusion. The free Invantive Query Tool will provide you with real-time Business Intelligence across your entire enterprise and will make storing, organizing and locating your operational data easier than ever before. The Invantive Query tool will enable you to analyze your operational data and enhance your real-time reporting because all information stored in the Magento database will be available on demand. This will allow you to visualize opportunities and threats, but also deliver reports to the management team. This way you can make the right business decision.

To gain access to the Invantive Query Tool, all you have to do is download the software on your computer. You can extract, organize and analyze data stored in the Magento cloud at any time and you can save your reports in PDF, Excel and various other formats. Another great thing about the Invantive Query Tool is that there is no need for programming, coding or Excel downloads; you can simply use the SQL knowledge you already have.

Optimize your Business Intelligence with Magento and the Invantive Query Tool

The Invantive Query Tool software provides you with the following benefits:

  • Automatic analysis of your business activities, compliance and business rules.
  • Uncover threats and opportunities by turning operational data into real-time intelligence.
  • Connect real-time to your data warehouse and repository for on and off database reporting.
  • Share reports in PDF, SQL, CSV, Excel and XPS formats with information from Magento.
  • Directly connect to Magento; no programming, no coding, no Excel downloads.
  • Open SQL scripts from the file system or a document management system.





Connect your applications using proven Invantive technology and ADO.NET

Invantive Bridge is an SDK that enables your applications and databases to connect using the same technical features as offered by the range of Invantive products. Invantive Bridge provides cloud connectivity as well as an advanced SQL engine and drivers. With Invantive Bridge you can access your cloud and on-premise applications and data from within Microsoft Visual Studio, Microsoft Power BI, Telerik and many others using familiar SQL statements and Microsoft ADO.NET.

The use of the cloud connectivity options of Invantive Bridge allows you to use a wealth of connection options to combine applications, processes and data across the cloud into one connected solution.

The advanced Invantive SQL engine within the SDK enables your solutions to offer an easy reporting and analysis environment independent of and in addition to the connectivity protocols already available. Both 32 and 64 bit drivers are supported.

The following Invantive SQL features are included:

  • Select
  • Insert
  • Update
  • Delete
  • Parallel
  • Distributed
  • Procedural

Connections can be made to the platforms listed below. Some connectors such as traditional database drivers require additional licenses and/or software:

  • Atom
  • Business Exact Online
  • Business Invantive Vision
  • CBS.NL
  • DocumentCloud
  • Dummy
  • Dynamics CRM
  • ECB Exchange Rates
  • Exact Online Combined
  • Excel
  • Facebook
  • Freshdesk
  • GitLab
  • Microsoft Graph
  • In Memory Storage
  • JIRA
  • Kadaster
  • LDAP
  • LinkedIn
  • Logging
  • Magento
  • Mail
  • Mapping
  • MySQL
  • NASA
  • Nmbrs
  • OAuth Headless
  • OAuth Windows Forms
  • OData
  • ODBC
  • Oracle Legacy
  • Oracle Managed
  • OS
  • PostgreSQL
  • RDW.NL
  • RSS
  • Salesforce
  • SQL Server
  • StackExchange
  • TeamViewer
  • Teradata
  • Twinfield
  • WMI
  • XML Audit File Cash Registers
  • XML Audit File Financial
  • XML Audit File Salary
  • XML

User types: End user, Designer

User Interface Languages: English, Dutch, German, French, Russian, Italian, Portuguese, Spanish, Chinese, Hindi, Arabic

  • Support available 9:00-17:00 CET through phone +31 88 00 26 599 or
  • The preferred dealer for Invantive's PowerBI solutions is KPI Solutions. You can reach Gino van Altena by email and by mobile phone +31 6 23 16 02 51.

Certified for use with

  • Microsoft .NET 4.5.2
  • Microsoft .NET 4.6.0
  • Microsoft .NET 4.6.1
  • Microsoft .NET 4.6.2
  • Microsoft Power BI
  • Microsoft Visual Studio 2015
  • Windows Server 2008R2
  • Windows Server 2012
  • Windows Server 2012R2
  • Windows Server 2016
  • Windows Terminal Server
  • Microsoft Windows 10
  • Microsoft Windows 7
  • Microsoft Windows 8.0
  • Microsoft Windows 8.1

Invantive Bridge connects your applications

The Magento Edition of Invantive Bridge provides you with benefits such as:

  • Cloud-connectivity.
  • Microsoft Power BI and Visual Studio.
  • Microsoft ADO.NET driver.
  • Advanced Invantive SQL engine.
  • Large number of possible on-premise and cloud platforms.




Data Hub

Controlled and timed data exchange for Magento

The Magento Edition of Invantive Data Hub is command-line driven software that is capable of executing Invantive Query Tool-compatible scripts across many database and cloud platforms. Ideal for high volume data loads and extractions of Magento. It provides a headless mode which makes it ideal for use in server environments and scheduled uploads and downloads in lights-out operations.

Thanks to compatibility with the popular Invantive Query Tool scripting language, you can easily move business processes you have designed on Invantive Query Tool into a server environment. Besides high volume data loads you can also generate reports in Excel and other formats using data from Magento.

The support for headless mode enables Invantive Data Hub to be started by batch files or from the Windows Task Scheduler. When running Invantive Data Hub in headless mode, you will enjoy the integrated logging features for ease of analysis and auditability.

Optimize your Magento processes

The Magento Edition of Invantive Data Hub provides the following benefits to optimize your processes:

  • Schedule and run high volume data loads and extractions of Magento.
  • Headless and command-line driven for use on servers.
  • Invantive scripting language and Invantive SQL compatible.
  • Share reports in PDF, SQL, CSV, Excel and XPS formats to network shares or DropBox.
  • Access all Magento APIs through tables.




data replicator

Replicate data from Magento in a relational database

Invantive Data Replicator allows you to replicate data from Magento 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 Magento. Effectively you get a so-called "ODS" (Operational Data Store). The performance gain compared with repeatedly accessing the XML and REST APIs of Magento 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 Magento.

Data Replicator runs on 32 and 64 bit Windows devices.

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

Replicate your Magento data with Invantive Data Replicator

The Magento 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.




data loader

Load data into cloud applications and relational databases

Invantive Data Loader transports data between Magento, cloud applications, relational databases and files in one integrated solution. Based upon Invantive SQL with it's dozens of connectors, you can easily load data into your cloud application or relational database using a graphical user interface.

For instance, Invantive Data Loader guides you through the exchanging data with Magento and many other platforms with a few clicks. It can take data from over 50 platforms such as Magento, Microsoft SQL Server, PostgreSQL, Exact Online, Freshdesk or CSV or Excel files.

The integrated advanced Invantive SQL engine provides a proven base for you to exchange data, including the use of fast bulk loaders on supported platforms such as Microsoft SQL Server. A flexible mapping of fields enables basic transformations during the process, while the flexibility of Invantive SQL on the background ensures that no tasks is too hard to accomplish.

The free version of Invantive Data Loader is restricted to at most 1.000 rows per run. For high volume use or background processing, please consider the use of compatible enterprise solutions such as Invantive Data Hub or Invantive Control. An unlimited use variant is included in these solutions.




data access point

Add additional protocol support to Magento APIs

The Magento Edition of Invantive Data Access Point is available both online and on-premise. The software allows you to exchange data across various communication protocols with Magento. But also interfaces for EDI (XML, text), MailChimp, outbound email, PayPal, web services, Odoo and/or Sugar CRM can easily be established using the available API connectors.

Invantive Data Access Point acts as a proxy that based upon Invantive SQL statements (such as used with ODBC driver or JDBC) exchanges data with Magento using ten additional API protocols:

  • HTML
  • XML
  • JSON
  • BSON
  • Atom
  • RSS
  • CSV
  • Text
  • Excel 2007
  • XML+XSL.

All features of the software can be used during 30 days for free. After registration you will get invoiced EUR 50 every month you use Invantive Data Access Point (per 10 administrations). For each additional administration EUR 5 will be charged. There is no term of notice; when you stop using the software you will only get an invoice for the current month and no subsequent invoices.

Cross-protocol data exchange across many platforms

Invantive Data Access Point provides the following benefits to optimize your business processes:

  • Simplify business process automation by integration and orchestration.
  • Extend Magento by supporting many additional communication protocols.
  • Re-use Invantive SQL statements to specify data down- and uploads.


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

Privacy Policy X

Effective date: August 26, 2019

Invantive BV ("us", "we", or "our") operates the website (hereinafter referred to as the "Service").

This page informs you of our policies regarding the collection, use and disclosure of personal data when you use our Service and the choices you have associated with that data.

We use your data to provide and improve the Service. By using the Service, you agree to the collection and use of information in accordance with this policy. Unless otherwise defined in this Privacy Policy, the terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, accessible from

Revision History


Information Collection and Use

We collect several different types of information for various purposes to provide and improve our Service to you.

Types of Data Collected

Personal Data

While using our Service, we may ask you to provide us with certain personally identifiable information that can be used to contact or identify you ("Personal Data"). Personally identifiable information may include, but is not limited to:

We may use your Personal Data to contact you with newsletters, marketing or promotional materials and other information that may be of interest to you. You may opt out of receiving any, or all, of these communications from us by following the unsubscribe link or instructions provided in any email we send or by contacting us.

Usage Data

We may also collect information on how the Service is accessed and used ("Usage Data"). This Usage Data may include information such as your computer's Internet Protocol address (e.g. IP address), browser type, browser version, the pages of our Service that you visit, the time and date of your visit, the time spent on those pages, unique device identifiers and other diagnostic data.

Tracking & Cookies Data

We use cookies and similar tracking technologies to track the activity on our Service and we hold certain information.

Cookies are files with a small amount of data which may include an anonymous unique identifier. Cookies are sent to your browser from a website and stored on your device. Other tracking technologies are also used such as beacons, tags and scripts to collect and track information and to improve and analyse our Service.

You can instruct your browser to refuse all cookies or to indicate when a cookie is being sent. However, if you do not accept cookies, you may not be able to use some portions of our Service.

Examples of Cookies we use:

Use of Data

Invantive BV uses the collected data for various purposes:

Legal Basis for Processing Personal Data under the General Data Protection Regulation (GDPR)

If you are from the European Economic Area (EEA), Invantive BV's legal basis for collecting and using the personal information described in this Privacy Policy depends on the Personal Data we collect and the specific context in which we collect it.

Invantive BV may process your Personal Data because:

Retention of Data

Invantive BV will retain your Personal Data only for as long as is necessary for the purposes set out in this Privacy Policy. We will retain and use your Personal Data to the extent necessary to comply with our legal obligations (for example, if we are required to retain your data to comply with applicable laws), resolve disputes and enforce our legal agreements and policies.

Invantive BV will also retain Usage Data for internal analysis purposes. Usage Data is generally retained for a shorter period of time, except when this data is used to strengthen the security or to improve the functionality of our Service, or we are legally obligated to retain this data for longer periods.

Transfer of Data

Your information, including Personal Data, may be transferred to - and maintained on - computers located outside of your state, province, country or other governmental jurisdiction where the data protection laws may differ from those of your jurisdiction.

If you are located outside Netherlands and choose to provide information to us, please note that we transfer the data, including Personal Data, to the Netherlands and process it in the Netherlands and other countries within the European Union.

Your consent to this Privacy Policy followed by your submission of such information represents your agreement to that transfer.

Invantive BV will take all the steps reasonably necessary to ensure that your data is treated securely and in accordance with this Privacy Policy and no transfer of your Personal Data will take place to an organisation or a country unless there are adequate controls in place including the security of your data and other personal information.

Disclosure of Data

Business Transaction

If Invantive BV is involved in a merger, acquisition or asset sale, your Personal Data may be transferred. We will provide notice before your Personal Data is transferred and becomes subject to a different Privacy Policy.

Disclosure for Law Enforcement

Under certain circumstances, Invantive BV may be required to disclose your Personal Data if required to do so by law or in response to valid requests by public authorities (e.g. a court or a government agency).

Legal Requirements

Invantive BV may disclose your Personal Data in the good faith belief that such action is necessary:

Security of Data

The security of your data is important to us but remember that no method of transmission over the Internet or method of electronic storage is 100% secure. While we strive to use commercially acceptable means to protect your Personal Data, we cannot guarantee its absolute security.

Our Policy on "Do Not Track" Signals under the California Online Protection Act (CalOPPA)

We do not support Do Not Track ("DNT"). Do Not Track is a preference you can set in your web browser to inform websites that you do not want to be tracked.

You can enable or disable Do Not Track by visiting the Preferences or Settings page of your web browser.

Your Data Protection Rights under the General Data Protection Regulation (GDPR)

If you are a resident of the European Economic Area (EEA), you have certain data protection rights. Invantive BV aims to take reasonable steps to allow you to correct, amend, delete or limit the use of your Personal Data.

If you wish to be informed about what Personal Data we hold about you and if you want it to be removed from our systems, please contact us.

In certain circumstances, you have the following data protection rights:

Please note that we may ask you to verify your identity before responding to such requests.

You have the right to complain to a Data Protection Authority about our collection and use of your Personal Data. For more information, please contact your local data protection authority in the European Economic Area (EEA).

Service Providers

We may employ third party companies and individuals to facilitate our Service ("Service Providers"), provide the Service on our behalf, perform Service-related services or assist us in analysing how our Service is used.

These third parties have access to your Personal Data only to perform these tasks on our behalf and are obligated not to disclose or use it for any other purpose.

Links to Other Sites

Our Service may contain links to other sites that are not operated by us. If you click a third party link, you will be directed to that third party's site. We strongly advise you to review the Privacy Policy of every site you visit.

We have no control over and assume no responsibility for the content, privacy policies or practices of any third party sites or services.

Children's Privacy

Our Service does not address anyone under the age of 18 ("Children").

We do not knowingly collect personally identifiable information from anyone under the age of 18. If you are a parent or guardian and you are aware that your Child has provided us with Personal Data, please contact us. If we become aware that we have collected Personal Data from children without verification of parental consent, we take steps to remove that information from our servers.

Changes to This Privacy Policy

We may update our Privacy Policy from time to time. We will notify you of any changes by posting the new Privacy Policy on this page.

We will let you know via email and/or a prominent notice on our Service, prior to the change becoming effective and update the "effective date" at the top of this Privacy Policy.

You are advised to review this Privacy Policy periodically for any changes. Changes to this Privacy Policy are effective when they are posted on this page.

Contact Us

If you have any questions about this Privacy Policy, please contact us: