I agree,
Computing power today is, for all intents and purposes in companies, free.
You can buy a pretty decent Sun12k or 15K if you want the head room for USD1M.
And in most large companies that is a rounding error....
And computing power is going to be driven down further and further....
The cost today is in consulting services to get what will give you an advantage built....it is not even in software...open source is going to destroy the software license fee business proposition just as surely as Moores Law destroyed the business proposition of the hardware market...
One set of business winners will be the companies that leverage this 'almost free' resource to either deliver 'low cost provider' or 'customer relationship driven' businesses...
BI is going to become more and more important.....the information inside a company and the transactions with clients is going to become, more and more, the only resource that cannot be easily copied by a competitor...
I have been saying this for 12 years now....and the rate of technology 'copying' going on has me more firmly of the belief that no-one is going to make any money over the longer term by having the 'best widget'
because the widget will be copied......
Companies will make money by differentiated service levels to clients because most companies today offer terrible service...and those that offer low end/margin services/products will struggle against India/China....
Those that capture the hearts and minds of customers who stay with them 'no matter what' will make premium profits.....and all this will be done through usage of 'free computing' to manage dialogs with customers.
Peter
-----Original Message-----
From: SQLUSA via dw-select [
Sent: 24 September 2006 10:29
To: pete...
Subject: RE: RE:[dw-select] RE:ETL tools comparison analysis
>A decent 4 CPU 4GB large HDD RAID machine will set you back
>between USD20K and USD30K.
True Bluey, however, everything is relative in business. A misfit
employee can set you back USD100,000 a year easy, while a misfit PM can
cost you USD500,000 in failed DW/BI project attempt.
We live in the Golden Age of Computer Science. Computers are cheap. Get
all you can.
Kalman Toth
URL:
>From: Bluey9 via dw-select <dw-select@Groups.ITtoolbox.com>
>Sent: Sep 24, 2006 12:55 AM
>To: SQLUSA <technicalsqlusa@earthlink.net>
>Subject: RE: RE:[dw-select] Re: RE:Re: RE:ETL tools comparison analysis
>
>Have you factored in the cost of the MS Windows server to run SQL
Server
>2005 on? A decent 4 CPU 4GB large HDD RAID machine will set you back
>between USD20K and USD30K. True, if a business is implementing ETL
>seriously it will need a powerful machine but if the business runs unix
it
>won't bring in a MS Windows box just to run ETL.
>Bluey
>-----Original Message-----
>From: SQLUSA via dw-select [
>Sent: Friday, September 22, 2006 4:05 PM
>To: Bluey9
>Subject: Re: RE:[dw-select] Re: RE:Re: RE:ETL tools comparison analysis
>With all fairness to Microsoft,
>you can pick up SQL Server 2005 Enterprise for $20-30K.
>Can you tell me a SOLID ETL tool which costs less than that?
>Kalman Toth, Database, Data Warehouse & BI Architect
>URL:
>Intelligence 2005 Training in the World
>----- Original Message -----
>From: "Bluey9 via dw-select" <dw-select@Groups.ITtoolbox.com>
>To: "SQLUSA" <technicalsqlusa@earthlink.net>
>Sent: Friday, September 22, 2006 11:55 AM
>Subject: RE:[dw-select] Re: RE:Re: RE:ETL tools comparison analysis
>>
>> Yes and the steering wheel, engine, seats, floor, etc. are all free
too
>once you have paid for the car.
>> ---------------Original Message---------------
>> >> Is SSIS free? I went to the Microsoft website and found SSIS
>> >> pricing information almost impossible to find.
>> >
>> >Yes. SSIS, SSAS, SSRS all free.
>> >Kalman Toth, Database, Data Warehouse & BI Architect
>> >URL:
Business
>> >Intelligence 2005 Training in the World
>> >----- Original Message -----
>> >From: "Vincent McBurney via dw-select" email@removed
>> >To: "SQLUSA" email@removed
>> >Sent: Friday, September 22, 2006 12:51 AM
>> >Subject: RE:[dw-select] Re: RE:ETL tools comparison analysis
>> >>
>> >> pricing information almost impossible to find. I am guessing
>> >> you have to buy SQL Server licenses before you get SSIS. You
>> >> can use the Express version of SQL Server (which is free) but it
>> >> limits you to just 1 CPU and 1G of RAM. If you need an ETL tool
>> >> for such tiny volumes then you should be considering SSIS or an
>> >> open source ETL tool such as KETL.
>> >> SQL Server Workgroup edition ($3,899 per CPU) is limited to just
>> >> 2 CPUs and 3G of RAM, Standard Edition at $5,999 per CPU offers
>> >> 1-4 CPU support. That is more like the right sizing for a small
>> >> to medium sized project. Any serious data integration such as a
>> >> DW needs more then 4 CPUs so you are into Enterprise licensing
>> >> at $13,999 per CPU.
>> >> So $13,999 per CPU is not what I would call "free", plus you are
>> >> left with a bunch of SQL Server database licenses you don't
>> >> actually need, plus you are forced onto the Windows platforms.
>> >> How "free" is it if you have a 100 server grid where you have to
>> >> pay for Windows licenses instead of using Linux?
>> >> SSIS is free on small volume processing and becomes progressively
>> >> more expensive on larger volumes. Probably never reaching the
>> >> costs of DataStage or Informatica but then again never giving
>> >> you as much functionality as those tools either.
>> >> ---------------Original Message---------------
>> >> >> Most organisations do their own ETL tool evaluations because
>> >> they
>> >> >> are investing potentially millions of dollars on a major
>> >> data
>> >> >> integration venture and they want to see how the tools fit
>> >> in
>> >> >> their organisation structure and the available of skilled
>> >> >> resources to use the tools. They also want to make sure
>> >> >> are evaluating the latest software.
>> >> >
>> >> >So Vincent, how do you feel about Microsoft SSIS ?
>> >> >It is free!
>> >> >Kalman Toth, Database, Data Warehouse & BI Architect
>> >> >URL:
>> >> Business
>> >> >Intelligence 2005 Training in the World
>> >> >----- Original Message -----
>> >> >From: "Vincent McBurney via dw-select" email@removed
>> >> >To: "SQLUSA" email@removed
>> >> >Sent: Thursday, September 21, 2006 7:11 PM
>> >> >Subject: RE:[dw-select] ETL tools comparison analysis
>> >> >>
>> >> >> Most of the professionally produced ETL comparison documents
>> >> are
>> >> >> not publicly available as they are constrained by
>> >> non-disclosure
>> >> >> agreements from the software vendors who provide the
>> >> software
>> >> >> for evaluation and by privacy policies of the organisations
>> >> who
>> >> >> produce the comparison.
>> >> >> Most publicly available comparisons such as forum threads are
>> >> >> riddled with inaccuracy and baise and become less reliable
>> >> over
>> >> >> time.
>> >> >> regards
>> >> >> Vincent
>> >> >> ---------------Original Message---------------
>> >> >> >Dear,
>> >> >> >
>> >> >> >Although the topic already exists, unfortunately I didn't
>> >> get
>> >> >> any answers yet.
>> >> >> >By chance, does anyone has an accurate comparison analysis
>> >> of
>> >> >> ETL tools?
>> >> >> >For those interested, I also have relevant information.
>> >> >> >Cheers,
>> >> >> >Olivier from Belgium
>> >> >> >MSN : olivier[underscore]lambert[at]hotmail[.]com