FAQs

The Cloud Connector for Microsoft Office 365 and SharePoint 2010 connects almost any on-premise or cloud-based data source, e.g. ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like SQL Server, SQL Azure, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP, Salesforce and many more directly to native SharePoint lists in the Microsoft Cloud - or any other Microsoft SharePoint 2010 installation - in just minutes without any programming. For any questions please use the FAQ Web Form or contact sales@layer2.de directly.

Office 365 Cloud Connector - Version History - Known Issues & Workarounds

Read about the Office 365 Cloud Connector version history, known issues & workarounds here.

Office 365 Integration: How to connect local Excel files to the Microsoft Office 365 cloud?

You can connect local Excel files to the Microsoft Office 365 cloud using the Cloud Connector for Office 365 & SharePoint 2010. A sample connection configuration file is given.

Office 365 Cloud Connector: How to identify the required provider / driver names?

How to identify the provider / driver names required for the Cloud Connector configuration? See the invariant names in the web.config.

Office 365 Integration: How to connect on-premise SharePoint to the Microsoft Office 365 cloud?

You can connect your local on-premise SharePoint to the Microsoft Office 365 cloud using the Cloud Connector for Office 365 & SharePoint 2010. A sample connection configuration file is given.

Office 365 Integration: How to debug issues with Cloud Connector

You can use debug level trace with the Cloud Connector for Office 365 & SharePoint 2010 to solve issues.

Office 365 Integration: How to connect MS Dynamics CRM on-premise to Microsoft Office 365?

You can connect your local on-premise Microsoft Dynamics CRM to the Microsoft Office 365 cloud using the Cloud Connector for Office 365 & SharePoint 2010. A sample is given.

Office 365 & Azure Integration: How to connect a SQL Azure table to native SharePoint lists?

Office 365 or SharePoint Online can link to Azure documents using an Azure-based link list and replication via the Cloud Connector.

Native SharePoint lists as SQL Azure Web Frontend with full CRUD

It's easy to connect native SharePoint 2010 lists to SQL Azure tables and queries codeless and in just minutes. Optionally the connection can be bi-directional with two-way data replication.

Twitter & Office 365 integration: How to replicate Twitter feeds to native SharePoint lists, e.g. in Office 365

This FAQ is about integrating / replicating Twitter feeds with native SharePoint lists - on-premise or in the cloud.

How to replicate Salesforce data to SharePoint Online / Office 365 or SharePoint 2010?

The Cloud Connector can be used to connect any Salesforce data to almost any other data source, including native SharePoint lists in the SharePoint Online / Office 365 cloud or in SharePoint 2010 on-premise without any programming in some minutes only.

SAP integration with Office 365 and SharePoint Online: Step-by-step

SAP integration in Office 365 and SharePoint Online is explained step-by-step. Native SharePoint lists are connected to SAP data with all usual SharePoint list features available, e.g. change notifications and workflows.

How to push database field content to SharePoint metadata columns (and write back)?

The Cloud Connector can write metadata like Author, Editor, Creation data / time, last modification time to SharePoint. Here is how it works.

How to share pre-selected Intranet documents in a Microsoft Office 365 Extranet?

You can transfer pre-selected documents automatically from your local on-premise SharePoint document library to your SharePoint Online / Office 365 cloud-based extranet using the Cloud Connector.

"The Layer2 Cloud Connector is a great product to help integrate data into your Office 365 apps. Try it out and you will see many uses for it."

Dave Chennault, Skylite Systems

News

Microsoft Office 365 Business Connectivity Services now available with Layer2’s Cloud Connector V2.0

Layer2 today has announced V2.0 of its Cloud Connector replication service to integrate corporate on-premise data - e.g. files, SQL databases, ERP/CRM, Microsoft Dynamics CRM or NAV, SAP etc. - with the Office 365 cloud.

Office 365 and SharePoint: Layer2 Awarded Microsoft Gold ISV Partner Status

A Microsoft Gold Partner since 2009, Layer2 has again achieved the highest level of Microsoft certification as ISV partner and met the Microsoft Partner Network requirements with new SharePoint 2010 and Office 365 web parts and extensions for the Cloud.

More...

Cloud Connector for Microsoft SharePoint 2010

Related Downloads

Flyer: Layer2 Partner Program

Partner with us as a software reseller or SharePoint service provider. There is a free partner program with up to 30% discount. Download as PDF.

Get in the Cloud – With your corporate data sources connected

Download this step-by-step instruction to connect your corporate or cloud data sources bi-directional to any Microsoft SharePoint Server 2010 in the cloud, including Microsoft Office 365.