AnalyticsCreator
Accelerate your data journey with AnalyticsCreator—a metadata-driven data warehouse automation solution purpose-built for the Microsoft data ecosystem. AnalyticsCreator simplifies the design, development, and deployment of modern data architectures, including dimensional models, data marts, data vaults, or blended modeling approaches tailored to your business needs.
Seamlessly integrate with Microsoft SQL Server, Azure Synapse Analytics, Microsoft Fabric (including OneLake and SQL Endpoint Lakehouse environments), and Power BI. AnalyticsCreator automates ELT pipeline creation, data modeling, historization, and semantic layer generation—helping reduce tool sprawl and minimizing manual SQL coding.
Designed to support CI/CD pipelines, AnalyticsCreator connects easily with Azure DevOps and GitHub for version-controlled deployments across development, test, and production environments. This ensures faster, error-free releases while maintaining governance and control across your entire data engineering workflow.
Key features include automated documentation, end-to-end data lineage tracking, and adaptive schema evolution—enabling teams to manage change, reduce risk, and maintain auditability at scale. AnalyticsCreator empowers agile data engineering by enabling rapid prototyping and production-grade deployments for Microsoft-centric data initiatives.
By eliminating repetitive manual tasks and deployment risks, AnalyticsCreator allows your team to focus on delivering actionable business insights—accelerating time-to-value for your data products and analytics initiatives.
Learn more
dbt
dbt Labs is redefining how data teams work with SQL. Instead of waiting on complex ETL processes, dbt lets data analysts and data engineers build production-ready transformations directly in the warehouse, using code, version control, and CI/CD. This community-driven approach puts power back in the hands of practitioners while maintaining governance and scalability for enterprise use.
With a rapidly growing open-source community and an enterprise-grade cloud platform, dbt is at the heart of the modern data stack. It’s the go-to solution for teams who want faster analytics, higher quality data, and the confidence that comes from transparent, testable transformations.
Learn more
MANTA
Manta is a unified data lineage platform that serves as the central hub of all enterprise data flows.
Manta can construct lineage from report definitions, custom SQL code, and ETL workflows. Lineage is analyzed based on actual code, and both direct and indirect flows can be visualized on the map. Data paths between files, report fields, database tables, and individual columns are displayed to users in an intuitive user interface, enabling teams to understand data flows in context.
Learn more
SQLFlow
SQLFlow offers a comprehensive visual overview of data flow through various systems. It automates the analysis of SQL data lineage across a multitude of platforms, including databases, ETL processes, business intelligence tools, and environments like cloud and Hadoop, by effectively parsing SQL scripts and stored procedures. The tool graphically illustrates all data movements, supporting over 20 leading databases and continuously expanding its capabilities. It allows for automation in lineage construction regardless of the SQL's location, whether in databases, file systems, or repositories such as GitHub and Bitbucket. The user-friendly interface ensures that data flows are presented in a clear and easily understandable manner. By providing complete visibility into your business intelligence environment, it aids in pinpointing the root causes of reporting errors, fostering invaluable confidence in business processes. Additionally, it streamlines regulatory compliance efforts, while the visualization of data lineage enhances transparency and auditability. Users can conduct impact analysis at a detailed level, enabling a thorough examination of lineage down to tables, columns, and queries. With SQLFlow, you can seamlessly integrate powerful data lineage analysis capabilities into your product, thereby elevating your data management strategy. This tool not only simplifies complex tasks but also empowers teams to make informed decisions based on reliable insights.
Learn more