WhereScape RED Reviews

• Metadata-based architecture
• Ability to prototype solutions quickly
• Automated documentation
• Great performance

The biggest win for my organization are the great improvements we have seen in load / refresh processing time over our legacy ETL tool. I was skeptical of the ELT architecture going into our Proof of Concept with WhereScape. I had believed that a more traditional ETL architecture of dedicated ETL servers and applications doing the transformations in memory, then writing to the database, would be faster. It turned out that the ELT approach of using the muscle of the RDBMS was significantly faster than our legacy ETL tool. We are now 2.5 years into using WhereScape and all warehouse code we have converted from our old tool to WhereScape has performed faster; anywhere from 20-80% reduction in processing time. This was huge for us, as increased demand for the warehouse and increased upstream operational system batch processing has really shrunk our batch window. We now have room in our batch window to add more content to the warehouse. In addition to improved performance, we no longer need dedicated ETL servers in our warehouse environment.

The documentation WhereScape provides has also been great. We have always struggled with maintaining documentation on our ETL. It is very nice to get source-to-target mappings, table diagrams, and dependency diagrams, which are up to date, with the click of a button.

Finally, the use of RED has resulted in a much more standardized, easier to support warehousing environment, from what we had prior.

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

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 resource were able to deliver a project in 3 days that had been in development by other resources for 6 months and still hadn't been delivered.

We were more productive from the moment we started using RED but that X-factor has only improved as we have become more comfortable with the toolset and as RED adds new features with each successive release.

Enterprise Data Warehouse and enterprise data staging.  Automation and documentation of all data warehousing processes.

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

We are a typical manufacturing company. We have around 65 to 70 manufacturing locations all over the world, and we hold down 60 different sources of data coming from ERP, CRM, and other applications kind of thing. We have eight different data source types, such as Oracle, SQL, et cetera. It really helps in terms of automation. We have a template and we have data type matching in place. It's even configured to be a drag and drop and helps you to segregate all the objects in types of projects and tools.

We were a division base for the department under the warehousing team, and have been moving to the centralizing and standardizing of some aspects, and combining all the individuals doing warehouses into one centralized enterprise-level warehousing team. The solution allows us to streamline users so that fewer people are needed to do the warehousing for the entire company.

Our primary use case is to extract data from multiple heterogeneous data sources, stage and transform data as the business requires, and load the results into our enterprise data warehouse.

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 of RED, it is a breeze. It enables us to focus on the business requirements at hand than the tool that we are using to solve the problem.

Producing data warehousing solutions quickly with this DW automation tool. You can generate DWs in many types of formats. We prefer Kimball architected data warehouses.

It has allowed us to produce consistently created, well-documented, easy to maintain DW solutions for our clients.

This is a fantastically, robust DW tool that will make you at least 10 times faster in producing a DW.

My primary use case is Data Warehouse & Mart Development plus data integration and content generation applications. We operate in many environments including Teradata, Oracle, & SQL Server.

Using this solution sped up development and allowed for easy maintenance.

Quickly develops a data warehouse for our organization with documentation and can track back/forward features.

Speed to market of a warehouse solution at a relatively inexpensive price point.  We used a consultant to get us started, but the tutorials offered by product were very helpful as well.