Data Warehouse Builder
Home · Centerprise · ReportMiner · EDIConnect · Data Virtualization

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
Data Warehouse Builder
  • »
  • Welcome to Astera DW Builder Documentation!

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

© Copyright 2019, Astera Software

Versions & Downloads v: latest
Versions
latest
Downloads
On Read the Docs
Project Home
Builds