One of the main sources of dirty data originates in address duplication. The causes here are everything from using non-standardized city and state fields to slight variations in the spelling of road names. Decisions comes with a connector to the US Postal service address verification system to ensure standardized address fields.
Interceptor Cleaning Rules
It’s not always possible to go back and change data in source systems, but it is possible to convert data on it’s way to reporting system databases. Decisions interceptor rules are ideal for making these “on the fly” conversions to standardize your data.
The best place to ensure clean data is at the point of entry. Combining Decisions form builder with our rules engine allows for data validation at the beginning of your process. This can include features such as dependent drop-downs, standardized lists, data calls to search for duplicates and also setting ranges or boundaries around certain fields.
Account/Product Code Reconciliation
Whether it’s account codes, product codes, customer codes or something different, Decisions can move, transport and transform data on it’s way. Companies often struggle with consolidating information due to prior acquisitions, overseas affiliates or simply due to lack of proper data controls. Our business rules engine is ideal for moving and manipulating data and creating the rules to properly transform this data for management oversight.
Master Data Storage
Decisions can act as the Master System of Record that other software applications access to determine if there is an existing record. Alternatively, Decisions can take data from multiple systems of record and clean these prior to their movement to a data mart. With Decisions embedded workflow, tasks can be assigned to specific individuals or groups to investigate data that doesn’t fall under an existing rule.
In many organizations it’s not uncommon to have several systems managing the same data. Seamlessly integrating these systems such that data can flow from system to system, while maintaining data integrity, can be a challenge. Decisions offers a variety of tools to make system integration easy. Our built in data mapping tool allows you to graphically link data between systems while our rules engine allows for data transformation on the fly.
ESB & Message Bus Integration
Decisions can be used as an orchestration layer, stitching together disconnected systems in your organization. ESB & Message Bus integration allows data to flow between different applications in order to maintain data consistency and get work done.