Hi Dean,
do you seriously believe that Sunopsis will not move to CPU based licensin g now it is owner by Oracle?
Does anyone seriously believe it will continue to be developed and enhance d to write to databases other than Oracle? Just because Oracle said so in a letter recently?
If you do, I have a bridge I am selling... ;-)
And Oracle will now do it's usual schizo act with Sunopsis/OWB....
..for
those of us who are older we remember the 'Discover'/'Express' schizo
act.......;-)
Best Regards
Peter
Original Message:
-----------------
From: deankelly via dw-select dw-select@Groups.ITtoolbox.com
Date: Wed, 01 Nov 2006 00:29:10 GMT
To: peter@peternolan.com
Subject: RE:[dw-select] ETL vs. ELT ... what's out there?
You are right, there are some great performance advantages using ANY RDBMS (more so with parallel ones like Netezza, Teradata
etc..) to perform the Transformations.
In a nutshell and to assist your decision / evaluation, I know that you can request evaluation software from Sunopsis (go to their website, it's FOC) and this will allow you to test and validate the ELT approach with a FULL version of the product.
Sunopsis does NOT require dedicated HW, nor does it price by CPU, so it has a great TCO story when compared to the ETL players.
You will find there are 3 main benefits of this tool:
1) The inherent Performance advantage - It invokes the native RDBMS utilities with each RDBMS for great Extract and Loading; and then uses RDBMS SET processing for Transformations (versus row-by-row ETL engines... even if you buy their "parallel"
adapters!).
2) Productivity. Sunopsis requires you know SQL. Real simple!
You will have people in-house capable of both development and support of this environment. So NO proprietary language to learn. This means developers are productive very quickly.
>> There is some other really cool stuff under the hood which is
just magic! Its a declarative tool, so easy to design your solution!
3) TCO - it is NOT JUST about up front costs, there is also the TCO to think about. Sunopsis is NOT CPU licensed, therefore as your DW scales up, there are no additional charges for either source or target growth. It is also very competitive in upfront costs as there is no dedicated ETL server/storage requirement.
As a word of advice - there is a big difference between native ELT and "push-down" ELT.
Native ELT (Sunopsis for example), will allow you to create & delete temporary transform tables on the source / target WITHOUT the overhead of seperate DBA activity.
Push-down ELT appears to work only when the ELT does NOT require temp tables and reasonably basic transforms. >>Push-down ELT makes for good slideware though!
If your ELT jobs fall outside this requirement, then you will end up using the ELT engine to complete the T tasks, and incur the performance handicap (and any additional costs associated with sizing your server / Software license etc...)
hope this helps. get the eval software and see for yourself.
---------------Original Message---------------
>I have been a long time user of all of the major ETL tools and
am
>a big fan. I agree that SSIS is far better than DTS and is actually
>giving Informatica and others a run for their money ... but as data
>volumes grow and platforms like Netezza gain ground, the ETL concept
>... where you do the transforms in an engine ... become more of a
>bottleneck. I have been researching the ELT (Extract, Load, Transform)
>archtitecture and it appears to be a potential solution ... where you
>push the processing to the db engine to take advantage of the
>scalability of the db engine. Both Sunopsis and Informatica with its
>Push Down Optimization option appear to have a credible solution. Has
>anyone had hands on experience with these? Are their others?
>