I just working on project "mobile application" which allow our mobile user to enter and received
data to/from our ERP (on AS400).
We have three environment:
1) mobile application working on android
2) data exchange server with postgre
3) erp with DB2 400
I would like to aks you about the best way how to make an synchronization data between exchange
server (Postgre) and AS400?
I.e. on exchange we have an Table1
The normal day_work will be that mobile app add records to Table1, erp read just added records -
make an process on erp - and update several feedback fields on exchange.
But from time to time also new record will be go from erp to EXCHANGE - NOT from mobile app (also
existing record could be updated or even deleted) ...
How would you create such process which assure that all new records will be processe - doesn't
matter if "source" is mobile or erp?
My idea is to have an exact copy of echange Table1 also in erp and before making change on exchange
server check in copy_Table1 if record really shoud be updated.
But if is it a best way?
Thanks for any answers ...
Regards
Tomek
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
