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.
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.
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