WhereScape STAR is a feature-rich, affordable platform that accelerates the design, development, deployment, and operation of SQL Server data warehouses, data marts, or other structures for reporting and analytics.
Built upon 20 years of technological advancements, WhereScape STAR is designed for organizations that depend upon data-driven decisions and have invested in the powerful database and reporting technologies available from Microsoft. Regardless of whether they utilize on-premise SQL Server or cloud-based Azure, data automation from WhereScape accelerates the delivery of information and streamlines IT services.
Code generation and automation are the fastest way to get the information you need to answer business questions, and we don’t believe that a lack of skills, resources, or budget should prevent anyone from accelerating the journey from data to knowledge. WhereScape STAR supports:
WhereScape STAR handles ALL the technicalities associated with extracting, loading, and transforming your data into meaningful insights.
WhereScape STAR is a data automation solution designed specifically for organizations that leverage Microsoft SQL Server / Azure SQL Server databases. It generates all the SSIS and SQL Stored Procedure ETL code required to load source data into SQL Server - whether using a star schema or your own modeling style - so instead of spending time writing complex business logic, you can focus on transforming and formatting information while leaving generation (and deployment) up-to us!
It also automatically generates documentation, which is incredibly powerful both from a compliance perspective but also because it allows your report writers and users to see the definitions and full lineage of all the data available in SQL Server and choose whether to query it using PowerBI and other tools or have WhereScape generate SSIS code to export data to CSV files.
The ability to regenerate code to reflect changes in data structures/business logic with multi-user check-in/check-out, version control, and automated deployments, no matter how large your team, WhereScape enables delivery to production fast and often.
– Eric Tengs, Senior Analytics Consultant
Microsoft SQL Server Integration Services (SSIS) and WhereScape RED are very different products, but both can be used to build a data warehouse and can provide high performance. This paper describes the strengths of each product and the best path to take.Learn More
This whitepaper by eminent data expert Rick van der Lans outlines the need for sustainable data architectures, describes how to design and build them and explains how they increase both productivity and business agility.
HUS (The Helsinki Health Authority) - the biggest health care provider and the second-largest employer in Finland, with over 25k staff treating over 500k patients per year - depend upon WhereScape for Big Data success on Azure.Learn More