Helpful information and examples on how to use SQL Server Integration Services.
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:
What Features Does The Connector Support?
The Attunity Oracle Connector supports the following functionality:
What Oracle Versions Are Supported?
The connector will support Oracle V9 or later.
The Attunity Teradata Connector supports the following functionality:
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.
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.
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.
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,
The SAP BI adapters have been released! You can find them here:
I'll update the post with the new information!
i am excited like a child !!
i will let you know my experiences, ok?
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
Could SAP BI connector read SAP Table? Not SAP BI Table.
Please see this blog post for SAP R/3 guidance
Can u help me
how to use SAP BI connector in my project ?