I am just a beginner in SSIS and I like it, and somebody that has many years of experience in datawarehousing recommend me the software from this company, http://www.wherescape.com/, I just wanted to know if somebody has tried it, because I think its interface is poor and I dont think its better than SSIS, the only thing good I think, is that it can make datawarehouse in oracle and sql in the same tool.
If you can review it please advice me.
Hi Luis,
I am familiar with both products - we have just moved our data warehouse from using DTS on SQL 2000 to using WhereScape RED on SQL2005. We looked at and did not use SSIS. At a high level SSIS is an excellent general purpose tool for moving data around and sequencing tasks (much improved over DTS), but WhereScape RED is more focused on building and managing a data mart or data warehouse.
I agree the interface of WhereScape was not very good - this improved recently to more MS standard. But to build a data warehouse WhereScape RED generates tables and procedures at the same time - SSIS only caters to processing (table design is managed elsewhere) and applies no consistency to the packages. The processes that WhereScape RED generates follows a consistent approach, which makes management, extending and troubleshooting the dwh much easier. The lack of consistency in DTS or SSIS really hurts management of the data warehouse. In RED I can alter a table and regenerate the procedures associated with it, and regenerate the documentation automatically. Before RED I had to chase through DTS packages and tasks to find out what was affected before manually making these changes - and the documentation never seemed to catch up.
I hope this helps.
Simon
