Automation for Azure Synapse Analytics

Azuremigrationmay22

By automating repetitive and time-intensive aspects of data platform development you accelerate the delivery of both new and ongoing cloud data projects.

This frees teams to focus on aspects that require human judgment and engagement with business users, getting more projects delivered and in record time.

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

Azure Automation Approach and Key Features

Azure Synapse Data Automation
Data Automation for Azure Synapse - The fast, native, sustainable way to deliver your cloud data platform.

  • 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)

This site uses cookies in order to improve your website experience. You can learn more here.