WhereScape RED Reviews

Overall rating
Filter by
Company size
Time used
27 Reviews
- Industry: Machinery
- Company size: 10,000+ Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
best DWA expert tool
Reviewed on 2025/01/30
we are using WhereScape for over 3 years, startet on Oracle, now also on Databricks
we are using WhereScape for over 3 years, startet on Oracle, now also on Databricks
Pros
supports all kinds of data modeling; platform independent
Cons
usage, UI is looking very old fashion, huge effort for creating templates
Response from WhereScape Software
Thank you for sharing your experience with WhereScape! We’re glad to hear you value its support for all kinds of data modeling and its platform independence—especially as you’ve transitioned from Oracle to Databricks.
We appreciate your feedback on the UI and template creation effort. Improving the user experience is always a priority, and we’re continuously working to enhance WhereScape’s interface and automation capabilities. If you have specific suggestions, we’d love to hear them!
Thanks again for being a longtime WhereScape user—we’re excited to keep supporting your data automation journey.
- Industry: Telecommunications
- Company size: 5,001–10,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Red is the new Black
Reviewed on 2023/12/22
Pros
Ease of use
Low threshold
Power of SQL
Small footprint
Cons
Scheduling, although effective but not optimal
Response from WhereScape Software
Thank you for your review! We’re delighted to hear that you find WhereScape RED easy to use, powerful, and efficient. It’s great to know that its low threshold and SQL-driven approach have been beneficial for your team.
We appreciate your feedback on scheduling. While effective, we understand that there’s always room for improvement, and we’re continuously exploring ways to enhance this functionality. If you have any specific suggestions or challenges you’ve encountered, we’d love to hear more.
We’re also excited to learn that you made the switch from PowerCenter to RED! If there’s anything we can do to further support your transition and maximize the value of WhereScape RED for your team, please don’t hesitate to reach out.
- Industry: Farming
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 5.0 /10
Red - our experience
Reviewed on 2023/12/22
Pros
The way it generates code is awesome, but sometimes there are some frustrations with using the software. One example is that if a job processes source mappings for a table, when the source mappings are changed, the job doesn’t pick up the changes and fails.
Cons
The software technology is a little dated and we see some inconsistencies in how some processes work.
Response from WhereScape Software
Thank you for taking the time to share your experience with WhereScape RED. We’re glad to hear that you appreciate the way it generates code and find value in its automation capabilities.
We understand your concerns regarding job processing and source mapping changes, as well as inconsistencies in certain processes. Our team is continuously working to improve the platform, and your feedback is incredibly helpful in guiding these enhancements. If you’d like, we’d be happy to connect and discuss your specific challenges further to see how we can better support your use case.
We truly appreciate your insights and your continued use of WhereScape RED. Please don’t hesitate to reach out if there’s anything we can do to improve your experience.
- Industry: Financial Services
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Long Term user of Wherescape RED
Reviewed on 2025/02/07
We have been using Wherescape RED for over a decade and it has been great. The team are very...
We have been using Wherescape RED for over a decade and it has been great. The team are very receptive and helpful with out questions and issues.
Pros
Simple to install and very simple to create ELT processes. The self-documenting feature is a huge time saver
Cons
Works very well with SQL Server but experience with flat files is less than optimal
Response from WhereScape Software
Thank you for taking the time to share your experience with WhereScape RED! We’re thrilled to hear that you’ve found it simple to install and use for ELT processes—and that the self-documenting feature has been a huge time saver for your team.
We also appreciate your feedback regarding flat file support. We’re always looking for ways to improve, and your insights help us refine our platform to better meet the needs of long-term users like you.
It’s fantastic to hear that our team has been receptive and helpful over the years. If you ever have further suggestions or need any assistance, don’t hesitate to reach out—we’re here to help!
Thanks again for your continued support, and we look forward to many more years of success together.
- Industry: Information Technology & Services
- Company size: Self Employed
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
WSR (WhereScape RED) relevance in today's data transformation and migration market
Reviewed on 2023/12/21
Using WSR (WhereScape RED) since 2005,
it has embraced all the Data Warehouse architectures...
Using WSR (WhereScape RED) since 2005,
it has embraced all the Data Warehouse architectures (Kimball, Inmon, Linstedt)
through excellent template driven logic.
Additionally, WSR has been an excellent data migration tool.
Pros
strong metadata engine allowing login automation, diagramming and documentation.
Cons
An unavoidable lag in integration with the Microsoft technology stack.
For example, Microsoft Fabric, a SaaS product, brings unified analytics servicing many levels of Data Analysis through Work Spaces, OneLake and AI.
Response from WhereScape Software
Thank you for sharing your experience with WhereScape RED! We truly appreciate your long-standing support since 2005 and are thrilled to hear that RED has been a valuable tool for data warehouse automation, embracing various architectures and serving as an effective data migration solution.
Your recognition of RED’s strong metadata engine, automation capabilities, and documentation features means a lot to us. We also acknowledge your concern regarding integration with Microsoft’s evolving technology stack, including Microsoft Fabric. As the data landscape continues to evolve, we are committed to ensuring RED remains a powerful and adaptable solution, and your feedback is invaluable in guiding future enhancements.
Thank you again for your insights and for being a valued WhereScape user!
- Industry: Government Administration
- Company size: 5,001–10,000 Employees
- Used Monthly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 6.0 /10
Software Developer
Reviewed on 2024/07/05
I'd use it again if presented with an opportunity, but I am in a different role now and my...
I'd use it again if presented with an opportunity, but I am in a different role now and my organization has gone in a different direction.
Pros
Once you got to know the app, it made sense. The organization was intuitive.
Cons
The barrier to getting to know the app was often high for newcomers. We also worked with some resources that started and started again a few projects that left artifacts all over the place because we never could quite get over the finish line and do a version upgrade... but that's on us in the end.
Response from WhereScape Software
Thank you for sharing your experience with WhereScape! We appreciate your insights and are glad to hear that, once familiar with the platform, you found it intuitive and well-organized.
We understand that the initial learning curve can be a challenge, especially for newcomers. We’re always looking for ways to improve the onboarding experience and reduce barriers to adoption, so your feedback is incredibly valuable. Regarding version upgrades and project artifacts, we recognize that maintaining clean and efficient workflows is crucial, and we’re continually working to enhance our support and best practices to help teams navigate these challenges more smoothly.
Even though you’re in a different role now, we truly appreciate your time with WhereScape and are grateful to hear that you’d use it again given the opportunity. If you ever have any additional feedback or would like to reconnect in the future, we’d love to hear from you!
Wishing you all the best in your current role and beyond
- Industry: Education Management
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Red has been a great tool to maintain our jobs and load our warehouse(s)
Reviewed on 2025/01/30
Using it for a good 10+ years. It is fast to provide a solution to a business need.
Using it for a good 10+ years. It is fast to provide a solution to a business need.
Pros
It is easy to use and when you follow the rigor (the how to use) it provides error free code.
Cons
Getting some of the meta data for creating the jobs is a little cluegy.
Response from WhereScape Software
Thank you for sharing your experience with WhereScape RED! It’s great to hear that you’ve been using it for 10+ years and that it provides error-free code and fast solutions to business needs when following best practices.
Metadata plays a crucial role in automation, and we’re always looking to enhance the experience to make job creation as seamless as possible. If there’s anything specific you’d like to see improved, we’d love to hear your thoughts.
We appreciate your continued trust in WhereScape and look forward to supporting your data automation journey!
- Industry: Financial Services
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 5.0 /10
Review of 3D
Reviewed on 2024/01/03
Tool itself is pretty good, however do to missing features or bugs, there is still a lot of manual...
Tool itself is pretty good, however do to missing features or bugs, there is still a lot of manual work needed and workflow cannot be fully automated.
Pros
- tool is quite capable of process and transforming metadata
- works fine for the basic setup
Cons
- naming convention is hard to adjust (e.g. hardcoded dss_ columns, data types of sources are overwritten with DVD data types)
- lack of proper integration to RED (distinct repos, additional tool needed to deploy metadata from 3D to RED)
- lack of proper metadata ingestion from RED (e.g. source mapping do not get imported)
Response from WhereScape Software
Thank you for taking the time to share your experience with WhereScape 3D. We truly appreciate your feedback, as it helps us continue improving our solutions to better serve our users.
We're glad to hear that you find 3D to be a capable tool for processing and transforming metadata. At the same time, we understand your concerns regarding naming conventions, metadata ingestion, and integration with RED. We recognize that seamless automation is critical, and we’re actively working on enhancements to streamline these processes. Your specific points about metadata deployment and ingestion are valuable insights that we’ll share with our product team.
If you're open to it, we'd love to connect and learn more about your workflow challenges so we can explore potential solutions. Please feel free to reach out to our support team or your account representative. Your input plays a crucial role in shaping future updates.
Thanks again for your feedback and for being a WhereScape user!
- Industry: Airlines/Aviation
- Company size: 5,001–10,000 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Wherescape Review
Reviewed on 2025/02/07
Powerful tool with variety of features and job scheduling
Powerful tool with variety of features and job scheduling
Pros
Features and ease of orchestration
Integration with various data sources
Cons
User interface is obsolete
Can improve the application speed
Response from WhereScape Software
Thank you for taking the time to share your experience with WhereScape RED! We're glad to hear that you find our features and orchestration capabilities valuable, along with our integration with various data sources.
We appreciate your feedback on the user interface and application speed. Improving the user experience and performance is a key focus for us, and we're continuously working on enhancements. Your insights help us prioritize updates that make WhereScape even more powerful and user-friendly.
If you have any specific suggestions or use cases where you’d like to see improvements, we’d love to hear them. Please feel free to reach out to our team—we’re always looking for ways to enhance your experience.
Thanks again for being a valued WhereScape user!
- Industry: Information Technology & Services
- Company size: 501–1,000 Employees
- Used Weekly for 1-5 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Great product
Reviewed on 2025/01/30
Overall good product that helped with data warehouse management.
Overall good product that helped with data warehouse management.
Pros
Good tool that helped with data warehouse management.
Cons
Did not work so well with large datasets.
Response from WhereScape Software
Thank you for taking the time to share your experience with WhereScape! We're glad to hear that you found our tool helpful for data warehouse management.
We understand that working with large datasets can present challenges, and we’re continuously improving our platform to enhance performance and scalability. If you have any specific details or use cases you’d like to share, we’d love to explore potential optimizations that could better meet your needs.
We appreciate your support and are here to help if you need anything!
- Industry: Airlines/Aviation
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Like Having A Free Developer
Reviewed on 2024/01/03
Pros
The ease of loading data from external sources, databases, flat files, API calls, etc.
The ease of transforming data
Cons
Keeping data in sync is our biggest challenge, but that's not a cause of the software. It would be nice if RED had built in database synchronization between source systems and the warehouse.
Response from WhereScape Software
Thank you, Nathan, for your valuable feedback on WhereScape RED. We're glad to hear about your positive experience with data loading and transformation.
WhereScape RED offers a data synchronization feature to compare the source database with warehouse landing tables. It's a manual process, but it effectively generates code to update the landing tables and keep them in sync with your source.
Your insights are crucial to our continuous improvement, and we're committed to enhancing our software to better meet your needs. Thank you for being a part of our community and for your support!
- Industry: Sports
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 9.0 /10
It's a good tool for our environment
Reviewed on 2023/12/14
We have been quite happy with WhereScape over the 5+ years we have had it. I do recommend getting...
We have been quite happy with WhereScape over the 5+ years we have had it. I do recommend getting fully trained by the WhereScape team before starting development. They will give you a good boost of best practices, something we did not do in our implementation.
Pros
The simplicity.
When we have a new data source, I can connect to it and be productive creating data flows in just a few minutes. Since RED creates scripts that I can view (or modify) I am able to troubleshoot any issues that come up.
Cons
The Scheduler.
I wish there was a SaaS version of WhereScape RED that didn't require a complete migration from our current version 8.6
- Industry: Accounting
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Wherescape
Reviewed on 2024/01/03
Pros
The ease of use and consolidating data has been helpful.
Cons
There have not been a lot of updates/upgrades over the years to justify the support renewal.
Response from WhereScape Software
Thank you for sharing your thoughts on WhereScape! We’re glad to hear that you’ve found the platform easy to use and beneficial for consolidating data. Ease of use is one of our top priorities, so it’s great to know it’s making a difference for you.
We also appreciate your honest feedback regarding updates and upgrades. Continuous improvement is important to us, and we’re actively working on enhancements to bring even more value to our users. If there are specific features or improvements you’d like to see, we’d love to hear more about them. Your input helps shape our roadmap and ensures we’re delivering meaningful updates.
- Industry: Financial Services
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Easy way to develop a DataWarehouse
Reviewed on 2023/12/21
Overall I am very happy about choosing WhereScape RED.
Overall I am very happy about choosing WhereScape RED.
Pros
How easy it was to build and deploy.
I was also very easy to connect to sources to start develpoing.
Cons
The Scheduler could be better and sometimes tables change with out a reason.
Alternatives Considered
TimeXtenderReasons for Switching to WhereScape RED
Response from WhereScape Software
We really appreciate you taking the time to share your experience with WhereScape RED! It’s great to hear that you’ve found it easy to build, deploy, and connect to various data sources—that’s exactly what we aim for with our automation capabilities.
We also appreciate your feedback on the Scheduler and unexpected table changes. We’re always working to improve WhereScape RED, and insights like yours help us refine and enhance the platform. If you have any specific details on these challenges, we’d love to learn more so we can address them.
It’s great to hear that WhereScape RED provided a simpler solution for your needs compared to alternatives. Thank you for choosing us—we’re glad to have you on board!
- Industry: Oil & Energy
- Company size: 501–1,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Fantastic Warehouse Automation Tool for Agile Data Development
Reviewed on 2023/12/12
Overall, RED has been a great warehouse automation tool that has made development and maintenance...
Overall, RED has been a great warehouse automation tool that has made development and maintenance of data solutions seemless.
Pros
Ease of use, metadata management and automatic code generation during deployments, data lineage and documentation
Cons
Inability to work with more native data sources. e.g GRAPH API sources and CDS ABAP views
- Industry: Insurance
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Wherescape needs Pyspark
Reviewed on 2023/12/19
Wherescape has been doing great in traditional ETL processing but needs to add new feature and...
Wherescape has been doing great in traditional ETL processing but needs to add new feature and cloud native support
Pros
Ease of doing mappings for ETL and for SQL related tasks
Cons
It is hard to integrate with third party tools, sometimes only option is to use command line, create batch file and call from wherescape
- Industry: Logistics & Supply Chain
- Company size: 501–1,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Wherescape Review
Reviewed on 2023/12/18
Excellent product. Very stable and reliable. Used to control and manage a small Data Warehouse...
Excellent product. Very stable and reliable. Used to control and manage a small Data Warehouse (currently 1billion rows across all data). Used daily. Wherescape is my main control centre.
Pros
Ease of use - While the interface is old it is very easy to use with common functionality repeated in different places.
Reliability - the product is rock solid. Never fails
Cons
Old interface
The interface is a little dated. It could perhaps use a few updates to more modern controls.
- Industry: Automotive
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Nice automation tool
Reviewed on 2023/12/21
Nice tool that is easy to learn and effective
Nice tool that is easy to learn and effective
Pros
Nice with no coding thinking. Drag n drop function.
Cons
Not always that easy to connect to semi structured sources. Metadata stores ”on-prem”.
Response from WhereScape Software
Thank you for sharing your experience with WhereScape RED! We're glad to hear that you appreciate the no-code approach and drag-and-drop functionality—making data automation easier is what we strive for.
We also appreciate your feedback on connecting to semi-structured sources and metadata storage being on-prem. We recognize these challenges and are continually working on improving our integrations and deployment flexibility. If you have specific use cases where you're facing issues, we'd love to explore potential solutions with you.
It’s great to hear that you find WhereScape RED easy to learn and effective. Thanks again for your insights and for being a valued user!
- Industry: Semiconductors
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 4.0 /10
Not so good in current Market
Reviewed on 2023/12/13
We need to add more feature and ETL components to make WhereScape competitive.
Need to add Python...
We need to add more feature and ETL components to make WhereScape competitive.
Need to add Python component/ or scope of python while writing the code as well. will make WhereScape as a go to product
Pros
UI , the look and feel is very easy .
Job monitoring page i.e. Scheduler is very simple to track and the detail logs as well.
TRACK BACK DIAGRAM is best
Cons
The Builder part and the parameterization .
- Industry: Nonprofit Organization Management
- Company size: 5,001–10,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Data Warehouse Specialist
Reviewed on 2023/12/12
We would never have been able to bring up a datawarehouse that is now used by over 100 organizations...
We would never have been able to bring up a datawarehouse that is now used by over 100 organizations without it. We have done this with only 1 developer.
Pros
It is so easy to bring on new data sources and transform it into our star schema.
Cons
Loading from Amazon S3 and other sources like that is still in its infancy.
- Industry: Primary/Secondary Education
- Company size: 1,001–5,000 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Year in review
Reviewed on 2023/12/12
Pros
The ability to design and create manipulating only the metadata. This allows for the focus and efforts to stay at building the best logical model without having to get lost in the weeds of coding all the underlying procedures.
Cons
The UI is a little out of date, however I know a new UI is in the works and I am excited to experience that.
- Industry: Primary/Secondary Education
- Company size: 1,001–5,000 Employees
- Used Weekly for 1-5 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
New to Data Warehouse and WhereScape RED
Reviewed on 2023/12/21
Pros
WhereScape RED has allowed our team to save time on projects by simplifying and automating the SQL query writing process.
Cons
Like any new solution, there is a learning curve. In our environment, the learning curve was a juggle between other projects, which made it a tedious experience. Overall, the team caught up with training and is comfortable working within the RED environment.
Response from WhereScape Software
We appreciate you taking the time to share your experience with WhereScape RED! It’s great to hear that RED has helped your team save time by simplifying and automating the SQL query writing process—that’s exactly what we strive for.
We understand that adopting any new solution comes with a learning curve, especially when balancing multiple projects. It’s great to hear that your team has successfully navigated the training and is now comfortable working within the RED environment. If there are any resources or best practices that could further support your team’s success, we’d be happy to help!
Thank you again for your feedback, and we look forward to continuing to support your data automation journey.
- Industry: Government Administration
- Company size: 5,001–10,000 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 9.0 /10
An easy to use and inexpensive tool
Reviewed on 2023/12/13
Pros
Good usability, automation of tedious tasks, inexpensive
Cons
Could benefit from an improved search functionality
- Industry: Utilities
- Company size: 1,001–5,000 Employees
- Used Daily for 6-12 months
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
could be better
Reviewed on 2023/12/12
would be great if there's more videos online on getting more value out of wherescape red
would be great if there's more videos online on getting more value out of wherescape red
Pros
ease of use. functional
as an existing solution it's ok, but it's not ready for big data (snowflake)
Cons
not great with snowflake
more dev required in this space
need more tech support
- Industry: Government Administration
- Company size: 1,001–5,000 Employees
- Used Daily for 1-5 months
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
User Experience with WS RED
Reviewed on 2023/12/12
Pros
Data tracking from source to target
automation
Cons
training material sucks. it's out of dated and thus hard to follow