Case Study: China PnR achieves scalable real-time analytics with OpenText Analytics Database (Vertica)

China PnR builds scalable, real-time data warehouse analytics platform

China PnR, a Shanghai-based financial services provider for small businesses and individual investors, needed a faster, more reliable data warehouse analytics platform to support rapid business growth. Its legacy Oracle environment was expensive, slow to scale, prone to outages, and difficult to use for advanced analytics and R-based queries, creating risks for reporting, fraud prevention, and regulatory support.

China PnR implemented OpenText Analytics Database (Vertica), with OpenText supporting the proof-of-concept and deployment. The new platform dramatically improved performance, cutting query time from up to one hour to less than one minute and data loading from 10 hours to about one hour, while also improving stability and support. The project delivered a 422% ROI, a two-month payback, and an average annual benefit of $1,914,969, helping China PnR save millions in legacy costs and improve productivity.

China PnR

Yi Juan

General Manager