Platform Support
This section describes how AnalyticsCreator works with supported Microsoft data and analytical technologies and what it generates for each environment.
AnalyticsCreator turns a governed metadata-driven design into native data warehouse, orchestration, deployment, and analytical artefacts. The generated assets are deployed to and operated within the customer's Microsoft environment without requiring an AnalyticsCreator production runtime.
Supported Technologies
Microsoft SQL Server
Generate native SQL Server data warehouse structures, processing logic, deployment artefacts, and Microsoft analytical outputs from the metadata-driven design.
- Tables, views, and stored procedures
- Historisation, persistence, and snapshot processing
- DACPAC generation
- SSIS orchestration
- SSAS analytical models
Related technologies
Microsoft Azure
Support Azure-based data engineering architectures with generated Azure Data Factory orchestration alongside native data warehouse and analytical artefacts for supported Microsoft targets.
- Azure Data Factory integration
- Generated pipeline orchestration
- Source ingestion and processing workflows
- Integration with supported Microsoft targets
Related technology
Microsoft Fabric
Generate native warehouse, pipeline, and analytical artefacts for supported Microsoft Fabric architectures from the governed AnalyticsCreator design.
- Microsoft Fabric Warehouse
- Fabric Data Pipelines
- OneLake-based storage context
- Power BI semantic models
- Direct Lake scenarios where supported
Microsoft Power BI
Generate native Power BI semantic model artefacts from the same governed analytical design used for the wider data solution.
- Power BI semantic models
- Power BI Desktop Projects (PBIP)
- Tabular Model Definition Language (TMDL)
- XMLA-based deployment
- Relationships, measures, and hierarchies
Technology-specific Support
Some Microsoft technologies have dedicated pages because AnalyticsCreator generates substantial technology-specific artefacts for them.
Azure Data Factory
Generated pipelines, datasets, linked service definitions, and dependency-based orchestration for supported Azure data engineering workflows.
SSIS
Generated SSIS packages for source ingestion, data warehouse processing, historisation, persistence, and workflow orchestration.
SSAS
Generated SSAS Tabular and Multidimensional analytical models based on the governed AnalyticsCreator design.
How to Use This Section
Each page explains the role of the Microsoft technology within an AnalyticsCreator-generated solution and distinguishes between what AnalyticsCreator designs and generates and what the target technology executes.
The pages cover:
- Supported services and components
- Artefacts generated by AnalyticsCreator
- Deployment and execution responsibilities
- CI/CD and version-control considerations
- Relevant connectors and source systems
- Prerequisites and technology-specific limitations
- Common implementation scenarios
Common Principles
Model-driven design
Mappings, transformations, structures, and processing dependencies are defined through AnalyticsCreator metadata.
Native Microsoft artefacts
AnalyticsCreator generates native artefacts for the supported Microsoft technologies rather than introducing a proprietary production format.
Target-side execution
Generated workloads are executed by SQL Server, SSIS, Azure Data Factory, Microsoft Fabric, Analysis Services, Power BI, or the relevant target technology.
No AnalyticsCreator runtime
Deployed solutions do not require AnalyticsCreator to remain running in the production environment.
Source-controlled delivery
Project definitions and supported generated artefacts can participate in version-control and CI/CD processes.
Technology-specific generation
AnalyticsCreator generates artefacts appropriate to the selected target rather than applying the same physical implementation to every Microsoft technology.
Choosing the Relevant Documentation
Start with the page for the primary technology you are implementing:
- SQL Server for SQL Server data warehouse generation and the wider SQL Server architecture
- Microsoft Azure for Azure-based architectures using Azure Data Factory orchestration
- Microsoft Fabric for supported Fabric Warehouse, pipeline, OneLake, and analytical scenarios
- Power BI for semantic model, PBIP, TMDL, and XMLA generation
Use the Azure Data Factory, SSIS, and SSAS pages when you need implementation details for those specific technologies.
Key Takeaway
AnalyticsCreator turns a governed metadata-driven design into native artefacts for supported Microsoft data and analytical technologies. The generated assets are deployed to and operated within the customer's Microsoft environment, while AnalyticsCreator remains the design and generation application rather than a production runtime.
