News Feed Item
WhereScape Introduces New Release of its Data Warehouse Automation Software Optimized for Pivotal Greenplum Database
|By Business Wire
|May 13, 2014 09:16 AM EDT
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
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
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
WhereScape RED for Greenplum Highlights
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
Quickly create and populate dimensions and facts
Handle late-arriving data seamlessly
Manage surrogate and foreign keys automatically
WhereScape designs, develops, sells and
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
So you think you are a DevOps warrior, huh? Put your money (not really, it’s free) where your metrics are and prove it by taking The Ultimate DevOps Geek Quiz Challenge, sponsored by DevOps Summit. Battle through the set of tough questions created by industry thought leaders to earn your bragging rights and win some cool prizes.
Oct. 24, 2016 01:15 AM EDT Reads: 3,914
DevOps is being widely accepted (if not fully adopted) as essential in enterprise IT. But as Enterprise DevOps gains maturity, expands scope, and increases velocity, the need for data-driven decisions across teams becomes more acute. DevOps teams in any modern business must wrangle the ‘digital exhaust’ from the delivery toolchain, "pervasive" and "cognitive" computing, APIs and services, mobile devices and applications, the Internet of Things, and now even blockchain.
In this power panel at @...
Oct. 24, 2016 01:15 AM EDT Reads: 1,872
SYS-CON Events announced today that SoftNet Solutions will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. SoftNet Solutions specializes in Enterprise Solutions for Hadoop and Big Data. It offers customers the most open, robust, and value-conscious portfolio of solutions, services, and tools for the shortest route to success with Big Data. The unique differentiator is the ability to architect and ...
Oct. 24, 2016 01:00 AM EDT Reads: 770
SYS-CON Events announced today that Super Micro Computer, Inc., a global leader in Embedded and IoT solutions, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 7-9, 2017, at the Javits Center in New York City, NY.
Supermicro (NASDAQ: SMCI), the leading innovator in high-performance, high-efficiency server technology, is a premier provider of advanced server Building Block Solutions® for Data Center, Cloud Computing, Enterprise IT, Hadoop/Big Data, HPC and ...
Oct. 24, 2016 01:00 AM EDT Reads: 3,570
“Media Sponsor” of SYS-CON's 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA.
CloudBerry Backup is a leading cross-platform cloud backup and disaster recovery solution integrated with major public cloud services, such as Amazon Web Services, Microsoft Azure and Google Cloud Platform.
Oct. 24, 2016 12:45 AM EDT Reads: 1,340
In the next forty months – just over three years – businesses will undergo extraordinary changes. The exponential growth of digitization and machine learning will see a step function change in how businesses create value, satisfy customers, and outperform their competition. In the next forty months companies will take the actions that will see them get to the next level of the game called Capitalism. Or they won’t – game over. The winners of today and tomorrow think differently, follow different...
Oct. 24, 2016 12:45 AM EDT Reads: 960
Traditional on-premises data centers have long been the domain of modern data platforms like Apache Hadoop, meaning companies who build their business on public cloud were challenged to run Big Data processing and analytics at scale. But recent advancements in Hadoop performance, security, and most importantly cloud-native integrations, are giving organizations the ability to truly gain value from all their data.
In his session at 19th Cloud Expo, David Tishgart, Director of Product Marketing ...
Oct. 24, 2016 12:45 AM EDT Reads: 2,470
In past @ThingsExpo presentations, Joseph di Paolantonio has explored how various Internet of Things (IoT) and data management and analytics (DMA) solution spaces will come together as sensor analytics ecosystems. This year, in his session at @ThingsExpo, Joseph di Paolantonio from DataArchon, will be adding the numerous Transportation areas, from autonomous vehicles to “Uber for containers.” While IoT data in any one area of Transportation will have a huge impact in that area, combining sensor...
Oct. 24, 2016 12:45 AM EDT Reads: 749
More and more brands have jumped on the IoT bandwagon. We have an excess of wearables – activity trackers, smartwatches, smart glasses and sneakers, and more that track seemingly endless datapoints. However, most consumers have no idea what “IoT” means. Creating more wearables that track data shouldn't be the aim of brands; delivering meaningful, tangible relevance to their users should be.
We're in a period in which the IoT pendulum is still swinging. Initially, it swung toward "smart for smar...
Oct. 24, 2016 12:15 AM EDT Reads: 875
@DevOpsSummit has been named the ‘Top DevOps Influencer' by iTrend.
iTrend processes millions of conversations, tweets, interactions, news articles, press releases, blog posts - and extract meaning form them and analyzes mobile and desktop software platforms used to communicate, various metadata (such as geo location), and automation tools.
In overall placement, @DevOpsSummit ranked as the number one ‘DevOps Influencer' followed by @CloudExpo at third, and @MicroservicesE at 24th.
Oct. 24, 2016 12:00 AM EDT Reads: 3,973
@ThingsExpo has been named the Top 5 Most Influential M2M Brand by Onalytica in the ‘Machine to Machine: Top 100 Influencers and Brands.' Onalytica analyzed the online debate on M2M by looking at over 85,000 tweets to provide the most influential individuals and brands that drive the discussion. According to Onalytica the "analysis showed a very engaged community with a lot of interactive tweets. The M2M discussion seems to be more fragmented and driven by some of the major brands present in the...
Oct. 23, 2016 11:45 PM EDT Reads: 11,350
Effectively SMBs and government programs must address compounded regulatory compliance requirements. The most recent are Controlled Unclassified Information and the EU’s GDPR have Board Level implications. Managing sensitive data protection will likely result in acquisition criteria, demonstration requests and new requirements. Developers, as part of the pre-planning process and the associated supply chain, could benefit from updating their code libraries and design by incorporating changes.
Oct. 23, 2016 11:15 PM EDT Reads: 1,642
Successful digital transformation requires new organizational competencies and capabilities. Research tells us that the biggest impediment to successful transformation is human; consequently, the biggest enabler is a properly skilled and empowered workforce. In the digital age, new individual and collective competencies are required.
In his session at 19th Cloud Expo, Bob Newhouse, CEO and founder of Agilitiv, will draw together recent research and lessons learned from emerging and established ...
Oct. 23, 2016 11:00 PM EDT Reads: 1,270
The best way to leverage your Cloud Expo presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering Cloud Expo and @ThingsExpo will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at Cloud Expo. Product announcements during our show provide your company with the most reach through our targeted audiences.
Oct. 23, 2016 10:30 PM EDT Reads: 4,580
November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA.
Penta Security is a leading vendor for data security solutions, including its encryption solution, D’Amo. By using FPE technology, D’Amo allows for the implementation of encryption technology to sensitive data fields without modification to schema in the database environment. With businesses having their data become increasingly more complicated in their mission-critical applications (such as ERP, CRM, HRM), continued ...
Oct. 23, 2016 09:15 PM EDT Reads: 985