Forum Discussion
Project web app data to SQL Server
Hi,
we are running a Project web app instance on SharePoint which collects data of our MS project files.
Without any issue we can connect to the PWA SharePoint database using the ODATA feed connector in PowerBI.
We would now need to provide the PWA data to somebody outside of our organization. We tried allowing direct access to the PWA SharePoint database, but this seems not to work without classifiying the user as Admin of the PWA.
Is there a possiblity to move the PWA data to a SQL Server via SSMS?
Which other options would we have?
Thanks and Best regards
Hello ITManuelBI ,
Yes you can extract the data from Project Online PWA into Azure SQL, there are a few 3rd party tools that support this including a tool edison365 develop and sell called DataStore (https://edison365.com/) *Disclaimer - I work for edison365.
You could also build something yourself using Azure Data Factory Reading Project Online OData with Azure Data Factory | Microsoft Community HubDepending on what you do, you might need to be aware of Microsoft Multiplexing licensing.
Paul
