Hello everyone, we have an application that utilises Salesforce as the underlying platform, we don't have a direct commercial relationship with Salesforce themselves as a result - that relationship is instead managed by the provider of this solution (TrackWise Digital).
We would like to use the information in TWD / Salesforce to populate an MS Fabric Lakehouse, for the purposes of business intelligence, integration with other systems and potentially even experiment with AI technologies at some point - but what is the best way to extract the data from Salesforce given it's the underlying "storage platform" for this solution?
We've looked at various API's, e.g. SObject Reads / SOQL, but is there a recommended approach from anyone who has "been there, done that" - we would like to avoid going down the wrong roads with this and finding there was a better approach.
Finally, in terms of access needed - what do we need to ask our partner Honeywell for in terms of access to allow access in the recommended way, is there a particular type of account / key to request?
Thanks for reading folks, we're really interested in progressing this so your assistance greatly appreciated.
Best regards
Chris
#Salesforce Developer #Integration #Business Intelligence Team