Salesforce Certified Integration Architect — Question 77

An integration architect has been tasked with integrating Salesforce with an on-premises system. Due to some established policies, this system must remain on-premises.

What should the architect use to build a solution for this requirement?

Answer options

• A. Use Heroku Connect if the data is hosted in Heroku.
• B. Use Salesforce Connect if the database supports Open Data Protocol (OData).
• C. Use Salesforce Connect if the database supports Open Database Connectivity (ODBC).

Correct answer: C

Explanation

The correct answer is C because Salesforce Connect allows integration with on-premises databases through ODBC, which is essential for systems that cannot be moved to the cloud. Option A is incorrect as Heroku Connect is only applicable for data in Heroku and not for on-premises systems. Option B is also incorrect since it relies on OData compatibility, which does not address the requirement for an on-premises solution.