
AnalyticsCreator is a metadata-driven design application for data warehouse automation and data product engineering across the Microsoft data stack.
Its Governed Control Model connects business meaning, data structures, transformation rules, dependencies, lineage and technical implementation in one controlled project model. Data teams design the required architecture in AnalyticsCreator, then generate native Microsoft assets from that design.
Generated outputs can include SQL Server objects, SSIS packages, Azure Data Factory pipelines, supported Microsoft Fabric components, deployment artefacts and Power BI semantic models. AnalyticsCreator supports dimensional, 3NF and hybrid modelling approaches together with ingestion, transformations, delta loading, historisation, Slowly Changing Dimensions, snapshots and repeatable data-processing patterns.
Because generated outputs are native Microsoft technology, no AnalyticsCreator runtime is required in production. Organisations retain ownership of the resulting implementation and can integrate generated assets into Git, Azure DevOps and CI/CD workflows.
Lineage, documentation and dependency information remain connected to the design, helping teams understand change impact before regenerating affected assets.
Design Intelligence extends this governed project context into AI-assisted data engineering by providing authorised AI tools and agents with structured access to metadata, lineage, dependencies and design rules.
Typical use cases include enterprise data warehouse development, Microsoft Fabric adoption, SQL Server and SSIS modernisation, governed Power BI delivery and repeatable data product engineering.
Learn more

Cloud SQL is a fully managed relational database service that supports MySQL, PostgreSQL, and SQL Server. It includes rich extensions, configuration flags, and developer ecosystems. Cloud SQL offers $300 in credits for new customers. You won't pay until you upgrade. Reduce maintenance costs by using fully managed MySQL, PostgreSQL, and SQL Server databases. The SRE team provides 24/7 support for reliable and secure services. Data encryption in transit and at rest ensures the highest level of security. Private connectivity with Virtual Private Cloud, user-controlled network access, and firewall protection add an additional layer of safety.
Compliant with SSAE 16, ISO 27001, PCI DSS, and HIPAA, you can trust your data to be protected. Scale your database instances with a single API request, whether you are just testing or need a highly available database in production. Standard connection drivers and integrated migration tools let you create and connect to a database in a matter of minutes.
Transform your database management with AI-driven support in Gemini, currently available in preview on Cloud SQL. It enhances development, optimizes performance, and simplifies fleet management, governance, and migration.
Learn more
TiDB Cloud
A cloud-native distributed HTAP database designed for seamless scaling and immediate analytics as a fully managed service, featuring a serverless tier that allows for the rapid deployment of the HTAP database within seconds. Scale transparently and elastically to hundreds of nodes for essential workloads without needing to modify your business logic. Leverage your existing SQL knowledge while preserving your relational structure and global ACID transactions, effortlessly managing hybrid workloads. The system comes with a powerful built-in analytics engine that enables operational data analysis without the requirement for ETL processes. Expand to hundreds of nodes while ensuring ACID compliance, all without the hassle of sharding or downtime interruptions. Data accuracy is upheld even with simultaneous updates to the same data source, making it reliable for high-demand environments. TiDB’s MySQL compatibility enhances productivity and accelerates your applications' time-to-market, while also facilitating the easy migration of data from current MySQL environments without necessitating code rewrites. This innovative solution streamlines your database management, allowing teams to focus on development rather than infrastructure concerns.
Learn more
Apache Doris
Apache Doris serves as a cutting-edge data warehouse tailored for real-time analytics, enabling exceptionally rapid analysis of data at scale.
It features both push-based micro-batch and pull-based streaming data ingestion that occurs within a second, alongside a storage engine capable of real-time upserts, appends, and pre-aggregation.
With its columnar storage architecture, MPP design, cost-based query optimization, and vectorized execution engine, it is optimized for handling high-concurrency and high-throughput queries efficiently.
Moreover, it allows for federated querying across various data lakes, including Hive, Iceberg, and Hudi, as well as relational databases such as MySQL and PostgreSQL.
Doris supports complex data types like Array, Map, and JSON, and includes a Variant data type that facilitates automatic inference for JSON structures, along with advanced text search capabilities through NGram bloomfilters and inverted indexes.
Its distributed architecture ensures linear scalability and incorporates workload isolation and tiered storage to enhance resource management.
Additionally, it accommodates both shared-nothing clusters and the separation of storage from compute resources, providing flexibility in deployment and management.
Learn more