Business analytics depend on sufficient volumes of high‑quality data. The difficulty in ensuring data quality is integrating and reconciling data across different systems, and then deciding what subsets of data to make available to the analysis tool.
BIRT Analytics Loader provides one, integrated tool for extracting, transforming, and loading (ETL) big data into BIRT Analytics. ETL pulls data from one, or multiple data sources and places it into another database, using the following three processes:
Extract reads data from a database.
Transform converts the extracted data from its previous form into the form required for placement in another database. The transformation process uses rules, or lookup tables, or combines the data with other data.
Load writes the data into the target database.
Use BIRT Analytics Loader to load big data for analysis. Use BIRT Analytics to analyze the data. Both tools run in a web browser, and ship as options in the Actuate BIRT Analytics product.
Extract reads data from a database.