• 1
  • 2
  • 3
Invantive(R) Data Hub 22.1.40-BETA

This is a prerelease version of Invantive(R) Data Hub.

  • 1
  • 2
  • 3

Some Checks Are Exempted or Have Failed

Not All Tests Have Passed


Validation Testing Passed


Verification Testing Exemption:

Requires dotnet4.7 and a reboot

Details

Scan Testing Resulted in Flagged as a Note:

At least one file within this package has greater than 0 detections, but less than 5

Details
Learn More

Deployment Method: Individual Install, Upgrade, & Uninstall

To install Invantive(R) Data Hub, run the following command from the command line or from PowerShell:

>

To upgrade Invantive(R) Data Hub, run the following command from the command line or from PowerShell:

>

To uninstall Invantive(R) Data Hub, 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 https://community.chocolatey.org/api/v2/)


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 https://community.chocolatey.org/api/v2/. 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-data-hub -y --source="'INTERNAL REPO URL'" --version="'22.1.40-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-data-hub -y --source="'INTERNAL REPO URL'" --version="'22.1.40-BETA'" --prerelease
$exitCode = $LASTEXITCODE

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

Exit $exitCode

- name: Install invantive-data-hub
  win_chocolatey:
    name: invantive-data-hub
    version: '22.1.40-BETA'
    source: INTERNAL REPO URL
    state: present
    allow_prerelease: yes

See docs at https://docs.ansible.com/ansible/latest/modules/win_chocolatey_module.html.


chocolatey_package 'invantive-data-hub' do
  action    :install
  source   'INTERNAL REPO URL'
  version  '22.1.40-BETA'
  options  '--prerelease'
end

See docs at https://docs.chef.io/resource_chocolatey_package.html.


cChocoPackageInstaller invantive-data-hub
{
    Name        = "invantive-data-hub"
    Version     = "22.1.40-BETA"
    Source      = "INTERNAL REPO URL"
    chocoParams = "--prerelease"
}

Requires cChoco DSC Resource. See docs at https://github.com/chocolatey/cChoco.


package { 'invantive-data-hub':
  ensure          => '22.1.40-BETA',
  install_options => ['--prerelease'],
  provider        => 'chocolatey',
  source          => 'INTERNAL REPO URL',
}

Requires Puppet Chocolatey Provider module. See docs at https://forge.puppet.com/puppetlabs/chocolatey.


4. If applicable - Chocolatey configuration/installation

See infrastructure management matrix for Chocolatey configuration elements and examples.

This package was approved as a trusted package on 12 May 2022.

Description

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. Invantive Data Hub is also an ideal execution environment for large data replication jobs using Invantive Data Replicator.


tools\chocolateyinstall.ps1
$ErrorActionPreference = 'Stop';

$packageName= 'invantive-data-hub'

$packageArgs = @{
  packageName = $packageName
  fileType = 'MSI'
  url = 'https://download.invantive.com/release/msi/Invantive%20Data%20Hub-22.1.40-BETA.msi'
  url64bit = 'https://download.invantive.com/release/msi/Invantive%20Data%20Hub-22.1.40-BETA.msi'
  softwareName = 'Invantive Data Hub'
  checksum = '702864E848F2AF56E41A6A3D3C9EE7DF1722166EBE2F1E4EAD0C4413024F8D37'
  checksumType = 'sha256'
  checksum64 = '702864E848F2AF56E41A6A3D3C9EE7DF1722166EBE2F1E4EAD0C4413024F8D37'
  checksumType64 = 'sha256'
  silentArgs = "/qn /norestart /l*v `"$env:Temp\invantive-data-hub-22.1.40-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(R) Data Hub 22.1.48-BETA 11 Monday, May 16, 2022 Approved
Invantive(R) Data Hub 22.1.47-BETA 9 Sunday, May 15, 2022 Approved
Invantive(R) Data Hub 22.1.46-BETA 11 Sunday, May 15, 2022 Approved
Invantive(R) Data Hub 22.1.40-BETA 9 Thursday, May 12, 2022 Approved
Invantive(R) Data Hub 22.1.39-BETA 11 Tuesday, May 10, 2022 Approved
Invantive(R) Data Hub 22.1.38-BETA 11 Monday, May 9, 2022 Approved
Invantive(R) Data Hub 22.1.37-BETA 11 Sunday, May 8, 2022 Approved
Invantive(R) Data Hub 22.1.36-BETA 10 Saturday, May 7, 2022 Approved
Invantive(R) Data Hub 22.1.35-BETA 10 Wednesday, May 4, 2022 Approved
Invantive(R) Data Hub 22.1.29-BETA 14 Sunday, April 3, 2022 Approved

Included components:

  • Invantive.Producer.Windows 22.1.40-BETA

Version 22.1.30-BETA, released 2022-03-22.

Enhancements:

  • Improve user interface language defaulting.

Version 20.2.196, released 2021-10-26.

Enhancements:

  • Change execution log and native call logging to NDJSON format.
  • Give hint on running Data Hub interactive on itgenlic251.
  • Prefix output with optional timestamp.
  • Separate prefix and SQL statement when SQL statement has line feeds.
  • Upgrade to .NET 6.

Version 20.1.528-BETA, released 2020-10-03.

Enhancements:

  • Add "local host" Invantive Script statement.
  • Add "local on error default" to Invantive Script.
  • Add log file and trace file name path to Data Hub end-user failure reports.
  • Add option to close application on console menus.
  • Add printing of dbms_output.
  • Generate more unique message codes.
  • Improve DBMS output on Query Tool.
  • Include dbms_output also in Data Hub log files.
  • Make locker readonly.
  • Memorize last action.
  • On invalid email address on Data Hub offer correction before log on.
  • Register date/time of occurrence of dbms_output.
  • Save refresh token in Invantive KeyChain.
  • Show error itgendhb232 when the log file name/path is empty.

Bug fixes:

  • Enable again 64-bit mode on Data Hub.
  • Fix NullReferenceException on 'use'.
  • Fix NullReferenceException when using 'use [email protected]' on Data Hub.
  • Fix Producer repository log on using managed Oracle driver.
  • Make unwrapped error codes in Data Hub less confusing.
  • Only print error context when present.
  • Raise error when file being loaded in Data Hub Windows and .ent core does not exist and running in headless mode.
  • Switch back to 64-bit to increase maximum addressable memory.

Version 17.33.322-BETA, released 2019-06-16.

Enhancements:

  • Add Mac OSX support.
  • Indicate that encrypted value is a license key instead of the default 'password' text on decryption failure.

Bug fixes:

  • Avoid superfluous question when last statement in batch fails in interactive mode.
  • Differentiate progress messages between SQL and PSQL.
  • 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.
  • Fix NullReference when pressing CTRL-D on Mac during entry or CTRL-Z on MS-DOS.
  • Improve clarity of message itgendhb086.
  • Log time in UTC.
  • Return exit code also from files started from @ or @@.

Version 17.31.84-BETA, released 2019-01-15.

Enhancements:

  • Add .NET Core version of Invantive Data Hub.
  • 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.
  • Replace Mac version of Data Hub by .net core version.
  • Upgrade to Microsoft.net 4.7.2.

Bug fixes:

  • Avoid waiting for manual entry when the program is running non-interactive and early on a license error occurs.
  • Can't connect to SQL Server or PostgreSQL due to missing references [ITGEN-3767].
  • Correctly load license key from command line [ITGEN-4011].
  • Fix System.Runtime not found exception [ITGEN-3857].

Version 17.29.51-BETA, released 2018-12-29.

Enhancements:

  • Add verbose command line argument.
  • Improve startup performance [ITGEN-451].

Bug fixes:

  • Correct reversed logic of logoverwrite command line parameter [ITGEN-3540].

Version 17.28.1, released 2018-10-22.

Bug fixes:

  • Show actual error instead of NulLReferenceException when Invantive Web Services returns itgencmr008.

Version 17.23.43-BETA, released 2018-04-18.

Enhancements:

  • Add use of encrypted Invantive Script variable values [SECURITY].
  • Enable use of logon settings.
  • Improve clarity of error message itgendhb077.
  • Memorize and use multiple credentials per data container alias.
  • Print log on progress when running headless.
  • Save credentials new logon dialog.
  • Set data container credentials.
  • Set provider attributes and variables through command line.

Bug fixes:

  • Reduce memory consumption [ITGEN-2582].
  • Return exit code unequal to 0 when an error occurs in 'on error continue' mode.

Version 17.14.18-BETA, released 2018-03-23.

Enhancements:

  • Add new log file name parameter Windows host name, user name and domain name.
  • Add support for date/time masks in log file name.
  • Explain command line arguments.
  • Update documentation.

Version 17.11.0-RC, released 2017-11-04.

Enhancements:

  • Add @@ to load script from folder from which last script was loaded.

Discussion for the Invantive(R) Data Hub Package

Ground Rules:

  • This discussion is only about Invantive(R) Data Hub and the Invantive(R) Data Hub 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(R) Data Hub, 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