MS Project data in SQL Server

sql sql-server sharepoint business-objects ms-project
JPVoogt picture JPVoogt · Dec 9, 2012 · Viewed 12.1k times · Source

I have been given the task to Load all our company's project data from MS Project into SQL Server to be able to create reports and dashboards from the project data.

I know you can export a specific projects data into a access database, but every project must have it's own access database. So my first thoughts was to create some kind of dynamic access SSIS connector and ETL. So that the project managers export their projects to access and the SSIS package takes care of the rest.

Is there a simpler way of doing this?

My company also have a SharePoint infrastructure as well as SAP BusinessObjects infrastructure. Is there a way I can accomplish this by the use of SharePoint or bobj

Answer

melan picture melan · Dec 10, 2012

The simplest but costy way is called MS Project Server - it stores all data in MS SQL database already, has precalculated reporting database and so on. Here is a link http://technet.microsoft.com/en-us/evalcenter/hh973404.aspx. The last version can be either installed locally or hosted by Microsoft.

Another option I see is to use kind of automation around MS Project which will load project plan, extract all interested information and upload to to your database. There is no big magic in this solution.

The third option is to export projects to XML and then use the XML to upload data to SQL Server database. This solution is also doable through Project automation

Related questions

How to Query Sharepoint List Data?

Does anyone know how to fetch Sharepoint List data using sql query based on the particular sharepoint user.

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More