Microsoft Flow can be used to create automated workflows between a fast-growing number of apps and services to get notifications, synchronize files, connect data sources, and more. While the Microsoft Flow service is still in Beta, it comes with some pre-defined flows to integrate external systems and apps like Office 365, SharePoint, Dynamics, and OneDrive. But many typically used enterprise backend applications are still missing, especially local ones. The Layer2 Cloud Connector can now close this gap. 100+ IT systems and apps like SQL/ERP/CRM are supported to connect codelessly to Microsoft Flow via the Layer2 Data Provider for SharePoint to copy or move structured data or documents between apps.
Quickly integrate enterprise data sources with Microsoft Flow
The Layer2 Cloud Connector comes with support of a wide range of cloud-based data sources, as well as codeless data integration of 100+ on-premises applications like SQL databases and ERP/CRM/CMS systems. The connector runs safely as a Windows Service in the local network, or also in the Microsoft Azure Cloud, if required. There is no need to modify the connected systems, to open the corporate network for internet access, or to apply programming. The connector highly reduces the dependency on corporate IT and directly empowers departmental subject matter teams to get things done using Office 365, with significantly reduced complexity, risks, and costs.“A rich suite of data providers is already included in the package and provided as ready-to-use sample connection templates, e.g. for Microsoft SharePoint on-premises and online, Office 365, OneDrive for Business, Exchange, Office 365 Groups, Dynamics CRM/NAV/AX, OData, and XML/SOAP web services. The Layer2 Cloud Connector also works seamlessly together with already existing vendor-specific data providers, e.g. for SQL Server, SQL Azure, Oracle, MySQL, PostgreSQL, IBM AS/400, IBM DB2, Informix, SAP and 100+ more. Many 3rd party data providers, e.g. for Salesforce, Google, Twitter, Facebook etc. are also supported”, Frank Daske, Product Manager at Layer2, explains the connectivity options.
Microsoft Flow connectivity is just one option for the Layer2 Cloud Connector. It can also be used to connect many supported systems directly with each other as well as for document migration, backup and general data synchronization.