Sample Batch File

Invantive Data Hub is typically started from a batch file, such as below. The contents below can be used to create your own batch file, but it is far more easy to create such a batch file from Invantive Query Tool as described in Batch File.

 

@echo off

rem

rem Script to run an Invantive SQL file with possible Invantive Script statements.

rem

rem Please note that the encrypted password is bound to the PC used to generate this file.

rem When you want to run this batch file on another PC, please generate a new encrypted password at that PC.

rem

rem In Invantive Query Tool and Data Hub you can use the 'local encrypt password' statement to generate.

rem a new password.

rem

 

set INVANTIVE_PRG=C:\Program Files (x86)\Invantive Software BV\Invantive Data Hub\Invantive.Producer.QueryEngine.exe

 

set INVANTIVE_USR=<<USERNAME>>

 

set INVANTIVE_ENCRYPTED_PWD=<<ENCRYPTED_PWD>>

 

set INVANTIVE_CONN=<<GROUP>>\<<NAME>>

 

set INVANTIVE_SQL_FILE=C:\temp\file.sql

 

set INVANTIVE_LOG_FILE=C:\temp\file.log

 

set INVANTIVE_INTERACTIVE=False

 

"%INVANTIVE_PRG%" /user:"%INVANTIVE_USR%" /connection:"%INVANTIVE_CONN%" /encryptedpassword:"%INVANTIVE_ENCRYPTED_PWD%" /file:"%INVANTIVE_SQL_FILE%" /logfile:"%INVANTIVE_LOG_FILE%" /logoverwrite:"%INVANTIVE_LOG_FILE_OVERWRITE%" /interactive:%INVANTIVE_INTERACTIVE%

 

pause