Relational Database for SharePoint through O365

Paul Ben
Paul Ben used Ask the Experts™
on
I am looking for a relational database solution that works with SharePoint O365.  I have developed a solution using AccessWeb but 1) it does not have that much functionality compared to Access and 2) I understand that AccessWeb is being phased out over the next year or so.

I would welcome some advice on what platform I can use to develop the RDMS.  I have looked at PowerApps but there does not seem to be much literature on how to build a full solution.

Any thoughts would be appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems Analyst
Top Expert 2007

Commented:
First are you referring to Access Web Database that was present in A2010 and connects to Sharepoint Lists?
Or
Access Web Apps that are present in A2013/16, wherein the backend is an SQL Azure db hosted by Microsoft and Sharepoint is the administrative part?

Well ... doesn't matter. Stay away from both.  AWA's are essentially history. Starting in June 2017, Microsoft will not even allow the creation of a new AWA within Sharepoint ... and by June 2018, any existing AWA SQL Azure backend need to be migrated elsewhere.

As for Web Databases ... these are essentially history as well. As you see, very little functionality. In fact a colleague at work JUST went through this process last week ... and quickly discovered the limitations.

So ... that leads us to Power Apps, where Microsoft if putting all their resources regarding this subject.  There is actually a lot of info on this highly 'dynamically moving target' (lol) ... starting at powerapps.microsoft.com .  The product is getting better as the days go on ... with MOBILE (and tablet) as the main goal in mind.  You can connect PAs to many different data sources, including SQL Azure, on premise SQL Server and so on.
Distinguished Expert 2017

Commented:
I don't think we have enough information to suggest a solution.  If you need the functionality of an Access database, then you could use Citrix or RD to support remote users.  If you need to support anonymous users, Access isn't even remotely usable and you'll need to go with some web tool to develop web pages.  It doesn't matter whether the BE is SQL Server, MySQL, Oracle or whatever.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems Analyst
Top Expert 2007

Commented:
"I would welcome some advice on what platform I can use to develop the RDMS.  "

SQL Azure backend, Access FE (linked to Azure SQL tables). You can manage the Azure db with SQL Sever Management Studio 2016 (free).
With this, you get the best of all worlds, including Power Apps for mobile/table.

azure.microsoft.com

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial