Office 365: How to migrate or integrate enterprise data to the cloud?

A data-integration strategy needs to be within the foundation of every 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 😉

But migration and especially integration of external data to the Office 365 cloud is difficult using out-of-the-box features. No Business Connectivity Services are provided. And if it will be provided, in most cases it would not connect to remote corporate data sources for security reasons.

3rd party tools could help in this case. The Cloud Connector for Microsoft SharePoint 2010 and Office 365 takes local line-of-business data to the Office 365 cloud-based or any other hosted SharePoint. Content hosted in almost any corporate data source, e.g. databases, files, ERP/CRM/ECMS or other legacy platforms and on-premise applications like Exchange, Active Directory or even SharePoint itself is replicated to native SharePoint lists into the cloud via secure web services. All features of native SharePoint lists are completely available for the external data.

While the SharePoint Business Data Catalog (BDC), the SharePoint Business Data Connectivity Services (BCS) or the SQL Server Integration Services (SSIS) out-of-the-box are not made for cloud-based scenarios, the SharePoint Cloud Connector was especially developed to solve the specific challenges of disconnected systems in the cloud without any direct access to corporate business data and very restricted feature customization capabilities.

Databases and files can easily connected to Office 365

SharePoint Cloud-Connector for Office 365 - Architecture

How does it work? Easy…

  • No programming or tools required. Setup in a few
    guided by a wizard.
  • No installation or customizing in the SharePoint Office 365 cloud
  • Compatible to all SharePoint offerings, including on-premise, sandboxed,
    e.g. Microsoft SharePoint Online / Microsoft Office 365.
  • 100% Microsoft SharePoint 2010 compatible – Uses new CSOM API model for the cloud.
  • Secure data connection and transfer: Connection via Web
    Services (SSL). Disconnected systems: A connection is only required for data
    exchange – not for list usage. No direct access to external company data
    required (“push” – no “pull” strategy). The application runs where your
    data resides today – on any server or client inside your corporate network.
  • Virtually any data sources supported: ODBC, OLEDB,
    .NET-based providers, Files (Excel, XML, CSV), SQL databases like Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint ;-), Exchange, Active Directory, Navision, SAP and many more. More complex data sources, e.g. web services, custom COM or .NET objects, can be connected using Enterprise Enabler or other 3rd party tools.
  • Start workflows in the cloud – on external data change: All
    features of native SharePoint lists are supported, e.g. RSS, change
    notifications per email or workflows on external data change.
  • Additional “SharePoint-only” columns can be created, e.g.
    for ranking, rating, comments or file attachments.
  • Data aggregation: Multiple connections can rollup several
    different data sources to one list.
  • High performance: Can manage large databases and lists.
  • Very costeffective solution – easy to setup and maintain.
  • The connector is based on another very successful Add-on, the Business Data List Connector für SharePoint (BDLC).

Just try it out. My personal fav is the SharePoint to SharePoint connection, e.g. for content deployment or aggregation. The Shareware is FREE, a Professional version available for download after registration:

This entry was posted in Office 365, SharePoint, SharePoint 2010. Bookmark the permalink.

One Response to Office 365: How to migrate or integrate enterprise data to the cloud?

  1. There is a video available for showcase the connector at YouTube:

    Thanks, SharePointFrank

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s