Microsoft Connectors by Attunity

Attunity's high speed connectors for Oracle and Teradata have been selected by Microsoft to be included with SQL Server 2008 Integration Services (SSIS). Included with SQL 2008 Enterprise Edition, these high speed connectors created by 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 Attunity

Supporting Oracle 9.2.0.4 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 Oracle by Attunity
 


Microsoft Connector for Teradata by 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:

Microsoft Connector for Teradata by Attunity