OData Source Properties

Applies to: yesSQL Server (all supported versions) yes 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 just 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

OData Source