What can I do if I want to transfer data from Sales force to Microsoft SQL after update in sales force table?
Can we transfer data from Sales force to Microsoft SQL and vice versa simultaneously?
Since you are using TOS, you will have to plan the scheduling part by another application. Now, to extract the updated Salesforce records, you can use tSalesforceGetUpdated component.
Similarly you can extract the updated records from MSSQL also using the modified time stamp column of the source table.
In your case, you are looking for the data flow to happen from both sides. The Salesforce updated record will flow to MSSQL by above method but you need to make sure that the flow should not happen in the reverse mode for same record. Else it will end up in an infinite loop.
This can be achieved if you are storing the last updated source system name in both areas. When you extract the delta records from MSSQL, you should avoid the records have source system name as Salesforce. Similarly when you extract from Salesforce, you should avoid the records having MSSQL as source.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema