A leader in global security software recently hired Infoverity to improve performance of customer insight and retire a batch, hard coding based enrichment solution. To meet 2018 efficiency and contract deadlines, Infoverity migrated current hard coded workflows into a real-time based solution leveraging the Informatica Data Quality and Dun & Bradstreet’s Direct+ offering.
The deployment discarded hardcoded business rules and flat files as part of a larger Dun & Bradstreet Integration Manager (IM) setup. This was a key input into their Master Data Management (MDM) solution to keep their B2B data up-to-date with key segmentation values and hierarchical relationships for their global customer base. Leveraging Informatica components already in place, Infoverity easily pivoted to a real-time, scalable data solution – leveraging the speed and seamless integration between Direct+ and Infoverity’s use of Informatica Data Quality.
Based on the fixed deadline, a tactical solution was needed to accomplish hard business requirements of timeline and cost. Infoverity led the transition and future state architecture definition efforts, and then executed the transition state to meet an aggressive timeline. A critical success factor for the transition state was zero throw away configuration as part of the tactical solution.
Key to this success was the deployment of Infoverity’s Direct+ integration accelerator, allowing the team to meet the objective of zero throw away effort for the tactical state. This also allowed the team to focus on new Direct+ features and consistent matching results vs technical nuts and bolts of integration.
Based on this, the master data steering committee agreed that the first phase would be a seamless replacement of the existing IM processes, but required no throw away effort when pivoting to the future state.
The previous integration workflow (below) required batch data to be converted into a flat file. This resulted in a choppy, inconsistent data flow with many points of failure before being delivered to MDM and operational processes:
The team was tasked with replacing the workflow with real-time based service leveraging Direct+. This presented a number of challenges:
- Mapping the existing Integration Manager response to the Direct+ Response.
- Transformations to the Direct+ response were implemented where a direct one to one mapping was not possible.
- The Direct+ calls were implemented in IDQ with a focus on reusability in future phases of development.
- Implemented Infoverity Accelerator solution that enables IDQ to make service calls.
- The Match process in IM is significantly different from the Match process in Direct+. After a thorough analysis, a minimum set of Match rules were implemented.
The D&B company information integration has been completely replaced with no impact on current sales initiatives. Furthermore, some future initiatives are already enabled, and some of the requirements of the next phase have already been partially implemented. The new workflow is represented below.
Founded in 2011, Infoverity is a leading global professional services organization focused on solving business problems caused by the proliferation and diversification of data in large enterprises. Infoverity provides Master Data Management (MDM), Product Information Management (PIM) strategy and implementation, data governance and analytics, managed services and hosting solutions that help clients in the retail, consumer goods, manufacturing, financial and healthcare sectors to simplify and maximize the value of their information. Infoverity is on the Inc. 5000 list and #11 on the Columbus Fast 50. Infoverity is also named among the Best Places to Work in IT by IDG’s Computerworld, is recognized as a Wonderful Workplace for Young Professionals and was named the #1 Best Place to Work in its category by Columbus Business First. Infoverity’s global headquarters is in Dublin, Ohio, and additional service and support teams are located in Spain, Germany and Russia.
For more information on Infoverity solutions, contact us today.