[Progress Communities] [Progress OpenEdge ABL] Forum Post: Real Time Data Replication for BI Reporting

[Rohit Ramakrishna]

Need inputs / suggestions. We have 15-20 production databases (10.2B). Schema is always in sync across these databases. Currently for BI reporting, we either dump data from specific tables into flat files or a ODBC connections into DB. How have other companies managed BI reporting from Progress Db(s). I'm in process of evaluating Pro2 for (near) real time sync from Progress Db to SQL Db. Other option is to capture changes (db triggers) and sync through Sonic to target. Any other thoughts or solutions?

Continue reading...