Level: Intermediate to Advanced

Steve Hughes

Business Intelligence Architect

Pragmatic Works

In 2012, Mark Souza from the SQL Server product team spoke at the Minnesota SQL Server User Group. During the Q&A I asked about interacting better with Oracle. Mark mentioned that OData would be the best way to handle this. I will be discussing what OData is and what tools are involved. I will also explore how to create an OData feed and how to interact with it using tools such as PowerPivot, SSIS, and SQL Azure. I will also examine the impact of OData for data professionals, both good, bad and ugly. In the end, you should understand how OData works and where it can help us expose our data appropriately to our users.

You will learn:

• How OData fits into the world of data
• How to use OData with SSIS
• How to use OData with Excel and PowerPivot