“Integrating Precisely Connect with our Teradata environment was by far the best IT investment for United Rentals in many years.”
For years United Rentals struggled to maintain duel replication from the source IBM i system to two Teradata environments. They leveraged another vendors CDC/Data Replication technology to stream data continuously to both systems. In the event there is a network communication issue the replication process would crash. This replication failure would result in their production data warehouse process to not build at night and as a result fail to send out critical scorecards to the executive team and branches. It would take hours to understand the failure point, restart the replication, get the data back in synch and perform necessary validations. They also would identify “gaps” in the data where the starting point was set incorrectly and as a result they were missing data.
Because of the ongoing replication interruptions, the business to lose confidence with the data and processes. There were numerous occasions when replication would fail just before midnight and as a result key metrics and critical scorecards would not get distributed. The other issue they encountered was with the data itself. When recovering from a replication outage there were times when the restart point was slightly off and caused data issues. As a result they had gaps in the data, which the business would find and report back to on and as a result they started questioning the overall validity of the data.
One of the requirements was that the technology architecture NOT change. Their business processes were in place and tested and as long as the real-time data was correct, the architecture was exactly as they wanted.
After researching different products they selected Precisely’s data integration solution Connect to solve the replication reliability problems. The product addressed the biggest concern, which was the ability to recover from a network outage without human interaction and keep data integrity with no dropped records.