Platform Support
This section describes how AnalyticsCreator integrates with supported target platforms and what it generates for each environment.
AnalyticsCreator is a metadata-driven design application that generates SQL-based data warehouse structures, orchestration artifacts, and semantic models. The generated assets are then deployed and executed on the selected target platform.
Supported Platforms
Microsoft Fabric
Support for Fabric Data Warehouse, Lakehouse SQL endpoints, OneLake, pipelines, and integrated semantic models.
- Warehouse and lakehouse targets
- Pipeline generation
- Semantic model integration
Microsoft Azure / Data Factory
Support for Azure Data Factory orchestration together with Azure SQL and Synapse-based warehouse execution.
- ADF pipeline generation
- Azure SQL and Synapse targets
- Cloud orchestration
SQL Server
Support for SQL Server-based repositories, warehouse generation, and SSIS-based execution.
- On-premise warehouse targets
- SQL and stored procedure generation
- SSIS orchestration
Power BI
Support for semantic model generation including measures, relationships, and analytical structures.
- Tabular models
- Measures and relationships
- Reporting layer
How to Use This Section
Each platform page explains how AnalyticsCreator maps metadata definitions to platform-specific implementations.
- Supported services and runtimes
- Generated SQL, pipelines, and semantic models
- Deployment and execution behavior
- Platform-specific constraints and design considerations
Common Principles Across Platforms
Metadata-driven generation
All structures and logic are generated from metadata definitions.
Platform-side execution
Processing and orchestration run on the target platform.
Consistent modeling approach
Dimensional, Data Vault, and hybrid models are supported across platforms.
Generated deployment assets
SQL objects, pipelines, and semantic models are generated automatically.
Key Differences Between Platforms
- Orchestration: SSIS vs Data Factory vs Fabric pipelines
- Execution environment: on-premise vs cloud vs unified platform
- Storage model: database vs lakehouse vs OneLake
- Integration with semantic layers
Key Takeaway
AnalyticsCreator generates platform-specific warehouse, pipeline, and analytical artifacts from metadata, while execution and runtime behavior are handled by the selected platform.
