Portland, OR -- December 16, 2015 -- WhereScape, the data warehouse automation pioneer with software solutions for profiling, building, extending and managing data warehouses, analytic systems and big data platforms, announced today the publication of a WhereScape Product Profile and Evaluation by Wayne Eckerson, founder and principal consultant of Eckerson Group, a leading research and consulting firm.
"Unlike most other data warehouse automation tools, WhereScape is a data-driven development environment," Eckerson writes in the report. "WhereScape doesn't contain a separate modeling tool to create conceptual or logical models. Rather, WhereScape developers start the design process by first importing external data and then modeling the data from there.
"Data-driven data warehouse automation tools, such as WhereScape RED, step developers through the process of creating facts, dimensions, hierarchies, surrogate keys, and indexes, among other things," Eckerson wrote. "In essence, a data-driven data warehouse automation tool develops a data warehouse at a physical level and generates all the SQL."
Eckerson writes that WhereScape "uses an ELT approach that relies on the underlying data warehouse database to do the heavy-lifting required to load, build and maintain the environment" and is "ideal for automating the creation and management of data marts for an existing data warehouse."
Eckerson also recognized WhereScape for its ability to "produce business and technical documentation that enables users to explore data warehouse designs, dictionaries, process dependencies and end-user objects. The report also singled out WhereScape for its broad platform support. "WhereScape supports the largest number of target databases of any data warehouse automation vendor, including Teradata, Oracle, SQL Server, Microsoft Analytics Platform System, DB2, Greenplum and Netezza, as well as some cloud databases."
Click here to download a copy of the WhereScape Product Profile and Evaluation. To learn more about WhereScape's data warehouse automation solutions, watch this Eckerson Group One-on-One webinar featuring Eckerson and WhereScape President Mark Budzinski. Eckerson and Budzinski define data warehouse automation, present its benefits and use cases, and Budzinski provides case studies from several WhereScape customers.
WhereScape is the data warehouse automation pioneer. 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.
More than 700 customers use WhereScape’s products to build data warehouses with fewer people, fewer diversions, missed deadlines or unmet user expectations, and in days or weeks, instead of months or years. WhereScape has global operations in the USA, UK, Singapore, and New Zealand. For more information, please visit www.wherescape.com.
All products or company names herein may be trademarks of their respective owners.