We are releasing Astera Data Virtualization, a data solution that will help businesses serve integrated data on demand to the end-user. This new functionality enables you to access and integrate data from disparate sources, including database repositories, file systems, in-memory formats, and web APIs, and present it as a single-source entity. The integrated data can be used for subsequent processes, such as reporting, BI analytics, data warehousing, etc.
Here is a rundown of the features available in Astera Data Virtualization:
- Virtual Data Models: You can now create canonical views of your data sources and access them in near-real time by designing a virtual data model. With the one-click deployment, you can make the resultant table accessible to dataflows and workflows as a single-source entity.
- Entity-Relationships: Establish referential integrity for the virtual database table by creating one-to-one or one-to-many relationships between source entities in a code-free, drag-and-drop manner.
- Layout Building: With this feature, we give you the option to modify the source, virtual entity, and cache database layouts. This ensures the layout of your virtual database table stays consistent, irrespective of the type and format of data sources.
- Database Caching: For faster query processing, we have added the caching feature that creates a temporary copy of the source data on your server through full or incremental loading. The query is run on the virtual database entity, which fetches the data that was last cached.
- Virtual Data Model Deployments Monitor: We have made it easier for you to track the progress of your deployments by introducing the virtual data model deployments monitor. It enables you to check if the job is running, completed, or failed. You can also go through the job log to get a detailed report of each entity’s cache status.
- Astera Query Language (AQL): This new native query language of Astera is identical to the SQL SELECT statement. It uses automatic joins and aggregate functions for data retrieval. AQL can be used via the Multi-Query Table element in a dataflow or the Query Window.
- Astera Model Database (ADM): Powered by AQL, this database provider is used as a source in Astera Data Virtualization. It is mainly used for data retrieval by the Astera Query engine.
Have questions about these new features or want to suggest enhancements? Read the detailed release notes or comment below and we’ll get back to you.