Determines whether the provider automatically adds filters associated with effective dating, to tables that support effective dates.

Data Type

bool

Default Value

false

Remarks

Effective dating is a mechanism that enables entities to have an effective start date and an effective end date. A record thus becomes effective between its start date and its end date. In CData SSIS Components for SAP SuccessFactors, effective dating means that information records are stored with associated dates (start and end date), enabling the system to manage historical, current, and future data accurately.

Note: The fromDate, toDate, and asOfDate query parameters are not exposed in the navigation properties by default. However, they can be made available in either of two ways:

• Set UseEffectiveDate to True, or
• Set IncludeNavigationParentColumns to True.

When UseEffectiveDate is set to True, the CData SSIS Components for SAP SuccessFactors automatically appends the [FromDate='1900-01-01'] and [ToDate='9999-12-31'] filters to the tables that support effective dating. This behavior can be overridden by explicitly defining fromDate, toDate, or asOfDate in the SQL query's WHERE clause.