SAN DIEGO, CA. (BUSINESS WIRE)--WhereScape, a provider of automation software for modeling, building and extending data warehouses and analytic systems, announced today a new release of WhereScape RED, the company’s flagship automation software that is optimized to fully leverage the massively parallel processing (MPP) power of the Microsoft Analytics Platform System. Available immediately, WhereScape RED for Analytics Platform System requires fewer resources to model, build and deploy a data warehouse or analytic system, creating a simplified infrastructure and dramatically reducing total cost of ownership.
The Microsoft Analytics Platform System is a turnkey big data analytics appliance, combining Microsoft’s massively parallel processing (MPP) data warehouse technology–the SQL Server Parallel Data Warehouse –together with Microsoft Azure HDInsight, Microsoft’s 100 percent Apache Hadoop distribution, and delivering it as a turnkey appliance.
WhereScape RED builds native database objects optimized for Analytics Platform System, as well as target database platforms such as SQL Server, Oracle and Teradata, and 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.
“Organizations are struggling to integrate conventional data sources and big data into purpose-built platforms for enterprise data warehousing and advanced analytics,” said John Myers, Managing Research Director for Enterprise Management Associates (EMA). “WhereScape RED is well suited to enhance Microsoft APS, enabling organizations to effectively manage their hybrid data ecosystems consisting of both traditional RDMBS, Hadoop, and other big data sources” Myers said.
WhereScape RED for Microsoft Analytics Platform System Highlights
- Optimized code generation automatically applies APS best practices
- Eliminates hand coding through intuitive, easy-to-use GUI
- Integrated version and source control
- Import data from any source
- Manage APS tables directly, including distribution
- Quickly create and populate dimensions and facts
- Handle late-arriving data seamlessly
- Manage surrogate and foreign keys automatically