Welcome to Astera DW Builder Documentation!

Getting Started

• Astera Data Warehouse Builder 9 – System Requirements
• Installing Client and Server Applications
• Connecting to a Server from the Client
• Building a Cluster Database and Creating a Repository
• Logging in from the Client
• Unlocking With a License Key
• Creating a Data Warehousing Project

Data Models

• Introduction to Data Models
• Opening a New Data Model
• Data Modeler – UI Walkthrough
• Reverse Engineering an Existing Database
• Creating a Data Model from Scratch
• General Entity Properties
• Creating and Editing Entity Relationships
• Forward Engineering
• Verifying a Data Model

Dimensional Modeling

• Introduction to Dimensional Modeling
• Converting a Data Model to a Dimensional Model
• Fact Entities
• Dimension Entities
• Date and Time Dimension
• Verifying a Dimensional Model

Documentation

• Generating Technical and Business Documentation for Data Models

Deployment & Usage

• Deploying a Data Model
• Validate Metadata and Data Integrity
• Using Astera Data Models in ETL Pipelines
• Connecting an Astera Data Model to a Third-Party Visualization Tool

Dataflows

• Introduction to Dataflows
• Data Model Query
• Fact Table Loader
• Dimension Loader

Orchestration and Automation

• Using Workflows for Orchestration
• Using the Job Scheduler for Automation

Use Case

• Building a Data Warehouse – A Step-By-Step Approach