Loading high volume Global Ledger business classes

Use the CSF Infor Data Lake Compass Driver shared connection in the CSF-Source-GL space to extract General Ledger Totals, Transactions, and Transaction Details. The delivered Compass scripts support data extraction in manageable chunks by applying a WHERE clause on business fields (example: Year/period).

By default, the lastModified field is used as a filter in the WHERE clause for standard incremental extractions.

To load a specific subset of data, define the required subset filter condition in the delivered variable and replace the existing WHERE clause with that variable. The variable’s WHERE condition will then be appended to the query at runtime.

Query WHERE clause variable
FSM_GeneralLedgerTotal_Compass FSM_GLTotal_Filter
FSM_GeneralLedgerTransaction_Compass FSM_GLTransaction_Filter
FSM_GeneralLedgerTransactionDetail_Compass FSM_GLTransactionDetail_Filter

These queries are aliased as A. Any of the properties of the Business Class are used to filter the extracted content.

For example:

  1. In Birst, select the [Tenant]_CSF-Source-GL space. Navigate to Modeler and select Connect.
  2. Open the CSF Infor Data Lake Compass Driver connection and select the FSM_GeneralLedgerTransaction_Compass query object
  3. Remove the existing where condition (example: Where lastModified >= 'V{ExtractStartDate_GeneralLedgerTransaction}') and replace it with V{FSM_GLTransaction_Filter}.
  4. Click Save.
    Note: After the workflow execution is complete, restore the query object condition to the original WHERE clause. This ensures that incremental data is retrieved when running the default workflow.