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:
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.
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:
Supporting Oracle 188.8.131.52 and higher, the connector uses Oracle’s OCI client with its Array Binding and Direct Path APIs to deliver high speed data transfer:
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: