This is an archived course — no longer updated. For current documentation see the official iDempiere docs. Today we help teams migrate from Sage ERP to iDempiere open source ERP — to join the sage.erpcommons.org community, email chuck@racktrust.com. Read the full story.

Multiple-Site iDempiere Replication with FDW

The purpose of this page is to help you get started with multiple site iDempiere replication using PostgreSQL FDW (Foreign Data Replication).

Topics:

00:00:00 - Introduction problem and topic
00:03:45 - Introduction to FDW
00:04:45 - Introduction to read via materialized view example
00:12:15 - Introduction to materialized views
00:16:45 - Return to read example
00:21:00 - Summary of read example
00:21:45 - Introduction to write example - specifically writing orders
00:28:15 - Execute write script
00:34:15 - Introduction to batch writes
00:44:45 - Import Order process details
00:49:00 - How to create Site instances of iDempiere
00:58:50 - Alternative syncing strategies