Salesforce metadata - How to refresh schemas correctly?
I've tried several ways to refresh Salesforce metadata, and the problem I run into is that the only way I see to "re-get" the data from salesforce is to right click the connection and go to "retrieve modules" - However when I do this, I get 2 copies of whatever schema I had. Trying to delete the old one of them becomes problematic as well. Can anyone tell me how to update a schema from salesforce?
Talend TOS, installed as TOS_DI-Win32-r79245-V5.1.0M1, does seem to correct this problem. A cautionary word: when using the "Retrieve Salesforce Modules" command to refresh existing schema definitions, if you un-check a Salesforce object, it will be removed from your metadata store. So, I think best practice is probably to leave everything checked, unless you really want to remove it from your metadata. Also, it looks like there's no automation for refreshing the schema on components already in jobs - I had to select the schema again within the component config tab. Still, this is definitely an improvement.
Thanks again for prompting some action on this topic!
Ben
Hi Stephen. I never tried the workaround, as the fix for this issue was released. So far, it seems to be working well. I suggest avoiding the hassle of the workaround and just upgrading. -Ben
This is still an issue in latest version of Talend. When I try to refresh the schema it generates multiple copies. I really love Talend. I just wish the SFDC Schema Refresh issues could get resolved as this is our primary Data Source we use with Talend.
Just a note that although I encountered this problem in the past, it now appears to work correctly for me. I am using 5.1.1
Added a field in SFDC. Right clicked connection in Talend and selected "Retrieve Salesforce Modules". Untick the relevant object, re-tick it, and click finish. The object then updates with the field.
