WhereScape RED Previous Solutions

SM
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 »
it_user584544 - PeerSpot reviewer
Manager Data Warehousing at a university with 10,001+ employees

We previously had a traditional ETL tool, which was being sunset by the vendor.

View full review »
GM
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.
it_user572313 - PeerSpot reviewer
BI Architect at a healthcare company with 5,001-10,000 employees

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 »
it_user586398 - PeerSpot reviewer
Senior Director, Software Development at a consultancy

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
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
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
Sr. Technical Consultant/Architect with 11-50 employees
it_user585969 - PeerSpot reviewer
Business Intelligence Architect at a university with 1,001-5,000 employees

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 »
it_user688914 - PeerSpot reviewer
Data Technology Analyst at a tech services company with 1,001-5,000 employees

No, this was a ground-up Data Warehouse build.

View full review »
it_user364260 - PeerSpot reviewer
Sr. Research Analyst - Data Management Practice Head at a tech consulting company with 51-200 employees

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.