What is OData source in SSIs?

What is an OData source?

OData is an open data access protocol to provide access to a data source on a website. It was initially defined by Microsoft. It is used for example in Azure and in SharePoint, but also by other companies like SAP and eBay.

How do I find OData source in SSIS?

A simple SSIS package1Open Visual Studio.2Create a new Integration Service Project.3Save the new project into the desired folder.4Drag a dataflow task to the working surface.5Double click "Data Flow" to bring up the new "Data Flow" work surface.6Select "OData Source" and drag to the work surface.SmartSimple OData Feed to SQL Server Database - SmartWiki

What is OData SQL Server?

OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. OData offers full CRUD support with a standard convention for field selection, sorting, filtering, and other SQL functions via HTTP GET, POST, PUT, PATCH and DELETE requests.

What is OData Connection Manager?

An OData Source component uses an OData connection manager to connect to an OData data source and consume data from the service.