4.6 out of 5 stars
(46 Ratings)
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 about AnalyticsCreator
4.7 out of 5 stars
(64 Ratings)
Semarchy Data Platform (SDP) is an integrated data management solution designed to help organizations create, govern, and distribute reliable enterprise data across operational and analytical environments. The platform consolidates master data management, data integration, data quality monitoring, and governance capabilities within a unified architecture. Its Data Product approach groups related entities, transformation rules, pipelines, APIs, and semantic models into reusable assets with clearly assigned ownership. Each Data Product includes self-describing metadata and a versioned lifecycle that supports consistent development, maintenance, and deployment. SDP enables development teams to design data structures and workflows using Visual Studio Code while managing changes through Git repositories. Built-in DataOps capabilities support automated testing, continuous integration, continuous deployment, and rollback processes to improve release management. AI-assisted tools accelerate data modeling and rule configuration, reducing the manual effort involved in building enterprise data solutions. Governance features such as data lineage, role-based access controls, and quality policies help organizations maintain consistency, transparency, and accountability across their data assets. With SaaS, self-managed, and Snowflake-native deployment options, Semarchy Data Platform allows businesses to streamline their data infrastructure and deliver trusted information to downstream systems, applications, and analytics teams.
Learn more about Semarchy Data Platform (SDP)
IRI Data Manager
The IRI Data Manager suite from IRI, The CoSort Company, provides all the tools you need to speed up data manipulation and movement.
IRI CoSort handles big data processing tasks like DW ETL and BI/analytics. It also supports DB loads, sort/merge utility migrations (downsizing), and other data processing heavy lifts.
IRI Fast Extract (FACT) is the only tool that you need to unload large databases quickly (VLDB) for DW ETL, reorg, and archival.
IRI NextForm speeds up file and table migrations, and also supports data replication, data reformatting, and data federation.
IRI RowGen generates referentially and structurally correct test data in files, tables, and reports, and also includes DB subsetting (and masking) capabilities for test environments.
All of these products can be licensed standalone for perpetual use, share a common Eclipse job design IDE, and are also supported in IRI Voracity (data management platform) subscriptions.
Learn more about IRI Data Manager
AWS Glue
AWS Glue is a fully managed data integration solution that simplifies the process of discovering, preparing, and merging data for purposes such as analytics, machine learning, and application development. By offering all the necessary tools for data integration, AWS Glue enables users to begin analyzing their data and leveraging it for insights within minutes rather than taking months. The concept of data integration encompasses various activities like identifying and extracting data from multiple sources, enhancing, cleaning, normalizing, and consolidating that data, as well as organizing and loading it into databases, data warehouses, and data lakes. Different users, each utilizing various tools, often manage these tasks. Operating within a serverless environment, AWS Glue eliminates the need for infrastructure management, automatically provisioning, configuring, and scaling the resources essential for executing data integration jobs. This efficiency allows organizations to focus more on data-driven decision-making without the overhead of manual resource management.
Learn more about AWS Glue