Which limitation applies to External Objects with Lightning Connect?

External Objects in Salesforce, which are used with Lightning Connect, provide a way to access data stored outside of Salesforce in real-time. While they facilitate integration with external data sources without storing the data in Salesforce, they come with certain limitations.

The correct statement regarding the limitations of External Objects is that they cannot utilize Formula fields. This is significant because Formula fields are a powerful feature in Salesforce that allow users to perform calculations on data within the platform. However, because External Objects represent data that resides outside of Salesforce, the platform cannot dynamically calculate values based on that external data the same way it can with native Salesforce objects.

This limitation stems from the nature of real-time data access provided by Lightning Connect. When an External Object is queried, it pulls data from an external source dynamically, which means the integrity of the source data is maintained, but the robust functionality available for native objects, such as Formula fields or other complex field types, is not applicable.

In contrast to this, External Objects can access external data, can be edited by Salesforce users (with necessary permissions and setup), and can also be used in reporting to some extent, though there are specific restrictions on how much external data can be included in more complex reporting scenarios (like joined reports). Therefore, understanding