The file hold the ION ETL application environment variables that are used each time the ION ETL session is opened.

These variables can be established through the desk top application or through the Windows Batch Script scheduled to run the jobs. The file is created when creating the repository and is specific to the ION ETL server. Some ION ETL servers can be shared for non-production environments.

The file that is used by the application is in the .kettle sub-directory set in your KETTLE_HOME system environment variables.

To find your KETTLE_HOME:

  1. Open the Control Panel.
  2. Click System.
  3. Click Advanced system settings.
  4. Click Environment Variables and search for the KETTLE_HOME variable.
  5. Go to the folder that is mentioned in the KETTLE_HOME variable and find the .kettle sub-directory.
  6. Open the file.
    These are the standard variables that are included in the and used in the Data Lake transformations and jobs:
    M3_DIVI= BETWEEN '' AND '999'
  7. Update the properties if required, setting the location of the Mail Configuration and ION API Files.

    See Service Authorized App (*.ionapi)

    If utilizing an older version of the ION ETL application, you are maybe using the query string in the Data Lake input step and are utilizing the DATALAKE_HOURS and DATALAKE_DAYS. You can configure the default values here.

    We recommend you to move from using these static values to the newer dynamic selection.

  8. Before setting up any transformations, add these additional variables to the file:

    These additional variables are used for the latest incremental process and set the staging (target) database variables.

    By setting the staging (target) database variables in the files, life cycle promotion to update the DB information is done in one location.

    Note: The DB_PW must be encrypted if the environment variable is utilized. Use the command prompt, navigate to the current version of the installation directory. Use the encryption utility: encr -kettle {password}
  9. Copy the whole line starting with “Encrypted” from the command prompt into the DB_PW variable.