AnalyticsCreator facilitates a model-driven approach to developing and automating data warehouses specifically for Microsoft SQL Server, Azure SQL, and compatible Microsoft Fabric Warehouse platforms.
Using smart wizards, the tool leverages source metadata and design choices to create customized warehouse models tailored for specific projects. Throughout the development process, core components such as business definitions, relationships, transformation logic, and implementation code remain interconnected.
The platform produces native SQL structures, views, stored procedures, historisation, and snapshot logic, along with DACPAC deployment packages and suitable loading and orchestration artifacts.
Additionally, built-in testing functionality allows for a comparison between actual processing outcomes and predefined expectations, ensuring thorough validation prior to deployment. The solutions generated can operate seamlessly within the chosen Microsoft environment without the necessity of an AnalyticsCreator production runtime.