Downloads of v 17.24.29:


Last Update:

11 Jul 2018

Package Maintainer(s):

Software Author(s):

  • Invantive Software B.V.


Invantive Query SQL Tool

Invantive Query Tool

This is not the latest version of Invantive Query Tool available.

17.24.29 | Updated: 11 Jul 2018



Downloads of v 17.24.29:



Software Author(s):

  • Invantive Software B.V.

Invantive Query Tool 17.24.29

This is not the latest version of Invantive Query Tool available.

This Package Contains an Exempted Check

1 Test Passing and 1 Exempted Test

Validation Testing Passed

Verification Testing Exempt:

Requires dotnet4.7 and a reboot

To install Invantive Query Tool, run the following command from the command line or from PowerShell:


To upgrade Invantive Query Tool, run the following command from the command line or from PowerShell:


To uninstall Invantive Query Tool, run the following command from the command line or from PowerShell:


NOTE: This applies to both open source and commercial editions of Chocolatey.

1. Ensure you are set for organizational deployment

Please see the organizational deployment guide

  • Open Source or Commercial:
    • Proxy Repository - Create a proxy nuget repository on Nexus, Artifactory Pro, or a proxy Chocolatey repository on ProGet. Point your upstream to Packages cache on first access automatically. Make sure your choco clients are using your proxy repository as a source and NOT the default community repository. See source command for more information.
    • You can also just download the package and push it to a repository Download

3. Enter your internal repository url

(this should look similar to

4. Choose your deployment method:

choco upgrade invantive-query-tool -y --source="'STEP 3 URL'" [other options]

See options you can pass to upgrade.

See best practices for scripting.

Add this to a PowerShell script or use a Batch script with tools and in places where you are calling directly to Chocolatey. If you are integrating, keep in mind enhanced exit codes.

If you do use a PowerShell script, use the following to ensure bad exit codes are shown as failures:

choco upgrade invantive-query-tool -y --source="'STEP 3 URL'"

Write-Verbose "Exit code was $exitCode"
$validExitCodes = @(0, 1605, 1614, 1641, 3010)
if ($validExitCodes -contains $exitCode) {
  Exit 0

Exit $exitCode

- name: Ensure invantive-query-tool installed
    name: invantive-query-tool
    state: present
    version: 17.24.29
    source: STEP 3 URL

See docs at

chocolatey_package 'invantive-query-tool' do
  action    :install
  version  '17.24.29'
  source   'STEP 3 URL'

See docs at

    Name: invantive-query-tool,
    Version: 17.24.29,
    Source: STEP 3 URL

Requires Otter Chocolatey Extension. See docs at

cChocoPackageInstaller invantive-query-tool
   Name     = 'invantive-query-tool'
   Ensure   = 'Present'
   Version  = '17.24.29'
   Source   = 'STEP 3 URL'

Requires cChoco DSC Resource. See docs at

package { 'invantive-query-tool':
  provider => 'chocolatey',
  ensure   => '17.24.29',
  source   => 'STEP 3 URL',

Requires Puppet Chocolatey Provider module. See docs at

salt '*' chocolatey.install invantive-query-tool version="17.24.29" source="STEP 3 URL"

See docs at

5. If applicable - Chocolatey configuration/installation

See infrastructure management matrix for Chocolatey configuration elements and examples.

Private CDN cached downloads available for licensed customers. Never experience 404 breakages again! Learn more...

This package was approved as a trusted package on 11 Jul 2018.


Invantive Query Tool

$ErrorActionPreference = 'Stop';

$packageName= 'invantive-query-tool'

$packageArgs = @{
  packageName = $packageName
  fileType = 'MSI'
  url = ''
  url64bit = ''
  softwareName = 'Invantive Query Tool'
  checksum = '050B485286AB5CFAA60A0930A166E23749C9E3B63F8DB5302F9E2E59E49986AB'
  checksumType = 'sha256'
  checksum64 = '050B485286AB5CFAA60A0930A166E23749C9E3B63F8DB5302F9E2E59E49986AB'
  checksumType64 = 'sha256'
  silentArgs = "/qn /norestart /l*v `"$env:Temp\invantive-query-tool-17.24.29-msi-install.log`""
  validExitCodes = @(0, 3010, 1641)

Install-ChocolateyPackage @packageArgs

Log in or click on link to see number of positives.

In cases where actual malware is found, the packages are subject to removal. Software sometimes has false positives. Moderators do not necessarily validate the safety of the underlying software, only that a package retrieves software from the official distribution point and/or validate embedded software against official distribution point (where distribution rights allow redistribution).

Chocolatey Pro provides runtime protection from possible malware.

Version Downloads Last Updated Status
Invantive Query Tool 20.1.398-BETA 6 Tuesday, April 20, 2021 Approved
Invantive Query Tool 20.1.396-BETA 10 Wednesday, April 14, 2021 Approved
Invantive Query Tool 20.1.394-BETA 17 Wednesday, April 7, 2021 Approved
Invantive Query Tool 20.1.393-BETA 13 Monday, April 5, 2021 Approved
Invantive Query Tool 20.1.392-BETA 14 Thursday, April 1, 2021 Approved
Invantive Query Tool 20.1.388-BETA 30 Monday, March 22, 2021 Approved
Invantive Query Tool 20.1.386-BETA 32 Thursday, March 18, 2021 Approved
Invantive Query Tool 20.1.385-BETA 17 Tuesday, March 16, 2021 Approved
Invantive Query Tool 20.1.378-BETA 15 Sunday, March 14, 2021 Approved
Invantive Query Tool 20.1.372-BETA 18 Tuesday, March 9, 2021 Approved

Included components:

  • Invantive.Producer.Windows 17.24.29

Version 17.24.28, released 2018-07-09.

Bug fixes:

  • Improve performance of large IN clauses by sharing comparers.

Version 17.24.25, released 2018-07-06.

Bug fixes:

  • [ITGEN-2957] Dragging a nullable boolean column to a group crashes the grid.

Version 17.24.24, released 2018-07-04.

Bug fixes:

  • Avoid argument exception on block code.

Version 17.24.23, released 2018-07-03.


  • DH/QT: Default target folder of 'local export results' statement to the current working directory.

Version 17.24.22, released 2018-07-02.


  • [ITGEN-2842] Enable use of $C, $X, $P, $R in where clause of pick list for Excel cells.

Version 17.24.19, released 2018-06-29.


  • Separate use of Invantive Keychain and save password.

Version 17.24.17, released 2018-06-26.


  • [ITGEN-2870] Always require an alias in an Invantive SQL query when using distributed database.
  • [ITGEN-2629] Extensive rewrite of logon dialog styling to allow scrolling the database properties.

Bug fixes:

  • Make order of fields for translations editing more logical.
  • [ITGEN-2861] Regression bug itgenugs035
  • [ITGEN-2860] Filter failure itgendid048 The value %123123% is not a valid integer.

Version 17.24.15, released 2018-06-24.

Bug fixes:

  • Correct source of Use Invantive Keychain log on option.

Version 17.24.2, released 2018-06-15.

Bug fixes:

  • [ITGEN-2825] Fix 22P04: missing data for column "dc7373f753c9d25181c009f6217177".

Version 17.24.0, released 2018-06-14.


  • SQL: Allow specifying the timeout on a specific back-end provider action through execution option.
  • Improve upgrade scenarios for Data Replicator new not-null columns.
  • Inherit message code of inner error when running queries in Query Tool.
  • Allow filtering on data container ID when downloading feeds on Data Replicator.
  • Hide log on information in tooltip on connect for Control and Composition when not connected.
  • Use new syntax for Data Hub command line arguments.
  • Enable specification of days retention for forwarded incoming messages in text mode.
  • ITGEN-2640: Pagination Online SQL Editor.
  • itgen-2639: Do not display >, >> when at last page. Do not display <, << when at first.
  • ITGEN-2641: Shorten column for picture Base64 string.
  • Tool tip in logon screen.
  • Show also explanation on provider attributes on logon.
  • Enforce specification of export password for Invantive Keychain.
  • Implement 2FA token generator.
  • [ITGEN-2261] Hide error message window area when it has no contents.
  • [ITGEN-2608] Obfuscate settings not honored
  • Hamburger menu same margin all around on mobile in landscape.
  • Increase limit to 1000 due to increased limits for all enterprise drivers when used in free product.
  • Add support for table or view synonyms in available objects [ITGEN-2604].
  • Display alias and display name in partition choser of Invantive Query Tool.
  • Improve configure provider attributes question in Data Hub when there are some provider attributes already set.
  • Expand provider attribute category when having at least one attribute with a value.
  • Memorize and use multiple credentials per data container alias.
  • Add Invantive Keychain tools window.
  • Enable toggle of save logon settings in text mode applications.
  • Save log on settings in Invantive Keychain for interactive products.
  • Data Hub: Set provider attributes through command line.
  • Data Hub: Set data container credentials.
  • No description paragraph when no description is given.
  • Allow specification of label and unencrypted value in Invantive Script.
  • Implement safer way to write default values to the console.
  • Clear credentials on request.
  • Move providers.xml to settings.xml.
  • Save credentials new logon dialog.
  • Improved logon dialog -> Update auto discovery.
  • Remove superfluous precision below day from name of log file for generated Data Hub scripts.
  • Add use of encrypted Invantive Script variable values [SECURITY].
  • Simplify partition choser when there are no meaningful options for state, city and owner.
  • Improve defaults for saving of encrypted connection string.
  • [ITGEN-1761] Log on to EOL using client Id and long term token for developers
  • [ITGEN-2480] Support encryptedtoken in settings.xml, include some tips on use in generated settings.xml of Invantive Cloud. -> We support encryptedConnectionString now.

Bug fixes:

  • Guard against NullReferenceException in Invantive SQL pseudo-code.
  • Hide data containers with no selectable partitions in Query Tool partition selector.
  • Reduce memory footprint [ITGEN-2582].
  • Fix issue with missing fields on insert from clipboard.
  • Ensure the WPF application context isn't closed halfway the program. This is possibly due some changes in .NET 4.7.x.
  • Changed garbage collection output into a report message instead of error window.
  • [ITGEN-2634] Unsupported partition chooser type.
  • [ITGEN-2610] Incorrect code inserted on double click in available objects
  • [ITGEN-1020] Right-align numbers in Diagnostics.
  • Hide Query Tool partition chooser on platforms with no partitions such as Oracle.
  • Avoid itgenrst009 on klm_nk for platforms with column names exceeding 61 characters.
  • [ITGEN-2568] Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it.
  • [ITGEN-2571] Place cursor focus on first enterable field (user name or whatever) on login.
  • Avoid NullReference when opening Preferences window through Diagnostics before connecting.
  • Fix length of ftn_code in Invantive Producer to meet new function codes.
  • Avoid runaway when email address is not valid and running in headless mode (itgenuty545).
  • [ITGEN-2487] Error itgencun016: Could not determine Data Replicator messages.
  • Fix can't find resources.xaml error [ITGEN-2492].

Version 17.20.1, released 2018-04-10.


  • [ITGEN-2271] Add test button to Data Cache connection string in editor window.
  • [ITGEN-2221] Display audit fields (read-only) ID, created by / on / date on Database editor WPF window.
  • [ITGEN-2209] Editable Connection Pooling and Rewrite property on Data Container
  • [ITGEN-1161] Send all logging in one go instead of one each time
  • Add support for force native to Invantive Web Service definition [ITGEN-2429].
  • Change min. height for login screen.
  • Expand/collapse query for mobile landscape, maximum height for query input, better padding and width of query input for landscape.
  • Adjust exporting to accommodate related changes to export formats.
  • New version of Online SQL Editor, including all necessary changes since the more rigid ResultSet checks.
  • Teamleader: log off before connecting.
  • Teamleader fill in credentials.
  • Data Loader: Add partition chooser.
  • Allow both lower and upper case input in text mode on Yes/No questions.
  • Include documentation column on providers in Data Dictionary.
  • Replace 32x32 partition icon with 64x64 image.
  • Add 'local on error ignore' and exit with error on 'local on error continue' when an error occurs.
  • Added Data Loader in Query Tool menus.
  • Add "local column xxx heading" syntax for GUI applications.
  • Allow space in actions with local export documents statement.
  • Raise no longer an error on export of empty data set.
  • [ITGEN-2009] Support executing a file through @@ in Query Tool as in Data Hub. Also add support for it to Data Access Point.
  • Data Cache: event log panel in Query Tool.
  • Added tabs for Data Replicator and table function parameters.
  • Added documentation panel to available objects overview.
  • Added documentation panel to available objects overview.
  • Load license file from text mode configure license form.
  • Added more fields in table describe.
  • Add requested fields.
  • Add statistics on my incoming messages for Data Replicator.
  • Query Tool: Add general tab in describe windows when pressing F4 in the query editor.
  • Check that Windows Update has installed updates at most 180 days ago.
  • Extend export options by TSV format in menus and Invantive Script.

Bug fixes:

  • Avoid itgenlow002 error when there is no KeePass driver licensed [ITGEN-2467].
  • Disable new database discovery window for production release.
  • [ITGEN-2451] Settings-xxx.xml is overwritten by Invantive software instead of being only merged.
  • [ITGEN-477] Conversie issue: kan text in cel niet opslaan in query tool
  • [ITGEN-1930] Jumping context in log on database chooser.
  • [ITGEN-2430] Partition chooser no longer working in Online SQL Editor.
  • Enable use of Invantive Studio across Invantive Web Service.
  • Correct version label in Online SQL Editor.
  • Fix error on double clicking available objects in Query Tool.
  • Fix partition chooser in Invantive Control [ITGEN-2362]
  • Data Loader: Fix selected divisions.
  • Correct escaping of & in WPF partition choser.
  • Show correct count of rows processed in Data Loader. It was off by 1.
  • [ITGEN-1877] Describe not working on table functions.
  • Updated partitioning in Control and Composition to allow selection of the partition when having multiple data containers opened, like two Exact Online accounts.
  • Improve performance of Oracle Invantive Producer-based products by reducing audit trail when running on platform with no audit trail.
  • Only show supported databases in log on window, depending on product.
  • Avoid error on describe window pop-up when columns can not be determined.
  • Do not allow use of data containers with connection pooling on Invantive Studio.
  • Fill required fields of Invantive Producer provider.
  • Do not freeze parent window of Data Loader due to repairing parent window.
  • Correctly generate environment variable INVANTIVE_LOG_FILE_OVERWRITE value when set to false.
  • Add missing picture to Invantive Data Loader.
  • Fix Invantive Data Loader started from Excel.
  • Reduce duration of audit events in configuration files from 100 to 7 days for better performance.
  • Improve performance of function license checks.
  • Avoid UI error when exporting CSV to a file from within Query Tool [ITGEN-2062].
  • Fix creating multiple files with export results without split column specification.
  • Enable user language to be set from windows products before connecting.

Version 17.13.8, released 2017-12-06.


  • Open documents from Exact Online and other sources in Invantive Composition.
  • Open documents from Exact Online and other sources in Invantive Composition.
  • Allow deviating license contract code for authentication on Customer Service on behalf of Data Replicator.
  • Add view maintenance: install business views on Postgresql and SQL Server [ITGEN-1918]
  • Add view maintenance: install business views on Postgresql and SQL Server [ITGEN-1918]
  • Add additional domains and values for Exact Online.
  • Added Accountancy endpoints to Exact Online provider.
  • Reduce length of call stack printed in console window for Data Hub
  • Show number of messages downloaded by trickle loading after download feed in Data Replicator.
  • Show URL to configure webhooks for trickle loading in console user interface.
  • Add domain tables for Exact Online.
  • Updated ExactOnline REST metadata.
  • Correct outcome of equals sign when selecting on code in accounts in EOL REST [ITGEN-104]
  • Add option to export technical headers (column names) instead of user-friendly labels [ITGEN-1937].
  • Allow use of COMPRESS as a column name [ITGEN-1936].
  • Add EZ-Base provider.
  • Add fixed days to run methods for Exact Online plus new LOV IntrastatTypes.
  • Improve error message on 403 Forbidden for Exact Online XML by including division number.
  • Enable group functions on Open Data and with premium license in Invantive Query Tool.
  • Add create or replace table support for ANSI SQL providers: PostgreSQL and SQL Server
  • Log downloaded messages in event log for Data Replicator.
  • Display metadata droppable days in Data Cache text form.
  • Fill new fields on Exact Online transaction lines / bulk with GL account information.
  • Allow configuration after how many days the table partition version metadata is dropped from Data Replicator
  • Optimize memory usage when joining with an empty row in a left outer join.
  • Add unique entry ID to every XML element. [ITGEN-1898]
  • Add extensive GL Account information on Exact Online GL transaction lines.
  • Allow download feed from Data Cache menu in Data Hub.
  • Allow Data Replicator messages from feed to be deleted.
  • Enable data model upgrade without restarting Data Replicator.
  • Change default of maintain partition views to false.
  • Upgrade Data Replicator data model to support date occurrence at server local time.
  • Add date of event occurrence for Data Replicator in server local time.
  • Add GLAccountClassificationMappings for Exact Online [ITGEN-1891].
  • Store in-memory table directly from result set to improve performance.
  • Invantive SQL: Return correct return type for parameters.
  • Clarify error message itgenprr005 with actual string value.
  • Force garbage collection on disconnect to database.
  • Collect garbage after dropping in memory storage provide table.
  • Show in diagnostics whether a 32-bit application is large address aware (3 GB addressable).
  • Reduce memory footprint of results.
  • Cache HTTP requests on disk when requested.
  • Instrument software with measurements, available in [email protected]
  • Improve speed of HTTP cache.
  • Reduce memory footprint of OData EDM data types.
  • Reduce memory footprint by trimming sparse arrays.
  • Improve hints on password manager suggestions on log on.
  • Correct calculation of century and era in calendar of Data Dictionary.
  • Add table function regexp_split_row to split text according to regular expressions.
  • Improve suggestions for user names from password manager

Bug fixes:

  • Prevent errors in logon window on STA applications such as Query Tool.
  • Prevent crash when entering wrong user name or password on OAuth providers.
  • Correct layout of Data tab in Diagnostics. Numbers fit again.
  • Diversify errors on early compatibility checks.
  • Trim composed labels after translation to ensure readable labels even when the prefix translates to empty string.
  • Show error on multiple statement execution in the correct format.
  • Add translations to EZ-Base provider.
  • Raise error when a settings.xml has no version defined.
  • Allow connection string to be empty for trivial providers such as ECB.
  • Avoid NullReference in Data Hub for provider attribute with null default value.
  • Clarify error message in Data Hub and Query Tool when Exact Online wrong password entered.
  • Offer discovery in Data Hub when an undefined connection is specified.
  • Reduce length of call stacks.
  • NullReferenceException on query when not adding alias to default/first provider. [ITGEN-1948]
  • itgenemd007: An element with the key 'P_ACCOUNT_CODE' already exists in the dicitonary. [ITGEN-1939]
  • Slow or OutOfMemoryException on parameter pick lists. [ITGEN-1940]
  • Fix invalid parameter binding Invantive Studio on log on [ITGEN-1863]
  • Stability improvements to the SQL engine. Calculations with DateTime return the right data type now.
  • Remove temporary code that caused bulk insert on SQL Server to fail.
  • Enable more than 100 rows result sets with full Invantive SQL license in Query Tool.
  • Merge Open Data license and free license on Invantive Query Tool.
  • Avoid NullReferenceException when the KDBX database could not be decrypted.
  • itgenmsy001 The index position 525 is not in use. The last index used is 304. [ITGEN-1906]
  • Date subtract gives wrong outcome by factor -24. [ITGEN-1910]
  • itgenoda093: At least one division is missing in your filter. Missing divisions: . [ITGEN-1907]
  • Return fields in the correct order when passing select fields to the OData/ODataProvider.Fetch method.
  • Fix data type error on column ALLOW_DISPLAY for query for SystemProviderAttributes.
  • Ensure vital messages are sent to the customer service on a failing program.
  • Lower-case views for partition and overall storage in Data Replicator.
  • Avoid error on Invantive Web Service trying to rewrite connection string.

Details of Release Notes:

Version 17.10.172:
Reduce length of call stack printed in console window for Data Hub
Also delay a few seconds after an error to allow the user to read it.

Version 17.10.115:
Add create or replace table support for ANSI SQL providers: PostgreSQL and SQL Server
Include bulk insert from result set of query.
Allow configuration after how many days the table partition version metadata is dropped from Data Replicator
Upgrades Data Replicator / Data Cache repository to version 4.

Version 17.10.37:
Improve suggestions for user names from password manager
Define INVANTIVE_EXCLUDE property on KDBX entry to exclude it.
Define INVANTIVE_HINT property or tags with matching texts to make it more likely to match.

Discussion for the Invantive Query Tool Package

Ground Rules:

  • This discussion is only about Invantive Query Tool and the Invantive Query Tool package. If you have feedback for Chocolatey, please contact the Google Group.
  • This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
  • The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
  • Tell us what you love about the package or Invantive Query Tool, or tell us what needs improvement.
  • Share your experiences with the package, or extra configuration or gotchas that you've found.
  • If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.
comments powered by Disqus