Alternative kettle.properties setup for shared environments

If you are sharing an ETL Client for non-production environments you must use this method in adding repository-based kettle.properties files to the .kettle directory.

Any variables that are shared by both non-production environments must be configured in the main kettle.properties file. For example, DATALAKE_DEFAULT_STARTDATE or MAIL_CONFIG_FILE that are created during the repository generation process. You can find the kettle.properties file in this folder: X:\Infor\IONETL\.kettle\kettle.properties

All other variables that are specific to the environment, must be added to the {environment}_kettle.properties file. Where {environment} is the name of the repository that is created.

If the {environment} variables are set, then they are always used over the main kettle.properties.

  1. Copy the kettle.properties file and rename it to {environment}_kettle.properties.
    For example: tst_kettle.properties
  2. Remove all variables except for those variables used for the environment. They probably include the IONAPI_FILE and the DB_ variables for the staging/target database.
    This file was created to handle tenant based environment variables
    #
    # 
    # Note: lines with a # in front are comments
    
    IONAPI_FILE=C:/Infor/IONETL/Admin/IONETL_TST.ionapi
    
    DB_HOST={hostname}
    DB_TARGET_NAME={target db name}
    DB_INSTANCE={instance}
    DB_PORT={port}
    DB_USER={user}
    DB_PW={encrypted db password}