How to make synchronization way -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Hi

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

This mailing list archive is Copyright 1997-2024 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.