New connectivity options in 2008

New connectivity options in 2008

  • Comments 14

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.

Leave a Comment
  • Please add 3 and 2 and type the answer here:
  • Post
  • There was some great news this week for SSIS developers that are building solutions involving databases

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

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

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

  • 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.

  • 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!

  • 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

  • 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!

  • i am excited like a child !!

    i will let you know my experiences, ok?

    greetz from germany,

    dietmar

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

  • 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

  • Could SAP BI connector read SAP Table? Not SAP BI Table.

  • Please see this blog post for SAP R/3 guidance

    dougbert.com/.../sap-and-sql-server-integration-services.aspx

  • Can u help me

    how to use SAP BI connector in my project ?

Page 1 of 1 (14 items)