Navigation Properties
In CData ODBC Driver for SAP SuccessFactors, a navigation property is a property on an entity that is itself either a single entity or list of entities.
A single-entity navigation property signifies a one-to-one relationship. For example, SAP SuccessFactors has the entity JobApplication which contains an Education navigation property, which references a single JobApplicationSnapshot_Education entity.
An entity-set navigation property signifies a one-to-many relationship. For example, in SAP SuccessFactors, the JobApplication has a Languages navigation property which can reference many JobApplicationSnapshot_Languages objects.
Working with Navigation Properties Relationally
Navigation properties in SAP SuccessFactors link related entities. Similarly, in a relational database, a foreign key serves to link tables. For example, the JobApplicationSnapshot_Language record contains the applicationId column, which uniquely identifies what JobApplication the JobApplicationSnapshot_Language belongs to.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.
Select
SELECT can be used to retrieve related entities that do not exist by themselves, such as the emailTypeNav entity on PerEmail. For more information on querying navigation properties, see Views.