Hello @* Salesforce Developers *!
Our Back-End IT team built a large (external) database that they'd like to 'communicate' regularly with our Salesforce Org through a SF API. Which API do you think would be the best for this instance for secure and compliant fluid data connectivity? The exchanges (receive/export) will be multiple times a day.
Our IT Director advised possibly using the Graph QL API, but tasked me with researching into the other APIs as well.
________________________________________________________________________
What's the MOST SECURE way to migrate & retrieve data (all HIPAA PHI/ PII data) from our org to the database?
Would love your insight / thoughts!
Have a look at your current api consumption limits. An outside app calling to your instance will consume limits. I suspect the bulk api would be best here for the larger volumes.
Setup a connected app and an api only user account as to track transmissions and updates to a specific system user. Only give that user permissions to the pertinent objects as well.