Download PDF
Fivetran > Case Studies > DPD Polska's Real-Time Data Replication for Enhanced Parcel Delivery
Fivetran Logo

DPD Polska's Real-Time Data Replication for Enhanced Parcel Delivery

Technology Category
  • Analytics & Modeling - Real Time Analytics
  • Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
  • National Security & Defense
  • Transportation
Applicable Functions
  • Logistics & Transportation
  • Quality Assurance
Use Cases
  • Edge Computing & Edge Intelligence
  • Real-Time Location System (RTLS)
Services
  • System Integration
  • Testing & Certification
The Challenge
DPD Polska, a leader in the Polish courier market, was facing challenges with its existing data management system. The company was using a series of on-premises PostgreSQL and Microsoft SQL Server databases to track its trucks, parcels, and people. However, the array of custom SQL databases was preventing DPD from producing timely reports, meeting disaster recovery time objectives, testing new data and analytic products, scaling up its revenues, and increasing its customer base. For instance, one of DPD’s databases had three different usage contexts. The company was in need of a log-based replication solution that would not impact its source systems. The main pain points were the replication time lags, the risk of errors in manual data distribution, and the need for more flexibility, greater reliability, and higher operational scalability.
About The Customer
DPD Polska is part of DPDGroup, the second largest international courier network. As the leader of the Polish courier market, DPD Polska delivers 200 million parcels annually. The company employs over 50,000 people and operates in the shipping and logistics industry. DPD Polska was using a series of on-premises PostgreSQL and Microsoft SQL Server databases to track its operations. However, the company was facing challenges with data replication, disaster recovery, and scaling up its operations.
The Solution
To address these challenges, system and data integrator Goldenore deployed Fivetran, a high-volume replication (Local Data Processing) solution. This enabled DPD to replicate data in near real-time from multiple sources into Oracle DB on-premise, PostgreSQL on-premise, and MS Azure without impacting source database performance. The solution provided DPD with log-based change data capture, near real-time replication, data validation, and visual statistics on data movement. As a result, DPD was able to effectively and safely replicate business-critical data to Azure and across its on-premise reporting and testing environments. The company is now working on replicating a new series of Microsoft SQL Server databases using Fivetran’s solution, zero downtime migrations of PostgreSQL, and migrations of business applications to MS Azure.
Operational Impact
  • The deployment of Fivetran has brought significant operational benefits to DPD Polska. The leadership teams now have access to timely, reliable data, enabling them to make faster business decisions and expand DPD Polska’s market presence. The solution has also enabled DPD to scale its analytics function without delay, thereby enhancing its operational efficiency. Moreover, the stronger disaster recovery footprint ensures greater resilience and security for DPD Polska. The company can now confidently execute functional and performance tests on production data, as Fivetran ensures security and continuous data validation. This has also opened up possibilities for advanced data processing, including real-time analytics and reporting.
Quantitative Benefit
  • DPD Polska now has access to timely, reliable data, enabling faster business decisions
  • The company can now scale its analytics function without delay
  • DPD Polska has a stronger disaster recovery footprint, ensuring greater resilience and security

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.