Integration Services

Organizations need to extract and transform data from a wide range of heterogeneous data sources.

Take advantage of a scalable enterprise data integration platform that can extract, transform, and load (ETL) data. SQL Server 2012 Integration Services (SSIS) enables you to transform ETL data from any data source type, whether from Microsoft or non-Microsoft sources, without having to do any coding.

What's New in SQL Server 2012

  • Ease-of-use enhancements to the designer to enhance productivity.
  • Improved deployment, configuration, reporting, troubleshooting and monitoring of ETL projects.
  • Launch ETL packages remotely.
  • Run SQL Server Integration Services on a separate SQL Server instance.
  • Change Data Capture for Oracle and SQL Server to efficiently manage frequent processing.

Key Capabilities

  • Access And Integrate With Any Heterogeneous Data Source

    Access data from any heterogeneous data source whether Microsoft or non-Microsoft sources or whether structured, application, cloud or real-time data.

    • Access data from any third party source including SQL Server, Oracle, Teradata, DB2, ODBC, OLE DB, text files, and the Microsoft Entity Framework.
    • Integrate data from business workflows in Microsoft BizTalk Server for SAP, ERP, CRM, Web Service, and mainframe applications.
    • Bring data from the cloud with Data Sync, ADO.NET connectivity to SQL Azure, and data from the Azure Marketplace data market.
    • Capture real-time data from sensors and other complex event streams by using Microsoft SQL Server StreamInsight technologies.
  • Manage Large Volumes Of Data At Scale

    Integration Services meets the enterprise customers’ requirements to move large amounts of data quickly. SQL Server Integration Services is depended on by more customers than any other ETL solution in the world.

    • Enjoy one of the fastest ETL tools on the market.
    • Gain increased performance of highly parallel package designs and improved thread pooling.
    • Mission critical fail-over support.
  • Streamlined In The Familiar Development Environment That Developers Already Know

    Integration Services in SQL Server 2012 is now integrated into the intuitive Visual Studio 2010 development studio allowing for shared user interface paradigm in a tool that developers already know.

    • Use a familiar and comprehensive development environment.
    • Easily install packages on a production system using a simple wizard.
    • Integrate Business Intelligence Development Studio with Analysis Services and Reporting Services.
    • Shared catalogs that store projects, packages, parameters, and environments for re-use.
    • Take advantage of integration with SQL Server Management Studio for simpler managing and monitoring of packages.

“Through SQL Server Integration Services and our custom development, we can transform a large volume of data that we receive at half-hour intervals every day and have it be available in a timely manner.”

James Salim
Senior Consultant for Solution Operations, Innovapost