Release Notes of Invantive(R) Data Hub 20.0.152

Invantive(R) Data Hub

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 cloud applications such as Exact Online or Salesforce. It provides a headless mode which makes it ideal for use in server environments and scheduled uploads and downloads in lights-out operations.

Created: 03/06/2021 09:04:13 (UTC, deploy003)

Version: 20.0.152

State: Production

MSI Product ID: ac86d1c0-85ab-4839-8e40-1fb2a8079c82

MSI Version ID: ac86d1c0-85ab-4839-8e40-1fb200001400

MSI Product Name: Invantive Data Hub 20.0

Manufacturer: Invantive Software B.V.

Brand: Invantive

Category: Business

Download (URL): https://download.invantive.com/release/msi/Invantive%20Data%20Hub-20.0.152.msi

File size: 88 MB

Manual (URL): https://documentation.invantive.com/2017R2/invantive-data-hub/webhelp/index.html

Manual (PDF): https://documentation.invantive.com/2017R2/invantive-data-hub/Invantive%20Data%20Hub%20Manual.pdf

Memory Requirements: 1000 MB

Permissions:

Requires Internet access.
Requires all required Operating System updates applied at most 6 months ago.
Installation needs administrative privileges.

Software Requirements:

Microsoft .NET 4.7.2 or higher.
Microsoft Windows 10 (64-bit)
Microsoft Windows Server 2016 (64-bit), optionally with Terminal Services
Screen resolution 1280x1024 or higher.
User license for databases used and/or business applications.

Tags:

autotask
cbs.nl
console
documentcloud
dropbox
dynamicscrm
ecb
edifact
exact
exact-online
ExactOnline
facebook
freshdesk
ftp
gitlab
headless
jira
kadaster
keepass
linkedin
loket.nl
magento
mail
mendix
microsoftgraph
mt940
nasa
nmbrs
oauth
odata
openarch
openexchangerates
openspending.nl
paypal
postgresql
rdw.nl
rss
salesforce
schedule
severa
sftp
silveressence
slack
snelstart
sql
sqlserver
stackexchange
stackoverflow
swift
teamleader
teamviewer
twinfield
twitter
ubl
vies
virustotal
vismasevera
xaa
xaf
xas
yuki

Included Components:

Invantive.Producer.Windows 20.0.151

Version 20.0.142, released 2021-02-09.

Enhancements:
- Differentiate exit message code depending on exit code value.

Version 20.0.114, released 2020-11-06.

Enhancements:
- Memorize last action.

Version 20.0.108, released 2020-10-30.

Enhancements:
- Add option to close application on console menus.

Version 20.0.97, released 2020-10-05.

Bug fixes:
- Raise error when file being loaded in Data Hub Windows and .ent core does not exist and running in headless mode.

Version 20.0.96, released 2020-10-03.

Enhancements:
- Add local host statement.

Version 20.0.28, released 2020-05-20.

Bug fixes:
- Only print error context when present.
- Make unwrapped error codes in Data Hub less confusing

Version 20.0.25, released 2020-05-10.

Enhancements:
- On invalid email address on Data Hub offer correction before log on.

Version 20.0.21, released 2020-05-03.

Bug fixes:
- Fix NullReferenceException on 'use'.

Version 20.0.14, released 2020-04-20.

Enhancements:
- Indicate that encrypted value is a license key instead of the default 'password' text on decryption failure.
- Add Mac OSX support.
- Avoid NullReferenceException on Debian 8.
- Data Hub: Add license key command line argument.
- Print final error to console for console apps when the exit code is not equal to 0.
- Upgrade to Microsoft.net 4.7.2.
- Replace Mac version of Data Hub by .net core version.
- Add .NET Core version of Invantive Data Hub.
- Add verbose command line argument.
- Improve startup performance [ITGEN-451].

Bug fixes:
- Fix NullReferenceException when using 'use xx@alias' on Data Hub.
- Differentiate progress messages between SQL and PSQL.
- Improve clarity of message itgendhb086.
- Avoid superfluous question when last statement in batch fails in interactive mode.
- Fix exit code being reset from non-zero to 0 when a nested SQL script is executed after an error occurred during 'on error continue' mode.
- Log time in UTC.
- Return exit code also from files started from @ or @@.
- Fix NullReference when pressing CTRL-D on Mac during entry or CTRL-Z on MS-DOS.
- Correctly load license key from command line [ITGEN-4011].
- Avoid waiting for manual entry when the program is running non-interactive and early on a license error occurs.
- Fix System.Runtime not found exception [ITGEN-3857].
- Can't connect to SQL Server or PostgreSQL due to missing references [ITGEN-3767].
- Correct reversed logic of logoverwrite command line parameter [ITGEN-3540].

Version 17.28.1, released 2018-10-22.

Enhancements:
- Print log on progress when running headless.
- Improve clarity of error message itgendhb077.
- Set provider attributes and variables through command line.
- Memorize and use multiple credentials per data container alias.
- Enable use of logon settings.
- Set data container credentials.
- Save credentials new logon dialog.
- Add use of encrypted Invantive Script variable values [SECURITY].
- Add new log file name parameter Windows host name, user name and domain name.
- Update documentation.
- Explain command line arguments.
- Add support for date/time masks in log file name.
- Add @@ to load script from folder from which last script was loaded.

Bug fixes:
- Show actual error instead of NulLReferenceException when Invantive Web Services returns itgencmr008.
- Return exit code unequal to 0 when an error occurs in 'on error continue' mode.
- Reduce memory consumption [ITGEN-2582].

Details of Release Notes:

Version 20.0.28:
Make unwrapped error codes in Data Hub less confusing
# src/Invantive.Producer.Data.Hub/QueryEngine.cs
# src/Invantive.Producer.QueryEngine/QueryEngine.cs