Downloads of v 17.17.68-BETA:


Last Update:

10 Feb 2018

Package Maintainer(s):

Software Author(s):

  • Invantive Software B.V.


Invantive Oracle plsql repository Studio

Invantive Studio

This is a prerelease version of Invantive Studio.

  • 1
  • 2
  • 3

17.17.68-BETA | Updated: 10 Feb 2018



Downloads of v 17.17.68-BETA:



Software Author(s):

  • Invantive Software B.V.

  • 1
  • 2
  • 3
Invantive Studio 17.17.68-BETA

This is a prerelease version of Invantive Studio.

  • 1
  • 2
  • 3

This Package Contains an Exempted Check

Not All Tests Have Passed

Validation Testing Passed

Verification Testing Exemption:

Requires dotnet4.7 and a reboot


Scan Testing Successful:

No detections found in any package files

Learn More

Deployment Method: Individual Install, Upgrade, & Uninstall

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


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


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


Deployment Method:

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

1. Enter Your Internal Repository Url

(this should look similar to

2. Setup Your Environment

1. Ensure you are set for organizational deployment

Please see the organizational deployment guide

2. Get the package into your environment

  • 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. Copy Your Script

choco upgrade invantive-studio -y --source="'INTERNAL REPO URL'" --version="'17.17.68-BETA'" --prerelease [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-studio -y --source="'INTERNAL REPO URL'" --version="'17.17.68-BETA'" --prerelease

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

Exit $exitCode

- name: Install invantive-studio
    name: invantive-studio
    version: '17.17.68-BETA'
    state: present
    allow_prerelease: yes

See docs at

chocolatey_package 'invantive-studio' do
  action    :install
  source   'INTERNAL REPO URL'
  version  '17.17.68-BETA'
  options  '--prerelease'

See docs at

cChocoPackageInstaller invantive-studio
    Name        = "invantive-studio"
    Version     = "17.17.68-BETA"
    Source      = "INTERNAL REPO URL"
    chocoParams = "--prerelease"

Requires cChoco DSC Resource. See docs at

package { 'invantive-studio':
  ensure          => '17.17.68-BETA',
  install_options => ['--prerelease'],
  provider        => 'chocolatey',
  source          => 'INTERNAL REPO URL',

Requires Puppet Chocolatey Provider module. See docs at

4. 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 is exempt from moderation. While it is likely safe for you, there is more risk involved.

Invantive Studio

$ErrorActionPreference = 'Stop';

$packageName= 'invantive-studio'

$packageArgs = @{
  packageName = $packageName
  fileType = 'MSI'
  url = ''
  url64bit = ''
  softwareName = 'Invantive Studio'
  checksum = 'BF58DC6F01145CBE844456AABD7BCDECD1ADC8196C8CACA7F8C94CE789E12125'
  checksumType = 'sha256'
  checksum64 = 'BF58DC6F01145CBE844456AABD7BCDECD1ADC8196C8CACA7F8C94CE789E12125'
  checksumType64 = 'sha256'
  silentArgs = "/qn /norestart /l*v `"$env:Temp\invantive-studio-17.17.68-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.

Add to Builder Version Downloads Last Updated Status
Invantive Studio 22.1.48-BETA 19 Monday, May 16, 2022 Approved
Invantive Studio 22.1.47-BETA 18 Sunday, May 15, 2022 Approved
Invantive Studio 22.1.46-BETA 16 Sunday, May 15, 2022 Approved
Invantive Studio 22.1.40-BETA 16 Thursday, May 12, 2022 Approved
Invantive Studio 22.1.39-BETA 18 Tuesday, May 10, 2022 Approved
Invantive Studio 22.1.38-BETA 19 Monday, May 9, 2022 Approved
Invantive Studio 22.1.37-BETA 15 Sunday, May 8, 2022 Approved
Invantive Studio 22.1.36-BETA 19 Saturday, May 7, 2022 Approved
Invantive Studio 22.1.35-BETA 19 Wednesday, May 4, 2022 Approved
Invantive Studio 22.1.31-BETA 27 Monday, April 4, 2022 Approved

Included components:

  • Invantive.Producer.Windows 17.17.68-BETA

Version 17.17.68-BETA, released 2018-02-09:

  • DL: translations, run window.
  • DL: More actions implemented.

Version 17.17.66-BETA, released 2018-02-08:

  • DL: More actions. Improvements on the layout.

Version 17.17.65-BETA, released 2018-02-07:

  • Add 'local on error ignore' and exit with error on 'local on error continue' when an error occurs.

Version 17.17.64-BETA, released 2018-02-07:

  • Do not freeze parent window of Data Loader due to repairing parent window.

Version 17.17.60-BETA, released 2018-02-06:

  • DL: Opening and saving files.
  • DL: Icons, more logic.

Version 17.17.59-BETA, released 2018-02-05:

  • Correctly generate environment variable INVANTIVE_LOG_FILE_OVERWRITE value when set to false.

Version 17.17.57-BETA, released 2018-02-02:

  • Add missing picture to Invantive Data Loader.

Version 17.17.47-BETA, released 2018-01-30:

  • Fix Invantive Data Loader started from Excel.
  • Added Data Loader in QT menus.

Version 17.17.42-BETA, released 2018-01-28:

  • Add "local column xxx heading" syntax for GUI applications.
  • Reduce duration of audit events in configuration files from 100 to 7 days for better performance.
  • Improve performance of function license checks.

Version 17.17.38-BETA, released 2018-01-25:

  • Allow space in actions with local export documents statement.

Version 17.17.26-BETA, released 2018-01-12:

  • Raise no longer an error on export of empty data set.

Version 17.17.22-BETA, released 2018-01-10:

  • [ITGEN-2009] Support executing a file through @@ in Query Tool as in Data Hub. Also add support for it to Data Access Point.
  • DC: event log panel in QT.

Version 17.17.11-BETA, released 2018-01-05:

  • Added tabs for Data Replicator and table function parameters.
  • Added documentation panel to available objects overview.
  • Added documentation panel to available objects overview.

Version 17.17.9-BETA, released 2017-12-22:

  • Load license file from text mode configure license form.
  • Added more fields in table describe.
  • Added more fields in table describe.

Version 17.17.2-RC, released 2017-12-21:

  • Add requested fields.

Version 17.17.0-RC, released 2017-12-20:

  • Add statistics on my incoming messages for Data Replicator.
  • QT: Add general tab in describe windows when pressing F4 in the query editor.

Version 17.15.2-RC, released 2017-12-11:

  • Check that Windows Update has installed updates at most 180 days ago.
  • 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.
  • Extend export options by TSV format in menus and Invantive Script.

Version 17.14.0-RC, released 2017-12-08:

  • Enable user language to be set from windows products before logging on.

Version 17.13.8, released 2017-12-06:

  • Prevent errors in logon window on STA applications such as Query Tool.
  • Open documents from Exact Online and other sources in Invantive Composition.
  • Prevent crash when entering wrong user name or password on OAuth providers.
  • Open documents from Exact Online and other sources in Invantive Composition.
  • 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.
  • Allow deviating license contract code for authentication on Customer Service on behalf of Data Replicator.
  • Show error on multiple statement execution in the correct format.
  • Add translations to EZ-Base provider.
  • 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.
  • 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.
  • Added Accountancy endpoints to Exact Online provider.
  • Offer discovery in Data Hub when an unknown connection is specified.
  • Reduce length of call stack printed in console window for Data Hub
  • Reduce length of call stacks.
  • 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.
  • NullReferenceException on query when not adding alias to default/first provider. [ITGEN-1948]
  • Updated ExactOnline REST metadata.
  • itgenemd007: An element with the key 'P_ACCOUNT_CODE' already exists in the dicitonary. [ITGEN-1939]
  • Correct outcome of equals sign when selecting on code in accounts in EOL REST [ITGEN-104]
  • Slow or OutOfMemoryException on parameter pick lists. [ITGEN-1940]
  • Fix invalid parameter binding Invantive Studio on log on [ITGEN-1863]
  • 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].
  • Stability improvements to the SQL engine. Calculations with DateTime return the right data type now.
  • 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.
  • Remove temporary code that caused bulk insert on SQL Server to fail.
  • Enable group functions on Open Data and with premium license in Invantive Query Tool.
  • 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.
  • 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
  • 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]
  • Optimize memory usage when joining with an empty row in a left outer join.
  • 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.
  • Add unique entry ID to every XML element. [ITGEN-1898]
  • Ensure vital messages are sent to the customer service on a failing program.
  • 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.
  • Lower-case views for partition and overall storage in 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.
  • Removed ancient warnings [INTERAL]
  • Invantive SQL: Return correct return type for parameters.
  • Clarify error message itgenprr005 with actual string value.
  • Remove usings.
  • 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.
  • Avoid error on Invantive Web Service trying to rewrite connection string.
  • Improve suggestions for user names from password manager

Version 17.10.24, released 2017-10-11:

  • Add icons for VIES [internal] [ITGEN-1874].

Details of ReleaseNotes:

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 Studio Package

Ground Rules:

  • This discussion is only about Invantive Studio and the Invantive Studio 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 Studio, 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