You can connect selected data queries or file documents of 100+ backend systems to Microsoft Office 365 for data sync with native SharePoint Online lists and libraries without any programming or changes in the backend systems or in the corporate network / firewall. The connector runs as a Windows Service in your corporate network and manages the connections and data sync of changes as required.
Fig.: It's very simple to connect to 100+ systems using pre-defined connection string templates and data queries. The screen shows a connection to a data set Travel Agencies in a SAP ERP system.
Virtually any data sources supported: ODBC, OLEDB, OData, SOAP, Microsoft .NET based providers, Files (Excel, XML, CSV, Text), RSS / XML feeds, SQL databases like MS SQL, SQL Azure, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix; Notes, SharePoint (lists and libraries), local file system, cloud-based file stores, Exchange, Active Directory, Dynamics NAV/CRM, Navision, SAP and many more. More complex data sources, REST-based web services, custom COM, or .NET objects can be connected using 3rd-party add-ons. Cloud-to-cloud connections, e.g. to salesforce.com, Twitter, Facebook, Google, Amazon, BOX.NET and others are also supported.
You will find more information about Layer2 Cloud Connector connectivity to specific systems here.