Data Warehousing Features & Capabilities | Data Modeling Tools | ETL/ELT Tools | DW Automation Tool | Astera DW Builder |
|---|---|---|---|---|
Native Support for Cloud Platforms, On-prem Databases, & Flat File Systems | ✓ | ✓ | ✓ | ✓ |
Database Reverse Engineering | ✓ | |||
Metadata-driven Architecture | ✓ | ✓ | ✓ | |
Automated Dimensional Modeling | ✓ | ✓ | ||
Automated Data Vault | ✓ | |||
Data Model Based Authentication | ✓ | ✓ | ||
Data Model Verification Module | ✓ | ✓ | ✓ | |
Schema Management | ✓ | ✓ | ✓ | |
Automated ETL/ELT Mapping | ✓ | ✓ | ✓ | ✓ |
Hierarchical Mapping & Integration | ✓ | ✓ | ||
Automated ETL Code Generation | ✓ | ✓ | ✓ | |
Automated ELT Code Generation | ✓ | ✓ | ✓ | |
Target Platform Native Code Conversion | ✓ | ✓ | ✓ | |
Built-in Data Transformations | ✓ | ✓ | ||
Real-time testing for Data Pipelines | ✓ | |||
Source Control | ✓ | ✓ | ✓ | |
Job Scheduler & Monitor | ✓ | ✓ | ✓ | |
Workflow Orchestration | ✓ | ✓ | ||
Iterative Development | ✓ | ✓ | ||
Role Based Security and Access Control | ✓ | ✓ | ✓ | |
Data Warehouse Maintenance | ✓ | ✓ | ✓ | |
Documentation & Lineage | ✓ | ✓ | ✓ | ✓ |
OData Service Module | ✓ | ✓ | ✓ | |
Connectivity to BI Tools | ✓ | ✓ | ✓ |
