Navigating relationships with OData Version 2
- Last Updated: March 6, 2025
- 1 minute read
- Hybrid Data Pipeline
- Version 4.6
- Documentation
Most data source types supported by Hybrid Data Pipeline use relationships to define associations
between tables or objects. In a relational data source, foreign key columns reference
the primary key column of the related table. When you configure a schema map for a data
source that contains relationships, Hybrid Data Pipeline maps
them as OData relationships. The OData model (returned via $metadata) identifies these
as Navigation Properties. OData provides the following ways to access related entities:
Hybrid Data Pipeline supports all three ways of navigating relationships. The topics in this section use an example of customers and orders with the following model:
Customer ---> Order ---> OrderItem
|
---> Contact