OData is Microsoft’s open data protocol and is a key part of their hybrid, cross-platform, distributed computing strategy. As mentioned in a previous blog post, OData is everywhere including SharePoint, Excel and Azure.
Microsoft has just released its OData Source for SQL 2012 SSIS. Users can now use OData as a SSIS data source and then provide further ETL processing using the standard SSIS components.
This may be particularly attractive for those running SharePoint Online, Azure or Project Server in that these services provide readily consumable OData sources.