Lightning Connect is recommended when:
- You have a large amount of data that you don’t want to copy into your Salesforce organization.
- You need small amounts of data at any one time.
- You want real-time access to the latest data.
Even though the data is stored outside your organization, Lightning Connect provides seamless integration with the Force.com platform. External objects are available to Salesforce tools, such as global search, lookup relationships, record feeds, and the Salesforce1 app. External objects are also available to SOSL and SOQL queries, Salesforce APIs, and deployment via the Metadata API, change sets, and packages.