Astera DW Builder2021-02-22T16:16:11+00:00

Key Features

Astera DW Builder’s modern approach to data warehousing delivers an integrated platform to design, implement, and build your own data warehouse using best practices out-of-the-box.

An Array of Out-Of-The-Box Connectors

Our data warehouse builder offers built-in connectors for several industry-leading databases including on-premises software such as SQL Server and Oracle Database as well as integrations with cloud services such as Amazon and Azure Cloud. Simply connect and configure the relevant source system and get started with modelling your data warehouse.

Workflow Orchestration

Leverage built-in workflow orchestration and job scheduling features to automate ETL operations across your data warehouse. Manage how your data warehouse responds to source system changes with a full selection of SCD-types that allow you to dictate how corrections and updates to existing records are reflected in your enterprise data warehouse.

Consumption Through OData Module

Once deployed, Astera Data Models (ADM) can be consumed by outside applications through the OData protocol. Whether you want to connect to your data model through a web browser or API clients such as Postman, all you need to do is enter the relevant address, input the generated token, and expose your ADM for real-time querying. You can also visualize your data through leading reporting and analytics applications, including Tableau, Microsoft PowerBI, and QlikView, to create an end-to-end process that delivers insights in near real-time to decision-makers across your enterprise.

Dimensional Data Model Designer

Astera's feature-rich dimensional modeler provides a unified interface that empowers users to create complete dimensional models from their source systems. Reverse engineer schemas from a database or import an erwin data model directly. Edit or merge tables and entity relationships to build a data warehouse that matches your reporting requirements. Configure fact or dimension tables and decide how to deal with changes to individual attributes using comprehensive SCD-handling options.

Intelligent Data Mapping

We make data mapping from source systems to the data warehouse flexible and fast. With Data Model-Query Objects and dedicated Fact and Dimension loaders, users can connect to one or multiple objects, apply transformations and business rules before loading outputs to related entities in their data model. The modern, visual approach cuts down up to 80% of the time spent in manual data mapping while providing complete control to users.

Data Quality and Profiling

Astera DW Builder can profile, cleanse, and validate data to ensure readiness for the data warehouse without the user having to change applications with a variety of data transformations. Everything is done within the data warehouse design tool as part of a single job. For backend logging to understanding errors, use the built-in field profiler and record-level log, or specify business rules and pinpoint data quality issues with ease.

Pushdown Optimization

The data warehouse automation solution comes with a robust pushdown optimization mode, allowing users to push these resource-intensive transformations and loading processes in the database. We support full and partial pushdown depending on whether source and destination databases share the same database type and server. With ELT capabilities enabled, you can leverage the processing power of on-prem or cloud databases to load millions of records to fact and dimension tables in seconds.

Deploy Your Data Warehouse in the Cloud

As a end-to-end data warehouse builder, ADWB makes it easier than ever to migrate your data warehouse to the cloud. We offer out-of-the-box connectivity to leading service providers such as Amazon RDS, Snowflake, Azure Synapse Analytics, Oracle Autonomous Data Warehouse, and others. Leverage the Centerprise DB agent to build a secure path to access your on-premises data from the cloud, ensuring quick connectivity and seamless data movement.

Data Model Verification

Prior to deployment, every data warehouse goes through several rounds of testing and troubleshooting. Our tool performs thorough data verification checks to cut down these repetitive tasks by highlighting any errors in your data model before moving to the next stage of production. From incomplete fields to referential errors, catch and correct potential issues at the first pass using this single-click validator.

How It Works

In Astera DW Builder, data models are the centerpiece of the entire data warehousing process, serving as the foundation for all the subsequent processes, such as ETL mappings, dimension and fact tables population, data consumption through the built-in OData module, and even for change management after deployment. 

Make Your Data Warehouse Development Lightning Fast