Data warehousing provider WhereScape has launched a new release of WhereScape RED, the company’s flagship automation software.
According to the Auckland-based firm, the update is optimised to fully leverage the massively parallel processing (MPP) power of the Microsoft Analytics Platform System.
Available immediately, WhereScape RED for Analytics Platform System is designed around requiring fewer resources to model build and deploy a data warehouse or analytic system.
“A growing number of our customers are developing and deploying across a diverse, multi-tiered data warehouse infrastructure consisting of traditional databases and the myriad of new big data sources—including Hadoop - that are prevalent today,” says Mark Budzinski, USA President, WhereScape.
Budzinski says the Microsoft Analytics Platform System is a “turnkey big data analytics appliance”, combining Microsoft’s 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 optimised 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.
“Microsoft APS was built to scale, integrate with data stored in Hadoop, and deliver the performance that meets near real-time requirements,” adds Tiffany Wissner, Senior Director of Data Platform Marketing, Microsoft.
“WhereScape RED complements APS and SQL Server and will help our customers accelerate their development cycles to get into production faster.”
Budzinski says 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.
WhereScape also develops and markets WhereScape RED for SQL Server, an end-to-end, data warehouse development environment optimised for SQL Server, including support for SQL Server Integration Services and SQL Server Analysis Services,” Budzinski adds.
“A growing number of our customers are developing and deploying across a diverse, multi-tiered data warehouse infrastructure consisting of traditional databases and the myriad of new big data sources - including Hadoop - that are prevalent today.
“We provide APS customers a seamless, end-to-end experience for quickly developing and automating their data warehouse infrastructure as well as help maximise their use of it.
“WhereScape RED enables organisations to benefit from their data warehouse investment in less time and with less money while delivering fully documented implementations.”