Content stored in almost any corporate data source can be synchronized with native SharePoint lists and libraries via secure web services: Data in SQL databases, file shares, ERP / CRM / ECMS systems or other legacy platforms and on-premise applications like MS Dynamics, SharePoint, Active Directory, SAP etc. Cloud-to-cloud connections e.g. to Azure, Salesforce, Twitter, Facebook, Google, RSS Newsfeeds, XML etc. are supported as well. All features of native SharePoint lists and libraries are completely available for your external data, e.g. views, filter, search, metadata, change notifications and workflows on external data change.
The connector was especially developed to solve the specific challenges of remotely hosted disconnected systems in the cloud without any direct access to the corporate data center and very restricted feature customization capabilities. A data integration strategy needs to be within the foundation of any cloud computing plan. This integration needs to be innate to the architecture; it can't be something you're reminded of at the rollout meeting.
The Cloud Connector solves many issues that still exists with the SharePoint Business Connectivity Services (BCS) on-premise and in the cloud. It offers a more holistic approach that combines the power of data-, application- and process integration. OneDrive for Business sync issues and limitations
are completely solved.
Fig.: Connections are managed in the Connection Manager, an easy to use Windows MMC Application.
Fig.: Each data entity can be specified with a view settings only in just minutes. Simply select a data provider, enter a connection string and data query. No programming is required to establish a connection.