Welcome!

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 us.wherescape.com.

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
SYS-CON Events announced today that DXWorldExpo has been named “Global Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Digital Transformation is the key issue driving the global enterprise IT business. Digital Transformation is most prominent among Global 2000 enterprises and government institutions.
SYS-CON Events announced today that Datera, that offers a radically new data management architecture, has been named "Exhibitor" of SYS-CON's 21st International Cloud Expo ®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Datera is transforming the traditional datacenter model through modern cloud simplicity. The technology industry is at another major inflection point. The rise of mobile, the Internet of Things, data storage and Big...
"Outscale was founded in 2010, is based in France, is a strategic partner to Dassault Systémes and has done quite a bit of work with divisions of Dassault," explained Jackie Funk, Digital Marketing exec at Outscale, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
SYS-CON Events announced today that Calligo has been named “Bronze Sponsor” of SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Calligo is an innovative cloud service provider offering mid-sized companies the highest levels of data privacy. Calligo offers unparalleled application performance guarantees, commercial flexibility and a personalized support service from its globally located cloud platfor...
"At the keynote this morning we spoke about the value proposition of Nutanix, of having a DevOps culture and a mindset, and the business outcomes of achieving agility and scale, which everybody here is trying to accomplish," noted Mark Lavi, DevOps Solution Architect at Nutanix, in this SYS-CON.tv interview at @DevOpsSummit at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"We were founded in 2003 and the way we were founded was about good backup and good disaster recovery for our clients, and for the last 20 years we've been pretty consistent with that," noted Marc Malafronte, Territory Manager at StorageCraft, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"DivvyCloud as a company set out to help customers automate solutions to the most common cloud problems," noted Jeremy Snyder, VP of Business Development at DivvyCloud, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
Kubernetes is an open source system for automating deployment, scaling, and management of containerized applications. Kubernetes was originally built by Google, leveraging years of experience with managing container workloads, and is now a Cloud Native Compute Foundation (CNCF) project. Kubernetes has been widely adopted by the community, supported on all major public and private cloud providers, and is gaining rapid adoption in enterprises. However, Kubernetes may seem intimidating and complex ...
While the focus and objectives of IoT initiatives are many and diverse, they all share a few common attributes, and one of those is the network. Commonly, that network includes the Internet, over which there isn't any real control for performance and availability. Or is there? The current state of the art for Big Data analytics, as applied to network telemetry, offers new opportunities for improving and assuring operational integrity. In his session at @ThingsExpo, Jim Frey, Vice President of S...
"We focus on SAP workloads because they are among the most powerful but somewhat challenging workloads out there to take into public cloud," explained Swen Conrad, CEO of Ocean9, Inc., in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"As we've gone out into the public cloud we've seen that over time we may have lost a few things - we've lost control, we've given up cost to a certain extent, and then security, flexibility," explained Steve Conner, VP of Sales at Cloudistics,in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"DX encompasses the continuing technology revolution, and is addressing society's most important issues throughout the entire $78 trillion 21st-century global economy," said Roger Strukhoff, Conference Chair. "DX World Expo has organized these issues along 10 tracks with more than 150 of the world's top speakers coming to Istanbul to help change the world."
"We provide IoT solutions. We provide the most compatible solutions for many applications. Our solutions are industry agnostic and also protocol agnostic," explained Richard Han, Head of Sales and Marketing and Engineering at Systena America, in this SYS-CON.tv interview at @ThingsExpo, held June 6-8, 2017, at the Javits Center in New York City, NY.
DX World EXPO, LLC., a Lighthouse Point, Florida-based startup trade show producer and the creator of "DXWorldEXPO® - Digital Transformation Conference & Expo" has announced its executive management team. The team is headed by Levent Selamoglu, who has been named CEO. "Now is the time for a truly global DX event, to bring together the leading minds from the technology world in a conversation about Digital Transformation," he said in making the announcement.
"We are focused on SAP running in the clouds, to make this super easy because we believe in the tremendous value of those powerful worlds - SAP and the cloud," explained Frank Stienhans, CTO of Ocean9, Inc., in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.