progress data replication what, why and how?business use case (handcrafted) •an specialized...
TRANSCRIPT
Progress Data Replication – What, Why and How?
Host and Speaker: Prabhu Jha
Speaker: Rajinder Kamboj
1
Data Replication?
•Clone data consistently at one of more target Locations
2
Data Replication? (Cont.)
Disaster Recovery
For OpenEdge to OpenEdgeFailover Process
•Data replication is not for:
3
Need for Replication ?
•Data for BI, Analytics & Reporting
•Alternative views of data
•Heterogeneous application integration
•Copy of data from a cloud hosted system
Real-time Data
Replication
4
Challenges in Replication
•Connectivity
•Managing different data types and data structures
•Complexity
•Performance
•Disruption of normal business operations
•Scalability
5
Approaches of Replication Solution
•Off-the-Shelf
•OE Pro2
•Handcrafted
•Use of Traditional ABL Programing and OE DataServer
6
Replication components
7
Components
OpenEdge4GL
Database triggers
Data Server
DSN for connectivity
Replication flow
Flow
8
Data replication completed
Data feed to Data Server
Connectivity with foreign
DB
Queue Processing
Replication Queue
Transactional data in
Progress DB
Typical Working of Replication?
9
• Captured data changes via
replication triggers
•Write information to que
•Multi-threaded replication process
retrieves the updated record
•Queued data is moved via OE Data
Server
Consideration in Solution Selection
•OpenEdge License
•Complex OpenEdge environment & infrastructure
•Versions of the OpenEdge
•Scalability
•Implementation time
•Support requirement
•Cost
10
Use case
•A Manufacturing house
•50 Worldwide Progress based instances
•Different Progress versions, 8.3c – 10.1c
•Took 1 – 2 weeks to roll worldwide data into the BI structure
•Pro2 was installed across ALL environments
•Data warehouse and BI is hooked to replicated instance
11
Business Use case (Handcrafted)
•An specialized logistics service provider
•150+ nationwide OE based application instances
•Same Progress Version at all location
•Require OE based application data into MS SQL Server
•Traditional Replication solution was implemented
•MS Power BI is hooked to the replicated instance
12
Q & A
13
Thank YouContact us: [email protected]
14