Click here to close now.


News Feed Item

WhereScape Introduces New Release of its Data Warehouse Automation Software Optimized for Pivotal Greenplum Database

WhereScape, a provider of automation software for modeling, building and extending data warehouses and analytic systems, today announced a new release of WhereScape RED, the company’s flagship automation software that is optimized to fully leverage the Pivotal Greenplum massively parallel processing (MPP) Database. Available immediately, WhereScape RED for Greenplum accelerates time to value for an organization’s Greenplum investment by eliminating hand coding and automating Greenplum development. WhereScape RED for Greenplum requires fewer resources to model, build and deploy a Greenplum data warehouse, creating a simplified infrastructure and dramatically reducing total cost of ownership.

WhereScape RED builds native database objects optimized for Greenplum as well as other analytic appliances such as Netezza and Aster. In addition, RED supports target database platforms such as Teradata, SQL Server, DB2 and Oracle. As an ELT engine, RED can extract data from OLTP systems, flat files and big data platforms such as Hadoop Hive.

WhereScape RED enables practitioners to access source data from multiple environments, create procedural code, scripts, and tables, build cubes, schedule updates, and generate documentation in HTML format, all while maintaining existing BI front-end compatibility.

“Database appliances such as Greenplum have gained tremendous traction in the marketplace as more and more IT organizations are using purpose-built platforms for enterprise data warehousing and advanced analytic tasks,” said Shawn Rogers, Vice President of Research, Business Intelligence and Data Warehousing, Enterprise Management Associates. “WhereScape RED is ideally suited for today’s highly diverse, special-purpose IT infrastructures, enabling organizations to manage their extended data ecosystems.”

Union Bank Using WhereScape to Build Greenplum Data Warehouse
Union Bank, a full-service commercial bank with almost 400 locations, is using WhereScape RED for Greenplum to automate the development of its new Greenplum-based enterprise data warehouse. The Greenplum implementation is the bank’s main focus. However it is also pursuing a parallel development track designed to address an immediate business requirement that is focused on developing a consumer-lending departmental reporting system based on Microsoft Corp.'s SQL Server.

“Our results using WhereScape have been extremely impressive,” said Ryan Fenner, Vice President, Data Solutions Architect, Union Bank. “WhereScape RED enabled us to design, develop, document and deploy a production-ready SQL-Server-based reporting solution in eight weeks that solved a critical and immediate business need. Using traditional data warehouse development methods would have taken us six to eight months.”

Fenner added that Union Bank will use WhereScape RED for Greenplum to migrate the consumer lending reporting system to its Greenplum data warehouse when the time is right. “We view our departmental reporting solution as an interim approach that fits in very well with our strategic direction,” Fenner said. “We built something that solved an immediate business need and which can easily be migrated at very low cost into the Greenplum enterprise data warehouse with minimal additional effort. WhereScape provides a very powerful, repeatable, low-cost way to develop in parallel and with agility.”

“A growing number of our customers and prospects are developing and deploying across a multi-tiered data warehouse infrastructure,” added WhereScape USA President Mark Budzinski. “We are committed to providing Greenplum customers a seamless, end-to-end experience for quickly developing their data warehouse infrastructure as well as to help maximize their use of it. WhereScape RED helps accelerate the development of data warehouses and enables organizations to benefit from them in less time, with less money, while mitigating risk resulting in fully documented implementations.”

WhereScape Knows Greenplum
WhereScape RED “knows” all Greenplum objects—including views, distribution keys and append-only tables, and utilizes Greenplum’s rich feature set to build native Greenplum objects, document them and schedule data to be loaded. RED’s open metadata architecture is stored in database tables for easy access, and integrates with external testing and source control tools.

WhereScape RED works seamlessly as an ELT (extract, load and transformation) using the Greenplum GPLOAD bulk load utility, the fast method for loading data into Greenplum. WhereScape RED generates Greenplum-specific procedural code for data movement and transformation and also supports Microsoft SSIS or ODBC to help integrate data into a single environment. WhereScape RED’s integrated scheduler provides a single point of management for your entire Greenplum data warehouse platform, supporting restart after failure and full error and audit logging.

WhereScape RED for Greenplum Highlights
Optimized code generation automatically applies Greenplum best practices

  • Eliminates hand coding through intuitive, easy-to-use GUI
  • Integrated version and source control
  • Import data from any source using GPLOAD, ODBC or SSIS
  • Manage Greenplum tables directly, including distribution and partitioning
  • Quickly create and populate dimensions and facts
  • Handle late-arriving data seamlessly
  • Manage surrogate and foreign keys automatically

About WhereScape
WhereScape designs, develops, sells and supports WhereScape 3D, the industry’s first data warehouse discovery tool; and WhereScape RED, the industry’s first and best integrated development environment for building, deploying, managing and renovating data warehouses and analytic systems. WhereScape’s products are used in every kind of today’s commercial environment: from normal-form enterprise data warehouses and data vaults, through user access layers and tiers of dependent data marts, to standalone data marts and reporting systems.

Our more than 650 customers are active and satisfied users of our technologies, and report that, with WhereScape’s products, they are able to build data warehouses with fewer people, few if any diversions, missed deadlines or unmet user expectations, and in record time: in days or weeks, instead of months or years. WhereScape has offices in Portland, Oregon; Auckland, New Zealand; and Reading, UK. For more information, please visit

All products or company names herein may be trademarks of their respective owners.

More Stories By Business Wire

Copyright © 2009 Business Wire. All rights reserved. Republication or redistribution of Business Wire content is expressly prohibited without the prior written consent of Business Wire. Business Wire shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon.

Latest Stories
Recently announced Azure Data Lake addresses the big data 3V challenges; volume, velocity and variety. It is one more storage feature in addition to blobs and SQL Azure database. Azure Data Lake (should have been Azure Data Ocean IMHO) is really omnipotent. Just look at the key capabilities of Azure Data Lake:
Scott Guthrie's keynote presentation "Journey to the intelligent cloud" is a must view video. This is from AzureCon 2015, September 29, 2015 I have reproduced some screen shots in case you are unable to view this long video for one reason or another. One of the highlights is 3 datacenters coming on line in India.
SYS-CON Events announced today that G2G3 will exhibit at SYS-CON's @DevOpsSummit Silicon Valley, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Based on a collective appreciation for user experience, design, and technology, G2G3 is uniquely qualified and motivated to redefine how organizations and people engage in an increasingly digital world.
In his session at @ThingsExpo, Tony Shan, Chief Architect at CTS, will explore the synergy of Big Data and IoT. First he will take a closer look at the Internet of Things and Big Data individually, in terms of what, which, why, where, when, who, how and how much. Then he will explore the relationship between IoT and Big Data. Specifically, he will drill down to how the 4Vs aspects intersect with IoT: Volume, Variety, Velocity and Value. In turn, Tony will analyze how the key components of IoT ...
Data loss happens, even in the cloud. In fact, if your company has adopted a cloud application in the past three years, data loss has probably happened, whether you know it or not. In his session at 17th Cloud Expo, Bryan Forrester, Senior Vice President of Sales at eFolder, will present how common and costly cloud application data loss is and what measures you can take to protect your organization from data loss.
According to Forrester, public cloud platforms are evolving, blurring the lines between Software as a Service (SaaS), Infrastructure as a Service (IaaS), and Platform as a Service (PaaS) in order to satisfy the needs of enterprises and widen their appeal to developers. In The Forrester Wave™: Enterprise Public Cloud Platforms, Q4 2014, Forrester evaluates the 16 most significant Enterprise Public Cloud Platforms and details how each vendor fulfills the 19 evaluation criteria points.
The broad selection of hardware, the rapid evolution of operating systems and the time-to-market for mobile apps has been so rapid that new challenges for developers and engineers arise every day. Security, testing, hosting, and other metrics have to be considered through the process. In his session at Big Data Expo, Walter Maguire, Chief Field Technologist, HP Big Data Group, at Hewlett-Packard, will discuss the challenges faced by developers and a composite Big Data applications builder, foc...
The cloud has reached mainstream IT. Those 18.7 million data centers out there (server closets to corporate data centers to colocation deployments) are moving to the cloud. In his session at 17th Cloud Expo, Achim Weiss, CEO & co-founder of ProfitBricks, will share how two companies – one in the U.S. and one in Germany – are achieving their goals with cloud infrastructure. More than a case study, he will share the details of how they prioritized their cloud computing infrastructure deployments ...
Interested in leveraging automation technologies and a cloud architecture to make developers more productive? Learn how PaaS can benefit your organization to help you streamline your application development, allow you to use existing infrastructure and improve operational efficiencies. Begin charting your path to PaaS with OpenShift Enterprise.
Decisions about budgets and resources are often made without IT even having a seat at the table. As technologist we understand the value of DevOps - but do your business counterparts? If they don't, your DevOps initiatives could lose funding before they start. In her session at DevOps Summit, Jeanne Morain, Strategist / Author at iSpeak Cloud, LLC, will provide insights on how to bridge the gap between business and technology leaders. Attendees will learn prescriptive guidance on balancing wor...
The modern software development landscape consists of best practices and tools that allow teams to deliver software in a near-continuous manner. By adopting a culture of automation, measurement and sharing, the time to ship code has been greatly reduced, allowing for shorter release cycles and quicker feedback from customers and users. Still, with all of these tools and methods, how can teams stay on top of what is taking place across their infrastructure and codebase? Hopping between services a...
SYS-CON Events announced today that Secure Infrastructure & Services will exhibit at SYS-CON's 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Secure Infrastructure & Services (SIAS) is a managed services provider of cloud computing solutions for the IBM Power Systems market. The company helps mid-market firms built on IBM hardware platforms to deploy new levels of reliable and cost-effective computing and hig...
When it comes to IoT in the enterprise, namely the commercial building and hospitality markets, a benefit not getting the attention it deserves is energy efficiency, and IoT’s direct impact on a cleaner, greener environment when installed in smart buildings. Until now clean technology was offered piecemeal and led with point solutions that require significant systems integration to orchestrate and deploy. There didn't exist a 'top down' approach that can manage and monitor the way a Smart Buildi...
SYS-CON Events announced today that IBM Cloud Data Services has been named “Bronze Sponsor” of SYS-CON's 17th Cloud Expo, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. IBM Cloud Data Services offers a portfolio of integrated, best-of-breed cloud data services for developers focused on mobile computing and analytics use cases.
Today, we are in the middle of a paradigm shift as we move from managing applications on VMs and containers to embracing everything that the cloud and XaaS (Everything as a Service) has to offer. In his session at 17th Cloud Expo, Kevin Hoffman, Advisory Solutions Architect at Pivotal Cloud Foundry, will provide an overview of 12-factor apps and migrating enterprise apps to the cloud. Kevin Hoffman is an Advisory Solutions Architect for Pivotal Cloud Foundry, and has spent the past 20 years b...