# WhereScape RED Reviews **Vendor:** WhereScape Software **Category:** [Data Warehouse Automation Software](https://www.g2.com/categories/data-warehouse-automation) **Average Rating:** 3.9/5.0 **Total Reviews:** 42 ## About WhereScape RED WhereScape RED is a comprehensive data warehouse automation tool designed for developers, focusing on automating development, deployment, and operations of data infrastructure. It streamlines the data warehousing process by automating code generation, documentation updates, and workflow management, and integrates with leading data platforms. The tool supports rapid prototyping, full ELT capabilities, and provides a complete lifecycle management solution, enhancing efficiency and reducing the need for manual coding. ## WhereScape RED Pros & Cons **What users dislike:** - Users find the **poor documentation** of WhereScape RED challenging, making it harder to understand and use effectively. (1 reviews) ## WhereScape RED Reviews ### 1. Excellent Data Automation Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Michael L. | Enterprise (> 1000 emp.) **Reviewed Date:** April 12, 2024 **What do you like best about WhereScape RED?** 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. **What do you dislike about WhereScape RED?** 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. **What problems is WhereScape RED solving and how is that benefiting you?** Wherescape RED is our primary ETL tool, we also use it for a component for some of our system to system integrations that rely on flat files/SFTP. **Official Response from Kortney Phillips:** > Thank you for sharing your positive feedback on WhereScape RED! We're thrilled to hear that you find the tool easy to use and appreciate its documentation and support. We understand your feedback about creating pipelines from API sources and appreciate your willingness to explore the host script extensibility for this purpose. If you encounter any challenges during this process or need assistance with configuration/customization, please don't hesitate to reach out to our support team. We're here to help ensure you get the most out of WhereScape RED for all your ETL and integration needs. Thank you for choosing WhereScape! ### 2. Powerful template driven code generator **Rating:** 4.0/5.0 stars **Reviewed by:** Luqman Kajee H. | Senior Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** February 26, 2024 **What do you like best about WhereScape RED?** 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. **What do you dislike about WhereScape RED?** 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) **What problems is WhereScape RED solving and how is that benefiting you?** We are using RED to Automate our Data Warehouse build on DV2.0. We are the team responsible for how this is implemented, so the benefit we get is automatically generated scripts for a massive organisation with a low number of developers. We would not have been able to manually build out over 5000 objects in the time we have been using the tool **Official Response from Kortney Phillips:** > Thank you for sharing your detailed feedback. We are thrilled to hear that you find the template-driven code generation powerful and beneficial for your Raw Data Vault construct. We appreciate your insights on areas for improvement, such as better support for Business Data Vaults and enhanced customization assistance. Your success story of automating Data Warehouse builds on DV2.0 with over 5000 objects is inspiring. We value your suggestions for dedicated resources to assist with template builds across platforms. We will take your feedback into consideration to enhance our customer support and customization services for enterprises. If you have any further suggestions or need assistance, please feel free to reach out. We are here to support you every step of the way! ### 3. WhereScpare Red review by Pankaj vyas (Software engineer) **Rating:** 3.5/5.0 stars **Reviewed by:** pankaj v. | Software Engineer II, Enterprise (> 1000 emp.) **Reviewed Date:** September 12, 2024 **What do you like best about WhereScape RED?** Team can work very effectively together. The best catalog for BI. Auto documentation capabilities **What do you dislike about WhereScape RED?** It takes time to learn as there are multiple tools to look into to get appropriate solution. **What problems is WhereScape RED solving and how is that benefiting you?** We had a report generation project which was designed using ETL & WhereScape Red helped us to work more effectiently and harmoniously ### 4. Disappointing and does not live up to the sales pitch **Rating:** 1.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** February 26, 2024 **What do you like best about WhereScape RED?** I can see benefits in the template code generation, but have been constantly let down by core issues in the product **What do you dislike about WhereScape RED?** 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. **What problems is WhereScape RED solving and how is that benefiting you?** Generation of DV models (RV and BV) and coordination of data load processes **Official Response from Kortney Phillips:** > Thank you for taking the time to share your detailed feedback on WhereScape RED. We sincerely apologize for the issues you've encountered and the disappointment you've experienced. Your honest input is invaluable to us as we strive to improve our product and services. We recognize the challenges you've highlighted, including the UI bugs, application performance issues, and the concerns with 'Trace Lineage' functionality. Your points on the limitations regarding mass object changes, database operations on the UI thread, lack of version control, and your experience with our customer support are well-taken. We understand how these issues can significantly impact your development experience and productivity. We are committed to addressing these concerns and have already taken several steps towards improvement such as the launch of new training courses. These courses are designed to empower our users with better knowledge and practices for using WhereScape RED effectively. We believe this will also address some of the challenges you've faced by providing deeper insights into the product's capabilities and best practices for overcoming common hurdles. We value your business and are eager to restore your confidence in WhereScape RED. We would appreciate the opportunity to discuss your concerns further and explore how we can support your ongoing projects. Please feel free to reach out to us directly. Thank you again for your feedback. It is crucial for driving our improvements and ensuring we better meet our users' needs. ### 5. Wherescape RED review **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** February 15, 2024 **What do you like best about WhereScape RED?** - 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 **What do you dislike about WhereScape RED?** - 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 **What problems is WhereScape RED solving and how is that benefiting you?** Automation allows us to be to do agile warehouse development, be productive and keep the data team small. It fits the intended and envisioned architecture **Official Response from Kortney Phillips:** > Thank you for your detailed review! We appreciate your positive feedback on the automation of tasks, consistency of generated code, and the inclusion of automated generation of lineage and documentation. We also value your comments on the maintainability of the code base and the openness of the repository data model. We are glad to hear that WhereScape RED has helped you with agile warehouse development, productivity gains, and keeping your data team small. If you have any further questions or need assistance, please don't hesitate to reach out to our customer support team. Thank you for choosing WhereScape RED! ### 6. WhereScape shortens the travel time from source to target for data our business needs for reporting. **Rating:** 5.0/5.0 stars **Reviewed by:** Greg G. | SQL Database and Business Intelligence Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** February 14, 2024 **What do you like best about WhereScape RED?** 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. **What do you dislike about WhereScape RED?** 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. **What problems is WhereScape RED solving and how is that benefiting you?** As the only database/BI manager for the company, I have a lot of roles to fill. WhereScape helps me consolidate a lot of my design and deployment responsibilities into one place and as such, saves me a lot of time. **Official Response from Kortney Phillips:** > Thank you for your feedback on WhereScape RED! We're glad to hear that you find our platform helpful in consolidating your ETL processes and saving you time. We understand that the scheduler could use some improvements, especially when it comes to moving items between environments and sending out notifications. We appreciate your input and will take it into consideration for future updates. At WhereScape, our goal is to provide a solution that streamlines the data integration process and helps businesses like yours efficiently manage their data. We're pleased to hear that our platform has been beneficial in consolidating your design and deployment responsibilities, allowing you to focus on other important tasks. If you have any further suggestions or concerns, please don't hesitate to reach out. We're here to support you. ### 7. very powerful tool to automate real data vault **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Food & Beverages | Mid-Market (51-1000 emp.) **Reviewed Date:** February 14, 2024 **What do you like best about WhereScape RED?** 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. **What do you dislike about WhereScape RED?** 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. **What problems is WhereScape RED solving and how is that benefiting you?** Creating data warehouse with all benefits of data vault methodology. Holding data auditable, changable and historizing with business perspective for BI reporting. **Official Response from Kortney Phillips:** > Thank you for your feedback on WhereScape RED! We're glad to hear that you find it to be a powerful tool for automating real data vault creation and update processing. We understand that the ability to customize and patch everything to your liking is a valuable feature. At WhereScape, we are dedicated to continuously enhancing our services and swiftly resolving any issues that may arise. Should you require any assistance or additional guidance during your onboarding process, please feel free to contact us. Our team is always eager to ensure your experience with us is nothing short of exceptional. Thank you again for taking the time to leave a review. You're input is invaluable and we appreciate you as a loyal user. ### 8. Lead Data Warehouse developer **Rating:** 4.5/5.0 stars **Reviewed by:** rajesh b. | Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** February 12, 2024 **What do you like best about WhereScape RED?** Easy to use and very friendly user interface. Best part is the documentation of the processes in the backend for both Technical team and Business users. **What do you dislike about WhereScape RED?** Sometimes the errors in the job failures are deceptive. **What problems is WhereScape RED solving and how is that benefiting you?** ETL processes, it streamlines all over ETL processes and it is robustic in performance. Generates all the manual code in the backend which is the best part for the developers. **Official Response from Kortney Phillips:** > Thank you for your positive feedback! We're glad to hear that you find our platform easy to use with a friendly user interface. We also appreciate your comment about the documentation, as we strive to provide comprehensive resources for both technical teams and business users. WhereScape RED is designed to streamline ETL processes and provide robust performance. We're thrilled to hear that it has been beneficial for you in these areas. If you have any further feedback or questions, please don't hesitate to reach out. We're here to help! ### 9. WhereScape RED in data integration and transformation **Rating:** 5.0/5.0 stars **Reviewed by:** Nikki H. | Data and Application Integration Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** February 26, 2024 **What do you like best about WhereScape RED?** automation in data integration, transformation and support. **What do you dislike about WhereScape RED?** learning curve compared to other data ETL tool. Self-lead training sucks when training material isn't updated with training environments. **What problems is WhereScape RED solving and how is that benefiting you?** automation in data ETL process once model has been built. easier support and maintainence compared with other ETL tool **Official Response from Kortney Phillips:** > Thank you for sharing your feedback! We're thrilled to hear that you appreciate the automation it provides for data integration and transformation. We understand your concerns about the learning curve and training material, and we apologize for any inconvenience this has caused. Our customer support team is always here to help if you require further assistance, please don't hesitate to reach out. We value your input and are here to support you in maximizing the benefits of WhereScape RED for your data ETL processes. ### 10. Good work in tech **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Accounting | Mid-Market (51-1000 emp.) **Reviewed Date:** September 14, 2024 **What do you like best about WhereScape RED?** Technology enhancement that helps to work. **What do you dislike about WhereScape RED?** Documentation better can be used to understand **What problems is WhereScape RED solving and how is that benefiting you?** Helps in extract data ### 11. Product with great promise, but poor execution **Rating:** 1.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** February 23, 2024 **What do you like best about WhereScape RED?** 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. **What do you dislike about WhereScape RED?** 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. **What problems is WhereScape RED solving and how is that benefiting you?** Managing Data Vault at scale. Practical implementation of Data Vault requires automation. **Official Response from Kortney Phillips:** > Thank you for your feedback on WhereScape RED and highlighting its strengths in Data Vault automation. We’re glad to hear that you found our tool to be one of the best for automating Data Vault, and that you’ve had a positive experience with the initial creation of artifacts. We're sorry to hear about the challenges you've faced with scaling, integration, and customer support. Your experience is important to us, and we're committed to improving. Could you please reach out to me directly at kortney.phillips@wherescape.com ? We'd like to understand more about the issues you've encountered and explore how we can make your experience better. Thank you again for your honest feedback. ### 12. Wherescape RED for small teams **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** February 15, 2024 **What do you like best about WhereScape RED?** If used properly, RED establishes "guardrails" for ELT processes that make building and troubleshooting data warehousing objects faster. **What do you dislike about WhereScape RED?** To properly implement the solution, you really need to think 10 steps ahead. When we initially constructed the enviornment, we **What problems is WhereScape RED solving and how is that benefiting you?** Having a self-documenting, metadata driven ELT tool has proven invaluable to helping with audits. Also, it established guiderails by which development should take place (templates). **Official Response from Kortney Phillips:** > Thank you for sharing your feedback on WhereScape RED! We're glad to hear that you find self-documenting features beneficial for your ELT processes and audits. We understand that proper implementation can require forward-thinking, and we appreciate your insight on this aspect. If you have any specific concerns or need assistance with optimizing your use of WhereScape RED, please feel free to reach out. We're here to support you and ensure you get the most out of our solution. Thank you for for being part of our community! ### 13. Tool has some limitations **Rating:** 2.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** February 28, 2024 **What do you like best about WhereScape RED?** Automated template generation saves a lot of time. **What do you dislike about WhereScape RED?** Lineage report generation takes a long time. Unable to easily see changed objects. Application building has limited features. **What problems is WhereScape RED solving and how is that benefiting you?** ETL and scheduling tool in one. Easy code generation based on set templates. **Official Response from Kortney Phillips:** > Thank you for sharing your feedback on WhereScape RED. We're glad to hear that you find the automated template generation feature helpful in saving time. We understand your concerns about the limitations you've experienced. Your feedback is important to us and we are listening. If you have any specific suggestions or further details on how we can enhance your experience with WhereScape RED, please reach out. We are committed to addressing your concerns and ensuring that our tool meets your needs effectively. Thank you for being part of our community! ### 14. Easy to use ETL tool **Rating:** 4.5/5.0 stars **Reviewed by:** Ranjit V. | Director, Chapter Leader, Data Engineering, Mid-Market (51-1000 emp.) **Reviewed Date:** November 09, 2023 **What do you like best about WhereScape RED?** Developer friendly, reuseable components and comes with lineage. Easy to develope, maintain and debug. **What do you dislike about WhereScape RED?** Tough to implement dynamic sql, takes time to implement coplex transofrmations. some compelx transofrmations leads to more development work **What problems is WhereScape RED solving and how is that benefiting you?** Comes with automatic lineage, easy to maintain pipelines, developer friendly, less coding required **Official Response from Kortney Phillips:** > We're glad you find WhereScape RED developer-friendly with useful features like reusable components and automatic lineage. Your feedback on the challenges with dynamic SQL and complex transformations is invaluable, and we're constantly working to enhance these areas. Thank you for being a part of our community! ### 15. Overall, I like the tools! **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Education Management | Enterprise (> 1000 emp.) **Reviewed Date:** February 09, 2024 **What do you like best about WhereScape RED?** Job is easer to add or remove the tasks. Version and Documentation **What do you dislike about WhereScape RED?** Do not like manually mapping in graphic mode. **What problems is WhereScape RED solving and how is that benefiting you?** Repeadly and muti-user work on the same ETL. **Official Response from Kortney Phillips:** > Thank you for taking the time to submit a review! We're glad to hear that you find it easy to add or remove tasks and appreciate the version and documentation features. WhereScape RED is designed to solve the problem of repeated and multi-user work on the same ETL. By streamlining the ETL process and allowing multiple users to collaborate, it helps to improve efficiency and reduce errors. We're glad to hear that this has been beneficial for you. If you have any further questions or feedback, please don't hesitate to reach out. We're here to help and appreciate your loyalty! ### 16. Use for snowflake enterpris data analytics **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Logistics and Supply Chain | Mid-Market (51-1000 emp.) **Reviewed Date:** February 15, 2024 **What do you like best about WhereScape RED?** Snowflake firendly tool. Useful for some complex transformations. **What do you dislike about WhereScape RED?** Client installation and configuration on new laptop was not easy, **What problems is WhereScape RED solving and how is that benefiting you?** Converting to snowflake datamart for data analytics. **Official Response from Kortney Phillips:** > Thank you for sharing your feedback! We're thrilled to hear that you find WhereScape RED to be a useful tool for complex transformations in Snowflake. We understand that the client installation and configuration process can sometimes be challenging, and we apologize for any inconvenience this may have caused. We appreciate your patience and are continuously working to improve the user experience. If you encounter any further difficulties or have any questions, please don't hesitate to reach out to our support team. We're here to assist you every step of the way to ensure a smooth transition to Snowflake datamart for your data analytics needs. Thank you for choosing WhereScape RED! ### 17. Application Analyst **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Government Administration | Mid-Market (51-1000 emp.) **Reviewed Date:** February 22, 2024 **What do you like best about WhereScape RED?** drag and drop, plus still allow coding for specfic rules. trace source and target. manage rules and templates. **What do you dislike about WhereScape RED?** I currently do not have negative comments about this product yet. **What problems is WhereScape RED solving and how is that benefiting you?** We are upgrading to implement DV2 and moving data to cloud. We use 3D and RED to develop ETL processes, our development is accelated. **Official Response from Kortney Phillips:** > Thank you for sharing your positive experience with WhereScape RED! We're thrilled to hear that you appreciate the drag-and-drop feature and the ability to code specific rules. It's great to know that you find value in the traceability of source and target, as well as the management of rules and templates. As you continue to upgrade and implement DV2 while moving data to the cloud, we're excited to be a part of your journey. Should you encounter any issues or have any feedback in the future, please don't hesitate to reach out to us. We're here to support you every step of the way. Thank you for choosing WhereScape RED! ### 18. Well integrated suite from Modelling to ETL generation with RED **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Small-Business (50 or fewer emp.) **Reviewed Date:** February 09, 2024 **What do you like best about WhereScape RED?** Integrated Modelling and ETL tool was a positive **What do you dislike about WhereScape RED?** Version control and CICD integration was a challenge **What problems is WhereScape RED solving and how is that benefiting you?** Seamless code generation from MODEL to PIPELINE in the DataWarehouse **Official Response from Kortney Phillips:** > We're glad to hear that you find WhereScape RED's integrated modeling and ETL tool to be a positive aspect of the platform. We understand that version control and CI/CD integration can be challenging, and we are continuously working to improve in these areas. While we have had many improvements, we strongly encourage you to reach out to support. We are happy to assist you in anyway possible. Thank you for sharing your feedback with us. ### 19. Very Little Enhancements each year for the renewal increase **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Accounting | Mid-Market (51-1000 emp.) **Reviewed Date:** February 09, 2024 **What do you like best about WhereScape RED?** The help in using and populating data to analyze. **What do you dislike about WhereScape RED?** Very Little Enhancements each year for the renewal increase **What problems is WhereScape RED solving and how is that benefiting you?** Helps in managing and connecting our data. **Official Response from Kortney Phillips:** > We hear you and appreciate your feedback. Our team is dedicated to continuously enhancing WhereScape RED to better meet your needs. Your input will be taken into account as we plan for future updates. I encourage you to reach out for a meeting to discuss recent releases and roadmap as we have had lots of new capabilities and improvements. Thank you for taking the time to submit a review! ### 20. Great tool to use **Rating:** 3.5/5.0 stars **Reviewed by:** Ramaraj P. | Enterprise Data / Information Architect, Enterprise (> 1000 emp.) **Reviewed Date:** June 24, 2020 **What do you like best about WhereScape RED?** Wherescape RED is a great tool, Easy to use, integrate with other tools and database is very easy **What do you dislike about WhereScape RED?** Wherescape RED is a great tool, It may not cater for latest cloud based tools **Recommendations to others considering WhereScape RED:** Would like to get more API and cloud products integrated into the this tools so that it can be very competitive product **What problems is WhereScape RED solving and how is that benefiting you?** Wherescape RED is a great tool, We use as Enterprise ETL tool and development is short for any solution ### 21. Easy tool for beginners seeking career in DB **Rating:** 4.0/5.0 stars **Reviewed by:** Karthick S. | Programmer Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** June 23, 2020 **What do you like best about WhereScape RED?** Wherescape RED is an easy tool for the beginners who are seeking their career in data. Good query knowlege is more than sufficient for most of the tasks to be completed. **What do you dislike about WhereScape RED?** If we face an error in the middle of the procedure which has multiple queries, there are no restart option at the check point to restart the procedure from the failed step or the next step after fixing the issue. **Recommendations to others considering WhereScape RED:** If you are working in a huge data warehouse and the scenarios are much more complex, Wherescape RED is one of the best tools in the mark which will make your life better. **What problems is WhereScape RED solving and how is that benefiting you?** We are working with a Healthcare Data Warehouse which has millions of data in each tables. Performance is the main advantage in RED. It is 5 times more faster than other graphical user interface ETL Tools which helps the database in a healthy condition while going for complex scenarios. ### 22. Data warehousing in minutes rather than years **Rating:** 5.0/5.0 stars **Reviewed by:** Carl R. | Oracle Systems Developer (MI Team), Mid-Market (51-1000 emp.) **Reviewed Date:** June 21, 2020 **What do you like best about WhereScape RED?** I have been using wherescape products for years now and I can’t fault the products at all. 3D allows me to discover and design a data warehouse effortlessly. RED allows me to build a warehouse in minutes rather than years. I can make changes with no consequences and it follows the agile methodology. I can’t get enough of building and exploring data based on wherescape foundations allows me to create data sets for my business. **What do you dislike about WhereScape RED?** Nothing. The product offers you so much. **Recommendations to others considering WhereScape RED:** The best decision I ever made in my last role to purchase wherescape RED **What problems is WhereScape RED solving and how is that benefiting you?** RED allows you to develop so quickly. You can try and not worry about failing because it takes no time at all to develop solutions. If you not interested in building a data warehouse RED allows you to create almost every other solution for your data needs. ### 23. I have created procedures, Jobs and loaded target tables **Rating:** 3.5/5.0 stars **Reviewed by:** Bikash K. | IT Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** June 10, 2020 **What do you like best about WhereScape RED?** This is a simple tool to load and transform data from source. This creates procedures automatically and also allows custom code. This tool also allows to create new jobs and to schedule to load data. **What do you dislike about WhereScape RED?** This tool does not allowed to import multiple columns import selectively. In case Complex process or data transformation is not possible in this tool. **Recommendations to others considering WhereScape RED:** This tool is easy to use and this creates oracle procedures automatically and also creates jobs to schedule the ELT run. So when anyone need faster data loaded with minimal time they can consider this tool. **What problems is WhereScape RED solving and how is that benefiting you?** We have used this tool where we have not complex data transformation involved and we have to create ELT pipeline faster. ### 24. I had a great experience while working in the technology. **Rating:** 4.5/5.0 stars **Reviewed by:** AMIT B. | Technology Lead, Enterprise (> 1000 emp.) **Reviewed Date:** July 05, 2020 **What do you like best about WhereScape RED?** The seemless integration when we migrated from the ETL to the ELT area. The migration from teradata and Informatica to wherescape happened very smoothly and most of the functionality we were able to implement successfully. **What do you dislike about WhereScape RED?** We had some trouble during early days to troubleshoot some issues as there were fewer documentation and community available. **Recommendations to others considering WhereScape RED:** A very good ETL tool which serves all the modern day DWH requirements. **What problems is WhereScape RED solving and how is that benefiting you?** We were able to save a lot and the hassle to have two technologies teradata and Informatica in our case was removed to minimum with just one tool. **Official Response from Kortney Phillips:** > Thank you for your positive feedback about your experience with WhereScape RED! We're glad to hear that the migration from ETL to ELT went smoothly and that you were able to successfully implement most of the functionality. It's great to hear that WhereScape RED has helped you save time and streamline your processes by eliminating the need for multiple technologies. We strive to provide a comprehensive ETL tool that meets modern day DWH requirements. If you have any further questions or need assistance, please don't hesitate to reach out. We're here to help! ### 25. Data Warehouse review **Rating:** 4.5/5.0 stars **Reviewed by:** Chow Kuan L. | Manager, Business Application, Mid-Market (51-1000 emp.) **Reviewed Date:** July 02, 2020 **What do you like best about WhereScape RED?** Simple drag and drop feature that ease me as a developer. **What do you dislike about WhereScape RED?** Connection to various data source is something somehow limited, unlike snowflake **What problems is WhereScape RED solving and how is that benefiting you?** I am in IT department in my company, dealing with Shipping data. ### 26. A Tool which is an alternative to Hassle of Data ingestion into Teradata **Rating:** 4.0/5.0 stars **Reviewed by:** Kishor M. | Senior Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 12, 2019 **What do you like best about WhereScape RED?** we started using wherescape Red a while ago when we started on a new project which required a medium to ingest the data from different source into our Teradata Environment. when we got to know about this tool we explored it and found it apt for the requirements we had. We extracted and transformed the data before loading it when we were finding it difficult to write Bteq jobs and implementing it on mainframes to do the transformation this tool became very handy and reduced a lot of manual efforts. I especially like the dependency flow diagram which it creates which gives the overall view of how a table is getting populated. Also maintaining the metadata of the table is very simple with this. **What do you dislike about WhereScape RED?** The only downside of the wherscape tool we found was during creating a job dependency. **What problems is WhereScape RED solving and how is that benefiting you?** It has mainly reduced a lot of manual work which we were doing while writing the jobs, also we were able to test and run the jobs with a click of a button. ### 27. ETL Automation **Rating:** 5.0/5.0 stars **Reviewed by:** Rajguru K. | Senior Associate, Mid-Market (51-1000 emp.) **Reviewed Date:** March 18, 2020 **What do you like best about WhereScape RED?** It's great IDE for automate the ETL process. Drag and drop of objects ,procedure generator by simple configuration, and easy scheduling option and deployment process **What do you dislike about WhereScape RED?** Limitations on From, Join conditions wizard when build procedure so it lead multiple procedures generation **Recommendations to others considering WhereScape RED:** Wherescape Red is easy tool can work on any technical person if they only SQL basics and it's faster data load process and easy deployment process. **What problems is WhereScape RED solving and how is that benefiting you?** Dynamic ETL process, easy code generation by simple drag and drop, cost is less compared to other etl tool ### 28. Wherescape RED review **Rating:** 3.5/5.0 stars **Reviewed by:** ujwal k. | Technology Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** March 26, 2020 **What do you like best about WhereScape RED?** Easy to use. Easy to make connection with Teradata database. Scheduling Jobs quit easy. **What do you dislike about WhereScape RED?** Need to delete jobs manually. 64 bit characters limit is a headache. Also, columns mapping create a lot of difficulty in load and stage table. **Recommendations to others considering WhereScape RED:** i recommend to use this. **What problems is WhereScape RED solving and how is that benefiting you?** I have created jobs using load , stage tables and used procedures in stages. Works quite fine. Benefit is its easy to identify any issue in Job. ### 29. The development is much faster in Wherescape red as compared to other tools in the market **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** June 20, 2020 **What do you like best about WhereScape RED?** Creation of facts and dimensions is faster and can be reproduced easily with other existing facts and dim. Easy to implement change tracking with wherescape **What do you dislike about WhereScape RED?** Less meterial about wherescape , you need to explore of your own mostly **Recommendations to others considering WhereScape RED:** It is a decent tool 👌 **What problems is WhereScape RED solving and how is that benefiting you?** Creation of different layers of data like staging , fact , dims and logical layers and loading data to redshift warehouse. ### 30. Wherescape for ETL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** June 22, 2020 **What do you like best about WhereScape RED?** Wherescape is easy to use and a reliable ETL. Never faced any issues while loading data. **What do you dislike about WhereScape RED?** I have been using wherescape for past 6 months for data load, and so far I have not found anything which I dislike. **Recommendations to others considering WhereScape RED:** Very good ETL tool, must try. **What problems is WhereScape RED solving and how is that benefiting you?** Mainly using it do load from different environments. I think it is very easy to use. ### 31. Wherescape red data warehousing automation tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** June 14, 2020 **What do you like best about WhereScape RED?** Faster capabilities to build ETL jobs. The software is designed to be robust. **What do you dislike about WhereScape RED?** Lack of compatibility with mainframe source is drawback. **Recommendations to others considering WhereScape RED:** If you are looking to develop ETL end to end applications. Wherescape Red is a good to use. **What problems is WhereScape RED solving and how is that benefiting you?** We design jobs to store health care information and generate report based on the stores data for analysis. ### 32. Saves time with development. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 24, 2020 **What do you like best about WhereScape RED?** Wherescape as a data warehouse automation tool is the only product around that does everything it does. It saves a lot of development time. **What do you dislike about WhereScape RED?** As a data modeler practitioner I don’t like the naming conventions that you sometimes have to conform to with WhereScape. **Recommendations to others considering WhereScape RED:** WhereScape is a Data warehouse automation tool. It is not a replacement for all etl/elt tools. It is not a replacement for sophisticated orchestration tools. It is not a replacement for data modeling tools. **What problems is WhereScape RED solving and how is that benefiting you?** WhereScape provides redundant tasks to be automated and allows for more time to be spent on analysis and design. ### 33. Wherescape user as data engineer and Analyst **Rating:** 4.5/5.0 stars **Reviewed by:** Nikhilesh J. | Assistant Manager- Business Intelligence, Enterprise (> 1000 emp.) **Reviewed Date:** December 12, 2019 **What do you like best about WhereScape RED?** All objects are available on one go. Can search any object and it's dependencies easily. **What do you dislike about WhereScape RED?** There should be detailed logs generated for each task. **Recommendations to others considering WhereScape RED:** Use it as maximum tasks as much you can do. First explore all the functionalities **What problems is WhereScape RED solving and how is that benefiting you?** We are solving problems related to decision making and reporting daily , monthly weekly reports. We are generating revenues on the basis of IFRS S15 standards for financial reporting. ### 34. Reduces a lot of manual work by coders and keeps the code in sync **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** June 06, 2020 **What do you like best about WhereScape RED?** The entire experience of coding was drag and drop, creating easy flows for complex codes. **What do you dislike about WhereScape RED?** Navigation without training was tough. Very less public material as guide was available. **What problems is WhereScape RED solving and how is that benefiting you?** Once understood creating code for different layers on date warehouse was easy. All the entire code be easily shared and replicated. Cutting down atleast 30% of worktime. ### 35. A must have tool for rapid prototyping **Rating:** 4.0/5.0 stars **Reviewed by:** Sumontro C. | Analytics Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** March 23, 2020 **What do you like best about WhereScape RED?** The ease of use of this tool helps orgs cut cost in rapid prototyping of proposed business solution. **What do you dislike about WhereScape RED?** Metadata management have a good scope of improvement **Recommendations to others considering WhereScape RED:** Go for it, give it a try. I believe you will like it. **What problems is WhereScape RED solving and how is that benefiting you?** Near real-time data vault solution for CDR. Ease of use and short development time. ### 36. Good **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Automotive | Mid-Market (51-1000 emp.) **Reviewed Date:** June 18, 2020 **What do you like best about WhereScape RED?** Easy to learn. Worked on data transformation. I have used WhereScape Red while working with Mitsubishi Motors and this is one of the best ETL tool I have worked in. **What do you dislike about WhereScape RED?** A few more advanced features would be more helpful. **Recommendations to others considering WhereScape RED:** - **What problems is WhereScape RED solving and how is that benefiting you?** Data transformation and report designing. ### 37. ETL developer 2+ years with wherescape **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Business Supplies and Equipment | Small-Business (50 or fewer emp.) **Reviewed Date:** June 21, 2020 **What do you like best about WhereScape RED?** Simple setup, easy interface, good for quick POC **What do you dislike about WhereScape RED?** Bad Performance, not suits for big enterprise pipelines **What problems is WhereScape RED solving and how is that benefiting you?** Building datawarehouse ### 38. Project /Functional /QA Manager **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.) **Reviewed Date:** April 22, 2020 **What do you like best about WhereScape RED?** Ease of use and maintenance. Works seamlessly across environments when designed and implemented properly. **What do you dislike about WhereScape RED?** Engage in more technical support with the client while during design and implementation. **What problems is WhereScape RED solving and how is that benefiting you?** A good ELT tool to implement and support EDW reporting. ### 39. Data Engineer with 8 years of experience in retail and banking **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** January 14, 2020 **What do you like best about WhereScape RED?** Auto documentation Ease of creating tables and less dependency on DBA Drag and connect functionality UI is good SCD creation **What do you dislike about WhereScape RED?** Track back diagram doesn't look so good and tidy. No code locking mechanism available for developers Prone to table drop issues **Recommendations to others considering WhereScape RED:** It's a lightweight package and can give good results in ELT based environment .Also it's pricing is great **What problems is WhereScape RED solving and how is that benefiting you?** Implemented a data model and created a DWH for providing customer insights and for anlaytics ### 40. Wherescape Red Review **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Gambling & Casinos | Enterprise (> 1000 emp.) **Reviewed Date:** March 24, 2020 **What do you like best about WhereScape RED?** Documentation is automatic. Easy to create objects. many settings can be configured. **What do you dislike about WhereScape RED?** Job scheduler is not very mature. loading large volume of data is challenging. Versioning and security is difficult to implement. **What problems is WhereScape RED solving and how is that benefiting you?** How to load large volumes of data. ### 41. Building data warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Small-Business (50 or fewer emp.) **Reviewed Date:** January 08, 2020 **What do you like best about WhereScape RED?** Easy to use. Cut down lots of time spend on creating SSIS packages while building a data warehouse in a "traditional" way. **What do you dislike about WhereScape RED?** Nothing in my mind to be honest. Maybe the front end can be more modern ish? **Recommendations to others considering WhereScape RED:** Go to their promotional courses and get a chance to play with the tool. **What problems is WhereScape RED solving and how is that benefiting you?** I was building a brand new data warehouse. The immediate benefit was the efficiency of the work. ### 42. performance and easy debugging **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Management Consulting | Enterprise (> 1000 emp.) **Reviewed Date:** December 23, 2019 **What do you like best about WhereScape RED?** at the background converting etl steps to stored procedure **What do you dislike about WhereScape RED?** UI can be better improved and also can include better hadoop connectivity **Recommendations to others considering WhereScape RED:** good product to use overall **What problems is WhereScape RED solving and how is that benefiting you?** ETL load ## WhereScape RED Discussions - [Can we also use this for Integrating with hadoop platform and use it for importing and the data ?](https://www.g2.com/discussions/can-we-also-use-this-for-integrating-with-hadoop-platform-and-use-it-for-importing-and-the-data) - 1 upvote - [View WhereScape RED pricing details and edition comparison](https://www.g2.com/products/wherescape-red/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-13+10%3A30%3A44+-0500&secure%5Bsession_id%5D=ad18d9da-541c-4f6d-8465-58b24f649c46&secure%5Btoken%5D=65f42e15c0c09bb50487bb64b32746de00859179046de7689485412496834a83&format=llm_user) ## WhereScape RED Features **Functionality** - Diverse Extraction Points - Data Structuring - Consolidation - Data Cleaning - Cloud Extraction - Visualization **Management** - Reporting - Auditing **Automation** - Workflow Automation - Multi-platform support - Data Management - Data Simplicity **Functionality** - Extraction - Transformation - Loading - Automation - Scalability **Functionality** - Documentation management - Platform support - Template functionality **Diverse Extraction Points** - Diverse Extraction Points **Administration** - Error Alerts - Service Automation **Agentic AI - Data Warehouse Automation** - Proactive Assistance ## Top WhereScape RED Alternatives - [dbt](https://www.g2.com/products/dbt/reviews) - 4.7/5.0 (204 reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (740 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (687 reviews)