New connectivity options in 2008

First published on MSDN on Mar 10, 2008

Update: 2008-08-13 - The connector pack will be available two to three months from the GA of SQL 2008

Update: 2008-10-02 - The Oracle and Teradata connectors are http://blogs.msdn.com/mattm/archive/2008/10/02/attunity-connectors-for-oracle-and-teradata-are-now-available.aspx

Update : 2008-11-26 - http://www.microsoft.com/downloads/details.aspx?FamilyID=228de03f-3b5a-428a-923f-58a033d316e1&DisplayLang=en

Darvey Lavender, group program manager for SSIS, has updated the http://ssis.wik.is/FAQ with some information about our new connectivity options in SQL Server 2008. The three new connectors (for Oracle, Teradata and SAP BW) will be available as a downloadable feature pack for Enterprise Edition customers two to three months from the general availablity of SQL 2008.

Here is some of the interesting info from the FAQs:

Attunity Oracle Connector

What Features Does The Connector Support?

The Attunity Oracle Connector supports the following functionality:

1. Bulk Load Destination using OCI Direct Path


2. Incremental Load Destination using OCI Array Binding


3. Bulk Extract Source using OCI Array Binding


4. Oracle Connection Manager

What Oracle Versions Are Supported?

The connector will support Oracle V9 or later.

Attunity Teradata Connector

What Features Does The Connector Support?

The Attunity Teradata Connector supports the following functionality:

1. Bulk Load Destination using TPT FastLoad


2. Incremental Load Destination using TPT TPUMP


3. Bulk Extract Source using TPT


4. Teradata Connection Manager

What Teradata Versions Are Supported?

The connector will support Teradata versions V2R4.11 and V2R5 or later V2R6.0, V2R6.1, V2R6.2 and 12.00.

SAP BI Connector

What Features Does The Connector Support?

The SAP BI Connector supports both source and destination connections for SAP BI.

What SAP BW Versions Are Supported?

The connector will support both 3.5 (with InfoSpokes) and BI 7.0 (with OHS Destinations).

Will The Connector Be Certified by SAP?

Yes, the current plans will be to have both the SAP BI source and destination features certified by SAP BI. The timing of the certification may not coincide with the initial release.

Update: 2008-04-17 - The SAP BI connector will support SAP BW 7.0, and not 3.5.

Update: 2008-07-09 - Updated Teradata version information.