Automate Azure Synapse

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.

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)