0

I'm alittle confused, when I google this all i seem to find is how to connect to sharepoint using a cloud hosted app hosted in windows azure, that's not what I'm looking for.

I've been creating Java applications that communicate with a MYSQL database, and now I want sharepoint to communicate with one of them.

What is the simplest way of doing this?

4

Depending on your specific requirements, the easiest way is probably to use BCS to create external content types that link to your MySQL data. Your SharePoint hosted app can then read/write that data more or less as if it was a standard SharePoint list.

The benefit of this approach is that it is quite quick and easy to set up. The downside is that it may be harder to implement complex business logic.

  • Doesn't this apply to Sharepoint Server only? or can I do this in Sharepoint Online? – Dr Cox Sep 3 '15 at 8:46
  • You can do it from SharePoint Online too. You just need to consider how to allow SharePoint Online connect to your database. – Steven Mulkerrins Sep 3 '15 at 10:01
2

Has nothing to do with SharePoint.

If you configure the server your MYSQL database runs on to accept Cross Origin requests you can access it from any environment.

A https connection is preferred, but not required when you manually instruct your browser to allow mixed content.

A REST middle-tier like ArrestDB in your stack simplifies access.

You are communicating from the trusted Inside (SharePoint) to the Outside; you can do anything you want. (I use this a lot to keep SharePoint Lists in sync with a public MySQL database which serve public websites)

From the cruel Outside world into SharePoint is a whole different ballgame which requires ADAL

Update

From the outside PHP world into Office365/SharePoint world there now is: https://github.com/vgrem/phpSPO

  • I want to be able to read the data from the database, just like from a sharepoint list for example. I didn't understand much of what you wrote, as I'm pretty new (1y) to programming overall, could you be more specific of what I need to look into & studie to be able to learn how to do this? – Dr Cox Sep 3 '15 at 12:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.