What method of integration allows for on-demand data access from an external ERP while minimizing Salesforce data storage?

Implementing Salesforce Connect with external data sources is the most effective method for providing on-demand data access from an external ERP while also minimizing data storage within Salesforce. Salesforce Connect establishes a direct link to external systems, allowing users to access and interact with data in real time without storing that data within Salesforce itself.

This approach is particularly beneficial when dealing with large volumes of data, as it avoids the need for frequent data imports or scheduled updates, thus reducing the physical storage impact on Salesforce. With Salesforce Connect, the data remains in the external system and is presented within Salesforce as if it were part of the Salesforce data model, providing a seamless experience for users.

In contrast, utilizing scheduled imports would involve regular data transfers, which could lead to increased storage usage and delayed access to the most current data. Creating an APEX trigger for real-time data updates may provide immediate updates but could complicate the integration process and involve greater maintenance overhead. Utilizing standard API calls for data retrieval can allow for on-demand access but might still require some form of data caching or storage, which could negate the goal of minimizing Salesforce storage. Thus, Salesforce Connect stands out as the optimal solution for real-time integration without compromising on storage efficiency.