CONTEXTThe company uses ERP software with an SQL database. During normal system operation, emergency situations may occur—both related and unrelated to the ERP software—that affect the quality, correctness, and integrity of the stored data.
TASK The responsibility of the IT team is to create data validation procedures in order to minimize the risk of invalid data.
EXAMPLE USE OF GRAVITY – Data Validation in ERP Tables
In GRAVITY, we design a process for testing records in selected tables to verify that they do not contain disallowed values. When such cases are detected, depending on the table and the type of issue, the invalid record is deleted or information about corrupted data is sent.
CONTEXTThe company uses ERP software with an SQL database. During use of the ERP system, unintentional duplicates have been observed, for example in the customer master data.
TASK
Testing the database and eliminating potential duplicates.
EXAMPLE USE OF GRAVITY – Detection of Customer Data Duplicates
In GRAVITY, we design a process for testing records in the customer data table to detect duplicates—records containing fields that are similar with a certain probability (the TEXT RECON operator). When such cases are detected, we place a reference to the master record in the table (provided that the ERP software allows this). If the ERP software does not allow this, the detection results can be written to a file and sent, or stored in a declared database (accessible via external software).
CONTEXTThe company uses ERP software. The user would like to extend data integrity checks by validating freely definable rules.
TASK
Verification of accounting rules related to posting turnovers to individual accounts.
EXAMPLE USE OF GRAVITY – Accounting Rule Validation
In GRAVITY, we design a process to validate a rule stating that the total turnovers of accounting accounts in group 5 must match the control total posted to account 490.
CONTEXTThe company uses ERP software as well as analytical software, for example BI-class tools.
TASK
Preparing ERP system data for fast consumption by BI analytical software.
EXAMPLE USE OF GRAVITY – ERP Data Preparation for BI
In GRAVITY, we design a process for retrieving data and calculating aggregate totals. Aggregate totals and potential duplicates are maintained in cache, providing the BI software with access to prepared data.
The process is triggered by a scheduling mechanism with a short interval, ensuring that the cache always contains the most recent calculations.
EXAMPLE USE OF GRAVITY – Data Normalization and Consolidation
In GRAVITY, we design a process for retrieving data and normalizing units for aggregation or consolidation purposes.
EXAMPLE USE OF GRAVITY – Merging Multiple Data Sources
In GRAVITY, we design a process for retrieving data and merging multiple databases.