Saturday, April 28
Sybase late to the party
Pretty much every vendor has a tool to move information into a data warehouse - an ETL (extract, transform, load) tool. More recently with Oracle and Sunopsis, they have a competing offering with E-L-T tools. And some vendors offer ETLT, like Microsoft's SSIS.
So isn't Sybase late to this party by announcing they are adding to their suite an ETL tool? Unfortunately it does look similar to Oracle's approach of an embedded ETL tool within their database. I'm sure there are technical differences and I'm sure some would say the Sybase IQ ETL tool is separate from and can be used independantly from their Sybase ASE database.
But what's the point?!?
The question if I were a company or IT department looking for ETL is, "if I don't have the Sybase database, why would I look at Sybase ETL tools?" Oracle has a similar problem. I have never heard of Oracle's ETL tools (or any Oracle BI tools) being used with anything but Oracle databases.
It's one of the major drawbacks of having an integrated database with BI/DW tools. Yes, there are advantages to being tightly coupled but aren't they just technical. Are there "true" advantages for companies having an all Oracle or Sybase or Microsoft shop?
Their mantra: the synergy of our single vendor offering is in the overall value, where the value is more than the sum of the pieces (one plus one is three).
But what about doing a 'mix and match' by taking the best tools from the best vendors? Our society wants choice, your company should also have choice. Choosing the tools that meet your company's critieria, such as price, functionality, and ease of use, would reduce your risks of relying on one vendor.
The moral: Purchase tools based on your specific meaningful criteria and don't be caught up with the 'we have that tool as well' sales game.
At least having a choice will ensure you get what you asked for. And you never know, that may be from one vendor afterall.