I have created job which is comparing data between two orgs and making any changes to another one if data differs.
In other words, we have org A and org B, org A is our main org and we want to have the same data on org B.
First step of the job is to create csv with current org A data. (tSalesforceInput -> tMap -> tSalesforceOutput)
Next we are upserting our csv file to org B. If there is already the same record (we are using unique external ID to compare) we are only updating the record, if there is no such record we are inserting it, if there is any record which has not been on org A and it is on org B we are deleting it.
My query is about automation, I have to do it for multiple objects (more then 30). Is there any way to automate it? Like put first step into loop or something?
As far as I know you can't because schemas are complety differents from one object to another. However you can automate a Dataloader process and produce the required XML files for it based on objects metadata using TOS. A little tricky but possible.
