Built upon Astera’s industrial-strength ETL engine and refined by years of use in Fortune 1000 companies, DWAccelerator offers an agile and flexible data warehouse automation platform.
The technology “accelerates” data warehousing by automating repetitive tasks, allowing a business to refocus resources on design and optimization. With the feature-rich dimensional modeler, automated handling and loading of dimensions and facts, use of intelligent mapping techniques for process automation, and direct integration with visualization tools, DWAccelerator takes operational data all the way to actionable insight in a code-free environment.
Gathering requirements is one of the most time-intensive tasks in data warehousing design. DWAccelerator allows users to prototype reports rapidly and decide on source data streams so users can start modeling data faster.
With the built-in designer, data models can either be designed from scratch or reverse engineered from an existing database. The drag-and-drop table merge feature and easily editable fact and dimension roles and properties allow easy conversion into star or snowflake schema.
DWAccelerator uses intelligent matching techniques to map source entities to destination automatically. Users can take control with direct maps, or write custom expressions. The platform offers the perfect blend of flexible customization and automation.
The framework supports real-time data warehousing with Change Data Capture (CDC). Choose your data loading strategy or define rules to deploy a custom read strategy, and proceed to auto-populate Facts and Dimensions with one click.
Use the platform’s sophisticated data quality and transformation features and load analytics-ready data directly into the business intelligence tool of choice for data visualization.
As an end-to-end business intelligence solution, DWAccelerator offers native integration with the foremost visualization software providers: Tableau, PowerBI, and QlikView. Create interactive charts by exporting data directly, and keep the dashboards updated using DWAccelerator’s powerful job scheduling features.
Integrated, Code-Free Interface for Data Warehousing
Intuitive enough that developers and non-developers alike can use it, DWAccelerator’s integrated interface puts all the tools a business needs to build a data warehouse end-to-end in a completely visual, code-free design.
Intuitively Model Business Data in the Built-in Model Designer
With its feature-rich dimensional data modeler, DWAccelerator enables users to visually create dimensional entities, assign roles, and edit Fact and Dimension properties.
Insulate Users from the Technicalities with an Abstraction Layer
The Virtual Data Model creates an abstraction layer so users can connect to unstructured, semi-structured, and structured data directly and prototype reports, effectively insulating users from the technical details of accessing source data.
Automatically Manage Slowly Changing Dimensions
DWAccelerator lets users select how Slowly Changing Dimension are handled in the data warehouse and choose how they want to track history, directly from the drop-down in Dimension properties.
Derive Greater Performance with Push-Down Optimization (ELT)
Leverage the advanced processing power of databases and data warehouse appliances by pushing down the transformation logic down to the destination and reduce time taken to transform large data sets.
Connect to a Wide Range of Sources and Destinations
The extensive connectivity options ensure that businesses can use all major cloud and on-premise databases and data warehouse appliances as both source and destination.
Export Data Directly into Visualization Software
Automatically populate visualization dashboards and feed data into interactive charts directly from the data warehouse using DWAccelerator’s native integration to leading providers.
Analyze Data Lineage and Impact
Track the flow of data from source to target, or from target to source to study a scaled-down view of lineage based on metadata, and validate relationships.
Ensure Data Readiness with Built-in Quality and Transformation Modules
Profile, cleanse, and validate data to ensure readiness for the data warehouse using the built-in data quality module; use field and record level logs to determine errors and failure rate.
Generate Integration Flows with One Click
Once mapping is complete and high-level loading strategy specified, the user can generate the dataflows and workflows along with underlying ETL code to populate the data warehouse automatically.