WhereScape RED Archived Reviews (More than two years old)

Filter by:Reset all filters
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Daniel Sprague
Real User
Director Information Systems & Software Development at HealthRIGHT 360
May 31 2018

What is most valuable?

Documentation (both user and technical): With so many moving parts, it is hard to keep track of the gazillion databases, tables, columns, and sources. RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation (quickly indicating where and what objects derive from and where they are consumed downstream).

How has it helped my organization?

RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes. It also integrates new data sources that the business requires. While there is a learning curve, (just as there is with any software), once you get the hang… more»

What needs improvement?

Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment.
GaryM
Real User
Data Architect at World Vision
Dec 29 2017

What is most valuable?

Documentation has excellent potential as it provides the capability to generate data lineage and a complete set of rich documentation and output in multiple formats. The… more»

How has it helped my organization?

It did not pass usability, reliability, sustainability or performance tests so there was no potential benefit other than minor documentation advantages over the current… more»

What needs improvement?

In my opinion, the tool requires a much different architectural approach to be effective. It has fundamental architectural flaws that prevent it from being a practical… more»

What's my experience with pricing, setup cost, and licensing?

Factor in the price of specialized consulting who know this product. They're hard to find and expensive.

Which solution did I use previously and why did I switch?

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… more»

What other advice do I have?

The compelling selling point for this and similar tools as "datamart in a box" providers is that they are pre-built frameworks and documentation. The opportunity is that… more»

Which other solutions did I evaluate?

The existing traditional mainstream ETL tool and the previous one have been functioning without problems but the concept of a self-documenting tool that provides a common… more»
Find out what your peers are saying about WhereScape, Microsoft, Informatica and others in Data Integration Tools. Updated: May 2020.
419,360 professionals have used our research since 2012.
Vendor
BI Architect at a healthcare company with 5,001-10,000 employees
Jul 07 2017

What is most valuable?

Automated creation of documentation, quick time to market, ease of use, code standardization and support for Data Vault 2.0.

How has it helped my organization?

We can focus on the data itself (data quality, MDM, metrics) instead of spending time building code to move and transform the data. During the POC myself and one WS… more»

What needs improvement?

Since WS supports Data Vault 2.0, I would like to see automated support for hash keys on the appropriate Data Vault tables. WS does have a table trigger that can be… more»

What's my experience with pricing, setup cost, and licensing?

Because WS builds native SQL code you don't have to worry about vendor lock-in as with other solutions. If you decide to walk away from WS you still have a working data… more»

Which solution did I use previously and why did I switch?

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… more»

What other advice do I have?

No solution is perfect and I could probably find nits here and there, however, I find WhereScape RED to be exactly what I was looking for. Roughly 80% of a data analyst's… more»

Which other solutions did I evaluate?

I have used SSIS, Information Builders' Data Migrator and home grown SQL Server stored procedures. If I was to order these solutions in terms of ROI they would be: 1… more»
Real User
Business Intelligence Architect at a university with 1,001-5,000 employees
Jun 13 2017

What is most valuable?

Automation, Automation, Automation.... Automation of Data Warehouse Tasks - Traditional ETL tools are a one-size-fits-all solution. They can often be like a programming… more»

How has it helped my organization?

We are able to build data models much faster than previously and much faster than using a traditional ETL tool. It allows us to focus on the most important aspect of a… more»

What needs improvement?

As with any product, there are things that can be improved, but most are fairly minor, including things like greater flexibility in ordering job tasks. I’d also like to… more»

What's my experience with pricing, setup cost, and licensing?

The product is much less expensive than traditional ETL tools. Licensing is very simple to understand.

Which solution did I use previously and why did I switch?

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… more»

What other advice do I have?

As other reviewers have noted, data warehouse automation requires you to change your thinking and perspective somewhat. If you are looking at this product as a simple… more»

Which other solutions did I evaluate?

Yes, we looked at various traditional ETL packages as well as other Data Warehouse automation tools. We chose WhereScape over traditional ETL for reasons noted previously… more»
Consultant
Sr. Research Analyst - Data Management Practice Head at a tech consulting company with 51-200 employees
Dec 04 2016

What is most valuable?

* Good fit with agile development including requirements discovery and data discovery * Embedding of standards and design patterns into the tool yields substantial quality and consistency gains * Schema generation * Source-to-target mapping… more»

How has it helped my organization?

* Agility * Speed of deployment * Quick response to changes in requirements and changes in source data * Skilled people no longer burdened with repetitive low-value tasks

What needs improvement?

* Data discovery would be more powerful with machine learning features * Big data functions could include some of the features of the advanced self-service data preparation tools

Which solution did I use previously and why did I switch?

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… more»

What other advice do I have?

Don't confuse data warehouse automation with ETL automation. DWA automates the entire data warehousing life cycle. Change your approach (think agile), change your processes (think end-to-end ... source data to business impact), and change… more»

What is WhereScape RED?

WhereScape RED is data warehouse software to help build data warehouses faster. But it is more than that. It also helps you to build data warehouses that are easy to support, change and extend. It is an integrated development environment, or IDE, especially designed to build great data warehouses faster in SQL Server, Teradata, DB2 and Oracle.
WhereScape RED customers
Jersey Electricity, Man Group Plc, Learning Care Group, First Data, Hunter Douglas, The City of Shoreline, ASB
BUYER'S GUIDE
Download our free Data Integration Tools Report and find out what your peers are saying about WhereScape, Microsoft, Informatica, and more!