WhereScape RED Other Advice

GaryM
Data Architect at a non-profit with 1,001-5,000 employees
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 staff with little data warehousing experience can get up to speed easily and not have to worry about building logging, orchestration and error frameworks or even know much about data warehouse design. Unfortunately this tool's basic architecture has severe flaws which make it likely impractical for most real world marts or data warehouses. It has some significant cons in the following areas: - Metadata support specific (cannot share across multiple) target database - Unreliable lineage - Lacks capability to interface with application API's - Lacks out-of-box CDC control capabilities - Poor/outdated GUI (looks like early 1990s) - Lack of available resources in the market place who can operate this tool - Lack of customer base and information available - Primitive logging and error handling - Forced duplication of staging data multiple times - Inability to separate source data capture from targets (tightly couples sources with targets) - Stores all objects in single target database causing number of issues such as backup/recovery, fragmentation, limited organization options for objects View full review »
Kevin Marshbank
BI Architect at a healthcare company with 5,001-10,000 employees
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 job is preparing data and 20% is doing the analysis. I purchased WhereScape RED to flip that equation on its head. View full review »
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: June 2019.
348,558 professionals have used our research since 2012.

Sign Up with Email