Welcome to AnalyticsCreator Docs

Deliver Governed Data Products at Scale

AnalyticsCreator combines data modeling, historization, CI/CD, lineage, and documentation into a single platform — enabling data teams to build, automate, and govern analytics with confidence.

Everything you need to build, automate, and ship governed data products with AnalyticsCreator — from modeling and historization to CI/CD and documentation generation. Use the search above or jump into a category below.

Pro Tip:

Every page in these docs mirrors the product’s UI and terminology — so you can follow along in AnalyticsCreator without switching context.

Quick Start

Explore by Category

Getting Started

Welcome to the AnalyticsCreator Documentation. In this Getting Started section, you can choose from the following sections: Installation System Requirements Download and Installation Understanding AnalyticsCreator

Using AnalyticsCreator

You can launch AnalyticsCreator in two ways: From the desktop icon After installation or streaming setup, a desktop shortcut is created. Double-click the icon to start AnalyticsCreator. From the installer window Open the downloaded AnalyticsCreator installer. Instead of selecting Install, click Launch (labeled as Number One in the image below). A window will appear showing the available AnalyticsCreator Servers, which deliver the latest version to your system. This process launches AnalyticsCreator without performing a full installation, assuming all necessary prerequisites are already in place.

Reference

AnalyticsCreator Reference guide The AnalyticsCreator is the central storage location for all metadata related to your data warehouse projects. It serves as the foundation for organizing and managing the various elements of a data warehouse, ensuring consistency, scalability, and efficient collaboration across teams. What is the AnalyticsCreator Repository? The repository stores all Data Warehouse Project metadata information, including details about data sources, transformations, layers, and configurations. It is designed to act as a centralized structure where users can: Define and manage data warehouse artifacts. Configure and store database objects and workflows. Organize elements into logical folders for better accessibility. While the repository encompasses all metadata, not every item within it needs to be actively used, allowing flexibility in managing large and complex projects. Repository Structure The repository is organized into folders, with each folder representing a specific Data Warehouse artifact or database object. These objects include but are not limited to: Connectors: Configurations for connecting to external data sources like MSSQL, Oracle, or SAP. Layers: Hierarchical structures for organizing data, such as staging, core, and data marts. Packages: Collections of related objects or configurations for deployment. Indexes: Structures to improve query performance by optimizing data retrieval. Roles: Access controls and permissions for users interacting with the data warehouse. Galaxies, Hierarchies, Partitions, and Parameters: Components used in data modeling to define relationships, subsets, and configurations. Macros and Scripts: Reusable logic and code snippets for data transformations and operations. Object Scripts: Scripts tied to specific data objects for precise customizations. Filters: Tools for selecting or excluding specific data based on defined conditions. Predefined Transformations: Built-in processes to streamline common data processing tasks. Snapshots: Static copies or versions of data at specific points in time for auditing or rollback purposes. Deployments: Configurations and workflows for deploying changes to the data warehouse. Groups: Logical groupings of related objects or users for better management. Models: Representations of the structure and relationships within the data warehouse. Types of Repositories AnalyticsCreator supports three types of repositories, offering flexibility in storage and collaboration: SQL Server Repository Stored in Microsoft SQL Server databases. Ideal for centralized storage and multi-user collaboration in larger projects. Local File Repository Stored locally on your system. Suitable for individual users or small-scale projects requiring minimal setup. AnalyticsCreator Cloud Repository A cloud-based storage solution. Enables seamless collaboration and remote access, making it ideal for distributed teams. Both the SQL Server Repository and Cloud Repository are essentially Microsoft SQL Server databases with a predefined schema to store all AnalyticsCreator metadata. No additional software is required for setup. Key Benefits of the Repository Centralized Management All metadata is stored in one location, ensuring consistency and reducing redundancy. Scalability Supports projects of all sizes, from small, local setups to large, multi-user cloud environments. Flexibility Allows users to organize, customize, and manage artifacts based on project requirements. Collaboration With SQL Server or Cloud repositories, teams can work collaboratively on shared projects. Best Practices for Using the Repository Organize Folders: Group objects logically to reflect the structure and purpose of your data warehouse. Use Appropriate Types: Select the repository type that best suits your project scale and team collaboration needs. Regular Backups: For SQL Server and local repositories, ensure regular backups to prevent data loss. Optimize Performance: Use indexes, filters, and partitions effectively to manage large datasets efficiently. Version Control: Keep track of changes and maintain versioning to facilitate rollback if necessary. The AnalyticsCreator Repository is a robust and versatile solution for managing metadata, enabling you to build scalable and efficient data warehouses. Its flexibility across storage types and comprehensive feature set make it a cornerstone of AnalyticsCreator's functionality. Let me know if you'd like further enhancements!

Tutorials

To become familiar with AnalyticsCreator, we have made certain data sets available. You may use these to test AnalyticsCreator: Click here for the Northwind Data Warehouse

Functions & Features

Ger started by clicking on one of these sections: Main Functionality GUI Process support Data Sources Export Functionality Use of Analytics Frontends

Data Warehouse

Data Warehouse Navigation Repository Feature Right-Click Options Data Warehouse Refresh, DWH Wizard Connectors Refresh, List connectors, Add connector, Import connector from file, Import connector from cloud Layers Packages List packages, Generate packages Packages Import Refresh, List packages, Add import package Packages Historization Refresh, List packages, Add historization package Packages Persisting Refresh, List packages, Add persisting package Packages External Refresh, List packages, Add external package Packages Script Refresh, List packages, Add script package Packages Export Refresh, List packages, Add export package Packages Workflow Refresh, List packages, Add workflow package Indexes Refresh, List indexes, Add index Roles Refresh, List roles, Add role Galaxies Refresh, List galaxies Hierarchies Refresh, List hierarchies, Add hierarchy Partitions Refresh, List partitions, Add partition Parameters Refresh, List Parameters Macros Refresh, List macros, Add macro, Import macro from file, Import macro from cloud Scripts Refresh, Import script from file, Import script from cloud Scripts Pre-creation scripts Refresh, List pre-creation scripts, Add pre-creation script Scripts Post-creation scripts Refresh, List post-creation scripts, Add post-creation script Scripts Pre-deployment scripts Refresh, List pre-deployment scripts, Add pre-deployment script Scripts Post-deployment scripts Refresh, List post-deployment scripts, Add post-deployment script Scripts Pre-workflow scripts Refresh, List pre-workflow scripts, Add pre-workflow script Scripts Post-workflow scripts Refresh, List post-workflow scripts, Add post-workflow script Scripts Repository extension scripts Refresh, List repository extension scripts, Add repository extension script, Run repository extension scrips Object scripts Refresh, List object scripts, Add object script Filters Refresh, Store current filter Predefined transformations Refresh, List predefined transformations, Add predefined transformation Snapshots Refresh, List snapshots, Add snapshot Snapshots Snapshot groups Refresh, List snapshot groups, Add snapshot group Deployments Refresh, List deployments, Add deployment Groups Refresh, List groups, Add group Models Refresh, List models, Add model, Import model from file, Import model from cloud