WhereScape RED Archived Reviews (More than two years old)
- Highest Rating
- Lowest Rating
- Review Length
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.
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.
Jul 07 2017
Automated documentation, quick time to market, ease of use, code standardization and support for Data Vault 2.0.
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»
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»
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 customersJersey Electricity, Man Group Plc, Learning Care Group, First Data, Hunter Douglas, The City of Shoreline, ASB