Connecting on premises MySQL database from SharePoint online

Hi

We have our portal on SharePoint online and we would like to get real time data from MySQL available at on premises.

Requirement is when we get new lead data from MySQL, I would like to create new document set (by specifying lead data) in SharePoint online.

Once Document set is created belonging to new lead, user can upload documents (under document set) related to lead in SharePoint online.

would like use out of box capability to achieve above requirement. appreciated to get solution on above requirement.

Best Regards,

Safder

May 20th, 2015 3:24am

External data can be used as metadata with Business Connectivity Services (BCS).

With SPO, your MySQL data needs to be cloud accessible... that means either a hybrid farm, or a WCF endpoint for SPO to connect to.

Free Windows Admin Tool Kit Click here and download it now
May 20th, 2015 10:23am

Thanks Scott for your prompt response

Is it possible to have hybrid farm in case we have SP 2010 at on premises.

We are also thinking to have approach were can have window scheduler running at on premises.  window scheduler will fetch data from MySQL and push data to SPO using client side object model. could you share your view on this approach.

Further could you let us know how document set would be created dynamically (by getting MySQL lead data from on premises when new lead is added to MySQL) using WCF endpoint for SPO.

Thanks

Safder

May 21st, 2015 1:41am

Hi Safder,

Hybrid solution with SharePoint Online is not available for a SharePoint 2010 on-premises environment. To experience the SharePoint Hybrid feature, SharePoint 2013 is required.

You can write data to SharePoint Online using client object model.

Here is a link about how to connect to SharePoint Online using client object model from external environment for your reference:

http://tomaszrabinski.pl/wordpress/2013/03/18/connecting-to-office-365-using-client-side-object-model-and-web-services/

To get data from local MySQL data, as Scott suggested, you need to port the required databases to Azure SQL and sync that with On-premises SQL.

And then connecting Azure SQL with BCS in SharePoint Online.

http://blogs.msdn.com/b/alimaz/archive/2014/07/31/connect-sharepoint-online-to-an-on-premises-sql-server-from-an-azure-provider-hosted-app-using-hybrid-connections.aspx

http://blogs.msdn.com/b/steve_fox/archive/2012/02/07/sharepoint-online-and-windows-azure-developing-secure-bcs-connections-using-wcf-services.aspx

Thanks,

Victoria

Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2015 2:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics