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 = target currency of the data pool (see the Currency Conversion Tables for more information)

  • exchangeRateType = 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. Ie. 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 is integer.

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

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