WhereScape RED Reviews & Product Details

Ease of use creating data pipelines from traditional database sources. UI is easy to understand, anyone with SQL skills could learn how to use. Documentation of how data flows is great. Like that Wherescape takes care of primary/foreign key generation, and indexing. Customer support is quick to respond on any support tickets. Review collected by and hosted on G2.com.

Not the best product at creating pipelines/integrations from API sources. We don't currently rely on Wherescape RED to pull data from REST APIs, but will start playing around with RED's host script extensibility. It does, however, require some additional configuration/customization, and is not an "out of the box" feature. Review collected by and hosted on G2.com.

WhereScape RED does well in scenarios where implemented in a Raw Data Vault construct.

It does very well where scripts and structures are repeatable. I use the tool daily as part of my job function. Using the pebble templates was a steep learning curve, but once I figured that out the implementation and integration aspects became simple. When coupled with 3D it functions extremely well. Review collected by and hosted on G2.com.

Red does not perform well for Business Data Vaults though, where lots of customization is required on target objects. And then becomes a standard IDE.

The customer support needs to be better equipped for enterprises, and assistance for enterprise customisation should be enhanced. Not all organisations are the same, so a team dedicated to specific platforms used in enterprise would be beneficial. The overall support would be greatly enhanced by having resources dedicated to assisting with template builds across platforms (hive for example) Review collected by and hosted on G2.com.

Team can work very effectively together.

The best catalog for BI.

Auto documentation capabilities Review collected by and hosted on G2.com.

It takes time to learn as there are multiple tools to look into to get appropriate solution. Review collected by and hosted on G2.com.

I can see benefits in the template code generation, but have been constantly let down by core issues in the product Review collected by and hosted on G2.com.

The entire application feels tired and neglected. There are numerous UI bugs and quirks that are not being fixed.

Application performance is subpar. Functionality like 'Trace Lineage' is very useful, but it takes multiple minutes to generate in WS Red and locks up the entire application while processing it.

There is only limited ability to mass change objects within Red (such as table column renames etc).

We are using a _supported_ DB platform that has higher than normal latency. Red runs all DB operations on the UI thread, resulting in the entire application freezing for minutes at a time. This results in a very frustrating development experience. Why would any application run DB operations on the UI thread?

There is practically no version control or support for external version control, which makes code deployments a nightmare - without version control or built in change tracking, its difficult to track changes within a development environment to promote them further, resulting in haphazard attempts to track changes by hand.

Experience with customer support has been poor. We have issues open with WS that are still 'pending development' 2 years later and there seems to be no urgency in resolving our problems. Review collected by and hosted on G2.com.

- Automation of tasks

- Consistency of generated code

- Including automated generation of lineage and documentation

- Maintainability of the 'code' base

- Metadata as the start of everything

- Good in metadata management and integration

- Openness of repository data model

- Plain SQL output

- Possibility of migration to new targets

- Integrated view of Warehouse development

- Support for short cyclical work (Agile BI)

- Productivity gains

- Ease of database integrations /connectors

- Version management (I like that it's there; I also think it can be simplified)

- Good customer support

- Easy install Review collected by and hosted on G2.com.

- Interface is a fat client with a large dependency on Windows

- DevOps deployment support is getting better in small steps only. Still needs considerable effort

- Lineage stops at the warehouse, which also has to do with the limitations of opening up information due to license model Review collected by and hosted on G2.com.

WhereScape puts a lot of the ETL I do in one place. I'm quickly able to take a piece of source data, transform and cleanse it, and get it into our reporting environment without a lot of effort. While it doesn't fully design the datawarehouse, it certainly makes the build and deploy processes faster. Review collected by and hosted on G2.com.

The scheduler could use some work. It is robust, but there are some quirks about moving things from the dev environment to the production environment and I feel like it could be easier to get it to send out success/failure notifications. Review collected by and hosted on G2.com.

RED comes with a well working data vault creation and update processing starter pack. But best is, that you are able to customize and patch everything by yourself as far as you want. There are very lot of features you can use, if you know them. Review collected by and hosted on G2.com.

there are a lot of little bugs and unintuitive behaviours of the software, which produces a lot of pain - especially at beginning of usage. It is hard to learn and you are quickly overwhelmed by it's complexity. Review collected by and hosted on G2.com.

automation in data integration, transformation and support. Review collected by and hosted on G2.com.

learning curve compared to other data ETL tool. Self-lead training sucks when training material isn't updated with training environments. Review collected by and hosted on G2.com.

Technology enhancement that helps to work. Review collected by and hosted on G2.com.

Documentation better can be used to understand Review collected by and hosted on G2.com.

Data Vault does require automation and WhereScape is currently one of the best tools to do Data Vault automation.

Initial creation of artefacts is relatively easy and straight-forward. Review collected by and hosted on G2.com.

Has trouble scaling up to enterprise use -- lack of fine-grained permissions most glaring issue.

Difficult to integrate in a DataOps pipeline - practical deployment, especially changes to existing artefacts, requires lots of manual interventions.

Customer support non-responsive. Review collected by and hosted on G2.com.