WhereScape RED Previous Solutions
SM
reviewer1618884
BI Analyst DW Architect at a mining and metals company with 10,001+ employees
Previously, we were completely on the Microsoft stack. This product gave us a bit more automation.
View full review »We previously had a traditional ETL tool, which was being sunset by the vendor.
View full review »GM
GaryM
Data Architect at World Vision
Currently use a traditional ETL tool that meets our requirements. The test scenario involved around 250 GB of source data with a resulting 50 GB (compressed) star schema target. The ETL tool can talk to all our sources including multiple cloud sources using SOAP and REST web services and this tool is just a database procedure generator with no adapter capability. It instead relies on ETL tools to do that work so it doesn't eliminate ETL tools ending up having to support not one tool but two tools - both in licensing, support and expertise which was expected to cause significant increase in total support costs.
View full review »Buyer's Guide
WhereScape RED
March 2024
Learn what your peers think about WhereScape RED. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
1. Information Builders iWay Data Migrator
2. SQL Server Integration Services
3. Hand coded SQL procedures
Data Migrator is just another ETL tool and the UI is not intuitive. Multi-threading is the only advantage Data Migrator has over SSIS and hand-coded procedures, however the cost isn't justified.
WhereScape RED handles the versioning, building of the objects (SSIS packages, SQL procedures, etc.) and provides an advanced, multi-threaded scheduler that makes it easy to manage object dependencies and objects that can be loaded in parallel.
A REALLY COOL feature is to create a track-back diagram from some destination object, e.g. FactSales. That opens a tab with a pretty diagram of the flow of data from the source system all the way through to the fact table. Tell RED to create a job from the diagram and *boom*, you have a schedule with all tasks and dependencies created to make sure that FactTable is loaded appropriately.
View full review »Previously, we did a great deal of MS SQL Server stored procedure and SSIS package development. We knew we did not want to manage the development of an enterprise class data warehouse and ETL codebase with handwritten procedures and SSIS packages.
View full review »PK
Paul Kellett
Software Engineer at KIS Ltd
I used SSIS - it struggles once the volumes increase substantially, has relatively poor error handling and misses many standard transforms. I was BI qualified with Microsoft.
Also used BO data services - not an expert but found job management to be exceedingly poor.
View full review »SB
reviewer1399308
Manager IT - Business Intelligence & Analytics at a manufacturing company with 10,001+ employees
We have used IBM InfoSphere DataStage and SSIS before.
View full review »JM
Jim Mihalick
Sr. Technical Consultant/Architect with 11-50 employees
- DataStage
- SSIS
Our purchase of WhereScape was part of a larger re-architecture of our data warehouse. We chose to move away from other products for a variety of reasons, but our choice of WhereScape was largely based on its ability to speed up the development process through automation.
View full review »No, this was a ground-up Data Warehouse build.
View full review »Reviewed several other solutions and chose WhereScape because:
(1) It is built by practitioners, for practitioners
(2) It is a "white box" solution. You can see (and even modify) everything that is generated. It doesn't lock you in like the "black box" proprietary products.
View full review »Buyer's Guide
WhereScape RED
March 2024
Learn what your peers think about WhereScape RED. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.