Skip to main content

Celonis Product Documentation

Data Pool Parameters

On Installation of the Connector, it is required to set up the necessary data pool parameters. These include, but are not limited to:

  • currency = the target currency of the data pool (see the Currency Conversion Tables for more information).

  • exchangeRateType = The exchange rate type for the currency conversion (see the Currency Conversion Tables for more information).

  • fiscalYearStartMonth = The start month of the fiscal year for your business as an integer. For example, if the fiscal year starts in January, enter a 1. If the fiscal year starts in April, enter a 4.

  • fiscalYears = The minimum fiscal year to be extracted (important for the stock history table creation). This and all following years will be extracted. Usually it is far enough back that at least 2 full years of data can be brought into the data pool. The format for this value is integer.

  • primaryLanguageKey = The primary language to use the data fields in, such as the material names and activity names.

  • startDate = First day of the extracted data in the format of a timestamp.

  • stockHistoryYears = The number of full years of stock history that should be shown in the STOCK_HISTORY table. A value of 2 would result in 2 full years of stock history, plus the current month.

    For example, if the current date is 10th January 2021, and this parameter is set to 2, the STOCK_HISTORY table would show data from 01st January 2019 until the 10th of January 2021. In other words, 2 full years of data plus the current month.

  • targetQtyUnit = The quantity unit all non-SI unit quantities will be converted into during the transformations.

    For example, placing "ST" (without the " ") would allow for PAL (pallets) and PAK (Packets) to be converted into ST (pieces). SI units are handled differently and are not impacted by this parameter. Grams will still be converted into KG, irregardless of this parameter. The default value is set as ST (pieces), but could also be 'EA' (Each, which also equals ST).