Welcome to MSDN Blogs Sign in | Join | Help

New connectivity options in 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 now available

Update: 2008-11-26 - The SAP BI connections are available

Darvey Lavender, group program manager for SSIS, has updated the connectivity wiki 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.

Published Monday, March 10, 2008 4:52 PM by mmasson
Filed under:

Comments

# SSIS: Connecting to Oracle just got a whole lot better

There was some great news this week for SSIS developers that are building solutions involving databases

Friday, March 14, 2008 4:29 PM by SSIS Junkie

# New docs on SAP with SQL Server Integration Services

Integration Services developer Matt Masson has already blogged about the new SAP connectivity components

Thursday, June 12, 2008 12:36 PM by Douglas Laudenschlager

# SSIS and SAP

Douglas already beat me to it , but I figured it was important enough to repeat incase you missed it

Sunday, June 29, 2008 9:40 PM by SSIS Stuff

# SQL Server 2008 Feature Pack and Integration Services

Bloggers (like my pal Buck Woody on his Carpe Datum blog ) are mentioning the SQL Server 2008 Feature

Wednesday, July 02, 2008 5:33 PM by Douglas Laudenschlager

# re: New connectivity options in 2008

Is there anything new on the Teradata connectivity with the release of SQL Server 2008 RTM?  The FAQ on the wiki says available shortly after the RTM release, but on MS download page "Microsoft SQL Server 2008 Feature Pack, August 2008", it does not show anything for this.

Tuesday, August 12, 2008 9:29 PM by ssteckley

# re: New connectivity options in 2008

Rumour has it the connector pack will be available two to three months after general availability of SQL 2008. I'll update the blog post to reflect this.

Thanks!

Wednesday, August 13, 2008 11:57 AM by mmasson

# re: New connectivity options in 2008

hi all,

we are in the middle o f a big project to integrate SAP BI as middleware between our SAP ERP and our Microsoft DWH. So i am very interessted to know mr about SSIS and SAP.... when the connectors will be avaible? any news about this?

greetz from germany,

Dietmar

Wednesday, November 26, 2008 4:39 AM by hoffmadi

# re: New connectivity options in 2008

Hello Dietmar,

The SAP BI adapters have been released! You can find them here:

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

I'll update the post with the new information!

Wednesday, November 26, 2008 11:39 AM by mmasson

# re: New connectivity options in 2008

i am excited like a child !!

i will let you know my experiences, ok?

greetz from germany,

dietmar

Thursday, November 27, 2008 3:08 AM by hoffmadi

# re: New connectivity options in 2008

i forgot: do you know if there is any documentation?

Thursday, November 27, 2008 3:17 AM by hoffmadi

# re: New connectivity options in 2008

The whitepaper for the SAP BI connector has been published:

Using SQL Server 2008 Integration Services with SAP BI 7.0

http://msdn.microsoft.com/en-us/library/dd299430.aspx

Thursday, December 04, 2008 1:36 PM by chunhui zhu
Anonymous comments are disabled
 
Page view tracker