Trace Id is missing

Maximise the everyday with Microsoft 365

Get online protection, secure cloud storage and innovative apps designed to fit your needs – all in one plan.
For 1 personFor up to 6 people
A young woman works on a Surface laptop while Microsoft 365 App icons whirl around her head.

Microsoft® OData Source for Microsoft SQL Server® 2012

Microsoft OData Source for SQL Server 2012 provides the capability of consuming OData services to SQL Server 2012 Integration Services (SSIS). Users can use it in an SSIS package to extract data from an OData service and then perform further ETL processing.

Important! Selecting a language below will dynamically change the complete page content to that language.

  • Version:

    11.0.5015.7

    Date Published:

    25/3/2014

    File Name:

    ODataSourceForSQLServer2012-amd64.msi

    ODataSourceForSQLServer2012-x86.msi

    File Size:

    2.3 MB

    2.1 MB

    The Open Data protocol (OData) lets you access a data source, such as a database, by browsing to a specially constructed URL. This allows for a simplified approach for connecting to and working with data sources that are hosted within an organization.

    There are many OData sources available in enterprise and in cloud:
    • SharePoint Foundation 2010
    • SharePoint Server 2010
    • SQL Azure
    • Windows Azure Table Storage
    • Windows Azure Marketplace
    • SQL Server Reporting Services
    • Microsoft Dynamics CRM 2011
    • Windows Live

    For a list of producers of OData services, see the Open Data Protocol website.

    Connecting to OData sources quickly without any coding is the primary design goal of OData Source for SQL Server 2012. The OData Source component enables SSIS packages to communicate with OData sources. Developers can add the component to an SSIS package and configure it to receive data from an OData source without writing any code.

  • Supported Operating Systems

    Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008 R2 SP1, Windows Server 2012 R2

    • SQL Server 2012 is required

  • Download and run the 32-bit/64-bit installation package to install OData Source for SQL Server 2012 on your computer.

    OData Source On-line Help

Follow Microsoft

Back To Top