OData Source Properties
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
When you right-click OData Source in the data flow and click Properties, you see properties for the OData Source component in the Properties window.
Properties
| Property | Description |
|---|---|
| CollectionName | Name of the collection to retrieve from the OData service. The CollectionName property is used when UseResourcePath is False. This property is expressionable, which lets you set the value at runtime. However, if the metadata of the collection does not match the metadata that existed at design time, a validation error occurs, causing the data flow execution to fail. |
| DefaultStringLength | This value specifies default length for string columns that have no max length. Default: 4000 |
| Query | The OData query parameters. This property is expressionable and can be set at runtime. |
| ResourcePath | Use this property when you need to specify a full resource path, rather than selecting a collection name. This property is used when UseResourcePath is True. |
| UseResourcePath | When set to True, the ResourcePath value is appended to the base URL to determine the OData feed location. When set to False, the CollectionName value is used. Default: False |
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for