I am not a developer but will ask this question here in hopes of gauging the level of difficulty for a project.
We use Sales & Service Cloud as well as Financial Force. We pass Sales Order data from Financial Force into SQL databases using a simple ETL routine with a product from Talend. That data is then used by a web application (private, behind firewall) we have developed that runs on a MS server and leverages the .net framework.
We'd like to put an iframe (unless there is another way) with Sales Order object data on a page in our web app so we can edit the"Order Status" field in FF. Our hope is to directly edit the FF object data and avoid having to write the the SQL data, then pass it back to platform, etc.
Curious on how doable this is, and if someone could direct me to some resources that I could share with our web developer that might help him achieve this.
Thanks in advance.
Greg
If I understood correctly, you are basically looking for a way to negate having to convert the Sales Order data into SQL database and just have this data be directly linked to the custom web application you've made? A possible tool that may help in this type of integration is Salesforce Connect. This would be the declarative preferred route. If the use of this is insufficient, one can potentially create code that would utilize Salesforce's API and make callouts from the web application to the database whenever a change was made. More information about Salesforce Connect can be found here: https://www.salesforce.com/blog/2015/12/announcing-salesforce-connect.html#:~:text=Salesforce%20Connect%20is%20an%20exciting,or%20cloud%2C%20directly%20from%20Salesforce.&text=APIs%20connect%20the%20apps%20that,and%20services%20from%20any%20device
