We have an on-premise oracle database with customer info (lets say roughly 10,000 rows), that we need to make available in our SharePoint Online (2013) environment in O365.

The requirement is that the data be re-usable anywhere in our SharePoint tenancy, so we would need to reference this customer info (read only) in all of our site collections.

Being new to these type of interfaces, what are the best options for accomplishing this?

Much appreciation in advance!

  • 1
    Will this be a hybrid solution (on premise SharePoint Server with a BDC to Oracle, and SharePoint Online connected to on premise SP), or a cloud only connection? Deploy a Business Connectivity Services cloud-only solution in SharePoint 2013 – Benny Skogberg Feb 4 '14 at 3:47
  • This would be a cloud only connection. We have no on-premise sharePoint. Currently, we are not leveraging any external facing web services and most of our data and business systems are behind our local firewall which requires VPN to hit. – Brent Ellis Feb 4 '14 at 14:19
  • Brent, I am also looking for a same system. Did you find a way of doing it ? – Ahmed Masud Jun 25 '14 at 8:39
  • Ahmed, we are building an on-premise OData web service and using materialized views to access our data. From SharePoint we are using Business Connectivity Services (BCS) to connect to our web service. This makes the data viewable as a SharePoint list or selectable as a column of metadata. The limitations are the SharePoint call to the web service can only return a maximum of 5000 items at once, so we have to use some creative paging/filtering to make sure that the amount of data returned does not exceed 5000 at one time or you get an error. Recommend reading/watching Fabian Williams stuff – Brent Ellis Jun 26 '14 at 13:12

Your Answer

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

Browse other questions tagged or ask your own question.