
AnalyticsCreator is a metadata-driven design application for data warehouse automation and data product engineering across the Microsoft data stack.
At its core is the AnalyticsCreator Governed Control Model, which keeps business meaning, data structures, transformation rules, dependencies and technical implementation connected in one controlled project model. Data teams design the required architecture in AnalyticsCreator, then generate native Microsoft assets from that design.
Generated assets can include SQL Server objects, SSIS packages, Azure Data Factory pipelines, 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.
Changes made in the model can be propagated across dependent project assets, while lineage, documentation and impact analysis remain connected to the underlying design. This helps teams reduce repetitive engineering work, standardise delivery and understand the effect of change before regenerating affected assets.
AnalyticsCreator generates native Microsoft technology rather than requiring a proprietary runtime. Organisations retain ownership of the resulting implementation and can integrate generated assets into existing Git, Azure DevOps and CI/CD processes.
Design Intelligence extends this governed project context into AI-assisted data engineering by giving authorised AI tools and agents 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, SAP-to-Microsoft analytics architectures and repeatable data product engineering.
Learn more
DbVisualizer is a universal database client for anyone who works with data, from solo developers and startups to professional teams managing complex environments, including developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It offers a graphical interface for database development, SQL querying, and data exploration. Key features:
- SQL editor with autocomplete, visual query builders, variables, and execution tools
- AI Assistant for questions, error explanations, and code analysis
- Built-in Git integration for SQL scripts and collaboration
- Customizable layouts, key bindings, and UI themes
- Favorite scripts and database objects for quick access
- Configurable security settings for organizations
Connects to popular databases via JDBC, including MySQL, PostgreSQL, SQL Server, Oracle, Snowflake, SQLite, Cassandra, and BigQuery. Runs on Windows, macOS, and Linux. 7 million downloads, Pro users in 150 countries.
Learn more
ER/Studio Data Architect
ER/Studio Data Architect is a powerful data modeling solution that helps organizations design, document, and optimize data structures across modern platforms. It enables architects and database professionals to build conceptual, logical, and physical data models that connect business definitions with technical implementation, ensuring consistent meaning and reliable analytics.
The platform supports forward and reverse engineering, allowing teams to generate databases from models or reverse engineer existing systems for documentation and improvement. Schema compare and merge tools simplify change management, while visual diagrams make complex data structures easier to understand.
ER/Studio supports platforms including SQL Server, Oracle, PostgreSQL, Snowflake, Databricks, and JSON architectures. Automation tools, impact analysis, and the AI-powered ERbert modeling assistant help accelerate model creation while maintaining structured, scalable data architecture.
Learn more