Dynamically Map columns for UPSERT / UPDATE / INSERT into Salesforce
I am currently working on an integration between SQL and Salesforce. The integration is working great but I just wanted to find out if there was a way I could automatically pick up mappings of columns between the two? In the attached simplified sample you can see how I am doing the mapping in the Tabular Transformations - Map Headers task but each time I add a column for upload to Salesforce I need to manually edit the chain, adding this new column and mapping and then promote it through the environments.
Essentially I would like the chain to automatically pick up the new column from SQL (which I know we can currently do through a SQL INFORMATION_SCHEMA) and automatically add that mapping. I envision maybe a separately managed mapping file/form/variable that we read before upload. This file can just be used across environments or be deployed through the environments.