The module manages individual data, as it is collected, along with large amounts of data. They merge into the system on a daily, weekly or monthly basis. The data is automatically updated and organized according to the desired time schedule.
The ETL module allows the integration of heterogeneous information sources based on their format and structure (delimited files, XML, RDBMS tables, spreadsheets, click stream, etc.) coming from different systems (ERP, administrative, etc.) creating an optimized Data Mart and Data Warehouse.
The new Data Entry module allows the integration of data with the Data Warehouse. If they are authorized they will be manually input into the system using some forms which have been predefined by the system administrator.
The system processes important data applying business rules previously defined during the analysis phase using the set features of the user interface.
During the acquisition process, raw data is processed in order to generate basic business information. Some advanced features are available for tasks such as distribution and allocation, fusion, balanced merge sort, predictive models creation, etc.
E3 also supports users in data consultation and certification procedures thanks to utilities that guarantee data cleansing to other sources. This analysis allows the verification of its compliance with the business standards and criteria.
Moreover, the E3 platform provides automatic tools to automatically update (closed-loop) the information regarding the Business Intelligence system, ERP, the corporate portal database, etc.
ETL works transparently with all RDBMS (Oracle, SQL Server, DB2, Sybase, Informix, MySQL, etc.) and provides optimized tools to load and refresh data. These tools fully and automatically take advantage of advanced data management utilities offered by RDBMS.
E3 is really productive: the product is easy-to-use and intuitive, requesting only a short amount of training time, meaning that managing and maximizing the management of specific infrastructure and data integration resources is facilitated.
Administrators can program all kinds of processes using time planning and scheduling features (calendar) even linked to external activities.
The system administration turns out to be much more simplified and resources can be optimized with advantages for the entire data management cycle.