Connections stores URL, User/AppID for connecting to SharePoint Sites

The connection caches Information about the site artifacts like Lists & Libraries. This information is used for setting up column mappings etc.

Important about Office 365 – Microsoft recommendations in order to reduce the throttling.
  • Use AppID/Secret as the authentication model when reading or transferring large amounts of data
  • Also using AppID/Secret is great since you then do not have to dedicate a user account and deal with password policy and two factor authentication. Further more using the AppID you can then block Legacy Authentication for your tenant thereby enhancing security..
Here are some helpful links for creating an Office 365 AppID

Check this out for: Tuning SharePoint O365 performance.

Need more help with this?

Thanks for your feedback.