Automate Azure Synapse
Attend a Virtual Demo Request a Private Consultation

Azure Synapse Analytics Process Automation

WhereScape accelerates the design, build, and deployment of Azure Synapse Analytics data assets.

Delivers Azure Synapse Projects fast

WhereScape automates workflows based on native Azure Synapse services and reference architecture.

speed abstract icon

Increase Developer Productivity

Template-generated Azure Data Factory pipelines, Python and Powershell integration code using native Azure APIs.

wherscape 3d test Iterate abstract icon

Accelerate Azure Adoption

Helps IT teams collaborate more effectively with business users early on in a project to deliver impactful solutions faster.

wherscape red fast track 95 abstract icon

WhereScape Azure Automation Approach and Key Features

  • Built-in design patterns for common modeling methodologies such as 3NF, dimensional and Data Vault 2.0.
  • Configurable templates to align Azure deployments with your chosen architecture standards and coding patterns
  • Migrates existing data models by reverse engineering, converting and redeploying using native Azure templates.
  • Sustainable Architecture allows your Azure implementation to evolve with the underlying platform via templated bulk code upgrades

  • Generates SQL-based ELT code, pushdown optimized for:
    • Synapse SQL pool
    • Azure HDInsight
    • Azure SQL DB
    • Azure SQL Managed Instance
    • Azure PostgreSQL
    • Azure MySQL
    • Snowflake, Exasol, Teradata and other supported platforms
  • Azure Data Lake Storage Gen2 (ADLS) and Blob Store integration
  • Azure DevOps (ADO) pipeline integration for deployments
  • Applies global coding standards, ensuring coding consistency, minimizing implementation risk.

  • Supports iterative design and development to easily solve for differences between business needs and technical capability.
  • Enables rapid prototyping to quickly incorporate collaborative feedback.
  • Supports continuous integration and delivery to easily incorporate changes as business demands evolve.
  • Reduces project risk and improves time to value.
  • Automates documentation @ technical and business-level, removing the burden from developers and providing auditability for future reference.

WhereScape automation for Azure animation from WhereScape on Vimeo.

HUS (The Helsinki Health Authority) chose WhereScape 3D to scope and prototype the ideal architecture before it was built, and WhereScape Data Vault Express to quickly and safely build a Data Vault 2.0 on Microsoft Azure.

– HUS (The Helsinki Health Authority)

Case Study: Punter Southall Provide an Automated Warehouse for Every Client

Case Studies

For most companies, building and maintaining a data warehouse for their own data is already a huge challenge. At PSA, they have to create a bespoke data warehouse for each of their customers.

Learn More

Whitepaper: Sustainable Data Architectures Using Data Warehouse Automation

White Papers

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.

 

Read Now

Combining data from both legacy and new systems, to build conceptual models

Healthcare

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