Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jdope
Contributor III
Contributor III

Salesforce Schema - updateable, createable attributes

Salesforce has attributes that describe actions that can be taken on the field.  For instance each field has attributes updateable (the field value can be updated), creatable (the field value can be specified during create), etc.  

 

Salesforce has the concept of "calculated" fields (called formula fields).  These fields are NOT updateable.  It would be great to have these attributes available after Talend generates a schema from salesforce.  Consider the following:

 

There is an Account object with 400 fields, and 40 of them are formula fields which cannot be updated. Assume you want to move this data between salesforce environments (eg. production to sandbox).  

Generate the talend account schema with 400 fields.  

You must manually exclude the 40 fields from the schema / tmap, etc.  

 

There is no programatic way to determine the fields readability from the salesforce attributes in Talend.  So every time the account schema is refreshed you must go in and remove the non-updateable fields manually.  Now imagine doing this for 30 salesforce objects a few times a month...

 

It would be great to have this attribute from salesforce in talend so it can be referenced programatically.  

Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hello,

Could you please create a new feature jira issue on talend bug tracker?

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina

View solution in original post

2 Replies
Anonymous
Not applicable

Hello,

Could you please create a new feature jira issue on talend bug tracker?

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina

jdope
Contributor III
Contributor III
Author

Great, thank you.  I created TDI-40013 (I hope that's the right project).