CODEWITHSUNDEEP
databasepostgresqlsynchronizationtalend
Jyoti Kumari
Jyoti Kumari

Reputation: 96

Talend Open Studio For MDM + Postgresql + synchronization of two databases

I have two database A and B(replica of A) now one live web application is entering data into A now i want that the entries done in A should be reflected in B.(i.e the changes in A should automatically reflect in B).

My sole purpose is synchronizing two databases and for that i have searched on Talend. I searched and came up with Talend MDM.I have installed MDM .I have searched on it but i am not getting whether it does database synchronization or not.Since there are other talend products like ESB,Data Integration etc. which one of them exactly is for syncing purpose. Please suggest me.

Upvotes: 5

Views: 1409

Answers (1)

Jean-Michel Garcia
Jean-Michel Garcia

Reputation: 2389

IHMO, if you are looking for data replication between two databases having the same structure, then Talend is not what you are looking for.

Talend is an ETL tool (Extract Transform and Load). It would be applicable if in your case, your B database had a different structure than A. For that particular use case, you would use Talend in order to define some processing rules :

  1. How do I extract data from A (Extract)
  2. How do I transform A's data into B's data (Transform)
  3. How do I store B's data (Load)

As mentioned by @jayadevan above, I would definitely look for inbuilt replication offered by your database.

Upvotes: 3

Related Questions