Microsoft Connectors by Qlik (Attunity)

Qlik (Attunity) high speed connectors for Oracle and Teradata have been selected by Microsoft to be included with SQL Server Integration Services (SSIS). These high speed connectors created by Qlik (Attunity) provide:

  • Optimized, best-in-class performance

The connectors deliver unparalleled throughput for extracting and loading data to and from Oracle and Teradata. Architected with Microsoft, the connectors use direct integration into internal SSIS buffering APIs, cutting through .NET and other layers, and also use the high speed load/extract utilities offered by Oracle and Teradata.

  • Ease-of-use

The connectors are fully integrated into the Business Intelligence Development Studio (BIDS), part of Microsoft Visual Studio 2008, offering a user experience similar to that of the SSIS generic OLEDB Connector, with intuitive capabilities including configuration, metadata browsing, and error routing.

The following diagrams provide an overview of the connectors’ architecture:

Microsoft Connector for Oracle by Qlik (Attunity)

Supporting Oracle and higher, the connector uses Oracle’s OCI client with its Array Binding and Direct Path APIs to deliver high speed data transfer:

Microsoft Connector for Teradata by Qlik (Attunity)

Supporting Teradata 6.0 and higher, the connector uses Teradata TPT 12 with its Load, Stream, and Export utilities to deliver high speed data transfer: