Fig 02 - Astera ReportMiner Marketecture
Data integration is a mature market and Astera Software offers all the basic requirements that one would expect, and we do not need to discuss these. However, there are a number of additional capabilities that are worth more detailed consideration. The first of these relates to data quality. The products include data profiling capabilities and the ability to develop (in a no-code environment) your own data quality rules. These leverage Astera’s rules engine (which has a look and feel similar to Microsoft Excel) and, while Astera does not offer a match engine per se, the rules engine does have the ability to do things like fuzzy matching. Moreover, a number of the rules that are delivered with the product (more than 500 of them) provide survivorship options. There are specific data quality capabilities – see Figure 2 – including matching in this instance, in the Astera ReportMiner product.
Beyond data quality there are three recently introduced modules: API Integration, Data Virtualization and Data Warehouse Automation, of which the first and third merit discussion. This isn’t to say that Data Virtualization isn’t nice to have, just that its principles (a virtual view across multiple data sources) are well known. As for API Integration this allows users to expose any data source, or a subset thereof, as a secure, managed, real-time RESTful API. You can publish these APIs to both internal and external users, and you can publish data either to a virtual database, to an API or OData. Service Orchestration is provided. Further enhancements to these capabilities are planned.
Data Warehouse Automation allows you to speed up the process of creating or migrating to a data warehouse. Astera does this by providing data modelling capabilities that allow you to map dimension and fact tables and then automatically load data based on those definitions. Where necessary Astera has the ability to reverse engineer relevant (for example, Snowflake) data warehouse schemas, or it can push a schema (including joins, lookups and so on) to the target.
Finally, we should mention that Astera plans to introduce Data Flow as a Service (DFaaS) in the near future.