Welcome to EMC Consulting Blogs Sign in | Join | Help

SSIS Junkie

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 other than SQL Server; Microsoft will, later this year, be releasing new connectors for Oracle, Teradata and SAP BW. Check out Darvey Lavender's announcement on the SSIS connectivity wiki or read Matt Masson's blog entry for more details. I should point out that you will need Enterprise Edition of SSIS in order to use them and I also don't know whether the connectors will work on SQL Server 2005 or whether they will solely be for SQL Server 2008. Hopefully by the time you read this someone in the know will have left a comment here filling in the gaps.

For Oracle you now get the following:

  • Oracle connection manager
  • Bulk load destination

This signals a marked change in policy from Microsoft. Precisely three years and one day ago Darvey's predecessor Donald Farmer posted a blog entry entitled Oracle and SQL Server Integration Services where he stated:

I do not expect that Microsoft will write an Oracle fast loader - currently it comes in around number 999 in my list of 1000 features for next version, just slightly ahead of recompiling for Linux.

Clearly this feature got raised up the priority list. I wonder if this was Darvey's influence that led to this change in direction? Or perhaps the european commission's?

 

For those who either can't wait until the connectors are released or can't afford enterprise edition there are still options available to you. Rather than repeat myself you should head to my previous blog entry Persistent Oracle Connector.

-Jamie

P.S. For more information about Oracle and SSIS go here: http://blogs.conchango.com/jamiethomson/archive/tags/Oracle/SSIS/default.aspx

Published Friday, March 14, 2008 7:41 PM by jamie.thomson

Comments

 

Donald Farmer said:

Nice post, Jamie. Three years and a day, eh? How time flies when you're having fun!

I guess I was actually right - Microsoft didn't write an Oracle fast loader - we used the partner ecosystem as I said we would. But you're right too - priorities have indeed changed, for good reasons, and everybody wins. An even closer partnership between MS and connectivity partners is a great thing for our customers.

One of the most exciting things we have seen in the SSIS space in the last 3 years is the success of the application as an integration tool in enterprises that are not heavily SQL Server centred, or even heavily built on the MS platform.

The reach of SSIS beyond the MS platform is great to see - and very much due to the efforts of Darvey's team on the one hand, and the support of our community of users - like yourself and other MVPs - who boldly go where SSIS has not gone before. You're the stars here - and you should not underestimate your inference.

See you at the MVP summit! And keep junking on SSIS!

Donald

March 15, 2008 5:42 PM
 

P R W said:

I was fortunate enough to be involved in a conference call with Darvey recently regarding SSIS.

He explained that the provider named TPT – TD Parallel Transport is a high perf connection provider for SSIS and is completely different from that described for RS and RB (report builder). It can’t be used for SSIS 2005, only 2008 and will be a separate download.

This is great news for us because we extract a lot of data from our TD DW, and currently have to use a staging file process. This means we could investigate the possibility of a direct insert if that meets requirements.

March 17, 2008 10:45 AM
 

eraser’s blog » Blog Archive » SSIS: Connecting to Oracle just got a whole lot better said:

April 13, 2008 12:41 PM
 

SSIS Junkie said:

Attunity, the company that makes Microsoft’s SSIS connectors for Oracle and Teradata (read more about

February 12, 2009 7:23 PM
New Comments to this post are disabled

This Blog

Syndication

Powered by Community Server (Personal Edition), by Telligent Systems