Skip to main content

Celonis Product Documentation

Data Pool Parameters

During installation of the Connector, you are 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 starting month of the fiscal year for your business in integer format. For example, if the fiscal year starts in January, enter a 1, if the fiscal year starts in April, enter a 4, etc.

  • fiscalYears = The minimum number of fiscal years 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 two full years of data can be brought into the data pool. This value must be entered in integer format.

  • 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