Invantive Query Tool

SQL Query Tool

SQL Query Tool for Databases and Cloud Applications

Free Real-time Operational Intelligence

Invantive's free Query Tool provides you with real-time Operational Intelligence (OI) across your entire enterprise. The free Query Tool provides access to your real-time data warehouse and databases running on MySQL, Oracle, SQL Server, Teradata, IBM DB2/UDB or elsewhere. This enables you to store, organize and locate your operational data fast. The optional repository, provided by Invantive Producer, allows you to transfer, assemble, integrate, store and access data from multiple sources. You will be able to extract and analyze operational data such as project execution, manufacturing, software development and service operations. The Invantive Query Tool empowers you to run SQL and Oracle PL/SQL query programs to gain real-time insight into your business operations. You will be able to execute complex queries to monitor all your operational activities, check them for compliance and business rules, identify threats and make the right decisions. With the free Query Tool you will be empowered to turn operational data into actionable information and succeed in the challenging environment of your industry.

Analyze your operational data and enhance your real-time reporting

With the Invantive Query tool you will have all your company's operational data available on demand. The Query Tool empowers you to execute queries, capture and analyze your data and create business reports in real-time. No matter where the data has been stored: Microsoft SQL Server, Oracle, MySQL, Teradata, IBM DB2/UDB or elsewhere. You will be able to extract information such as billable hours, project and process activities, employee leave and attendance with ease. Your database administrators will be able to recover, edit, save, import and export the data to Microsoft Excel and XPS, Adobe PDF, SQL and CSV. In addition the Query Tool allows you to import pre-filled templates direct from an optional Document Management System (DMS) such as Microsoft SharePoint or Invantive Vision. Those functionalities enable you to create and deliver financial, operational or other business reports to executives in real-time.

Deliver your reports on different formats

The reports can be created and delivered on database and non-data formats. On database reporting enables you to use analytical applications, which may be created with Invantive Producer, to analyze the data stored in the repository. In addition, on database reporting allows you to execute queries to analyze your data. The non-database reports can be delivered in your preferred format. The Invantive Query Tool allows you to create detailed reports in formats such as Microsoft Excel, Microsoft XPS, Adobe PDF and delimited text (CSV). Groupings created within the query results grid are retained within the export, including grouping in Microsoft Excel.

Remotely connect to any database

The free Query Tool delivers a user friendly SQL editor and parser with syntax highlighting. The SQL editor enables you to connect to different databases, integrate, virtualize and export your data over web services when used in combination with Invantive Web Service. This empowers you to parse, edit, import and export data in formats such as: Electronic Data Interchange (EDI), flat files, eXtensible Business Reporting Language (XBRL), eXtensible Markup Language (XML) and Microsoft Excel. The SQL editor enables you to upload queries, which may be created with Invantive Producer, open recent and historical files, edit and execute your scripts with ease. The parser allows you to highlight SQL syntax, validate, clean up, and parse your text based scripts with ease. With the SQL Parser and editor you will be able to check scripts before they run, build and apply complex queries to your data warehouse easily. With the Graphical User Interface (GUI) you will be empowered to simple integrate data, execute queries and manage multiple databases. Invantive's free Query Tool provides all the functionalities needed to integrate, virtualize and export your business data within one solution.

Optimize your Business Intelligence with the Invantive Query Tool

The Invantive Query Tool provides all the functionalities needed to make the right business decisions. Businesses and organizations will be provided 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.
  • Minimize difficulties generating, validating and executing SQL code with the Query Tool and Invantive Producer.
  • Cleanup, edit, parse and execute SQL queries over web services and multiple databases with one system.
  • Execute SQL queries on IBM DB2/UDB, Teradata, MySQL, Oracle RDBMS, Microsoft SQL Server and other platforms.
  • Open pre-filled scripts optionally directly from the document management system.
  • Access your databases over the Internet (HTTPS access) when used in combination with Invantive Web Service.

With the free Query Tool you will find all the functionalities needed to make the right business decisions and keep up with the pace of your industry. Professionals from different industries use and recommend our Query Tool as a trusted software solution. Since they have chosen for the Invantive Query Tool their Operational Intelligence has been improved.




Download manualDownload PDFDownload manualDownload PDF


  • 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: