A double dose of Business Intelligence goodness today for Project Online users – and also applicable to Project Server 2013 – we have a new post from Marc on Creating burndown charts for Project using Power Pivot and Power Query, and some great news of the release of the SQL Server Integration Services (SSIS) OData connector for SQL Server 2012 - http://www.microsoft.com/en-us/download/details.aspx?id=42280, as announced at the Project Conference 2014 This connector will allow our Project Online customers to pull data from Project Online using OData to populate their own SQL Server (or other supported destination) databases. These could be online or on-premises – and would then open up the ability to report via SQL Server Reporting Services or any other desired reporting tools. We will have some getting started material coming soon (this will be on the Project blog – I will most likely post too on Project Support blog) but if you want to get started then take a look at Mike McLean and Andrew Lavinsky’s Project Conference session - http://channel9.msdn.com/Events/Project/2014/PC248. If you were at the conference you should remember the demo in the keynote if you didn’t see Mike and Andrew’s session. If you weren’t there then also see Ludo’s keynote - http://channel9.msdn.com/Events/Project/2014/KEY002 and Mike’s appearance to do the reporting piece at around 50 minutes.
And while I’m at it – I posted over on Project Support a posting about matching patches between client and server and also keeping clients at a common level - http://blogs.technet.com/b/projectsupport/archive/2014/03/25/project-server-patch-matching-from-client-to-server-is-it-necessary.aspx
Enjoy! And keep an eye out for Marc’s getting started documentation for the SSIS stuff – we will have some best practices for getting a good experience pulling OData from Project Online. I’ll certainly be posting again once I see it!
***Update - you might like to take a look at the posting from Paul Mather for a step by step walk through - http://pwmather.wordpress.com/2014/03/26/projectonline-data-via-odata-and-ssis-in-sql-database-table-on-premise-msproject-sharepointonline-bi-ssrs-office365-cloud/. Great article Paul! Our getting started documentation will also cover this, as well as other best practices around limiting data that you are returning to get the best experience - such as only getting the columns you need and filtering for a data range or looking for new data ***
A couple of recent posts worth highlighting. The first relates to installing SharePoint 2013 and Project Server 2013 on Windows Server 2012 R2 – and the need to have the new slipstreamed install packages. I was building up a virtual farm just last week and hadn’t realized that I’d added an R2 Server – and the SharePoint Pre-requisite installer was failing to configure IIS. Finally hit me that we didn’t support R2 until SP1, but even though I had manually created a slipstream by putting the SP1 bits in the Updates folder – the RTM pre-req installer was still giving me problems. The answer is out there - http://blogs.technet.com/b/office_sustained_engineering/archive/2014/03/03/announcing-availability-of-slipstreamed-office-2013-and-sharepoint-server-2013-with-sp1.aspx. The exact error you will see in the Microsoft SharePoint 2013 Products Preparation tool is “Application Server Role, Web Server (IIS) Role: configuration error”
*** Update 4/4/2014 - these slipstream releases are NOT affected by the recently announced issues with the SP1 package - http://blogs.msdn.com/b/brismith/archive/2014/04/03/project-server-2013-and-sharepoint-2013-sp1-download-deactivated.aspx ***
The other post of note – and thanks to Marc, Heather, Mike and I’m sure plenty of others – we have a great post on Power BI for Office 365 as it relates to Project Online - http://blogs.office.com/2014/02/27/power-bi-for-office-365-with-project-online/ a great read!
Just realized the post is tagged for Project Server 2013 and Project Online – although SP1 is only relevant to the former, and Power BI to the latter.
If you missed the Project Conference, or you were there but missed some of the sessions then the recordings are just what you have been waiting for. Go to Channel 9 - http://channel9.msdn.com/Events/Project/2014/.
And as this is my blog and no one can stop me – I’ll give you hand-crafted links to the sessions I was involved in… Don’t worry, no cameras, just voice. I’m the English sounding one.
First Impressions supporting Project Server 2013 and Project Online – this one was just me talking about Project Online and how we support it.
Troubleshooting Tips for Project and Project Server – tag team with Adrian Jenkins talking deep about our troubleshooting tools
Project Worst Practice - Learning from other peoples mistakes – A trio of talent for your pleasure – Peter Kestenholz of Projectum, Ian White and me.
Chalk Talk and Q & A- Project Server IT-Professional – IT Pro panel talk – with folks too numerous to mention (ok – just don’t want to accidentally forget anyone).
Chalk Talk and Q & A- Running your PMO with Project Web App and Project Professional – same as above, but talking about PMO (when we managed to stay on topic).
*** Update 4/22 SP1 re-release
Stefan's blog has the full download links for SP1 http://blogs.technet.com/b/stefan_gossner/archive/2014/04/22/sp1-for-sharepoint-2013-has-been-rereleased.aspx
And patch again to avoid the lost resources issue - unless you also load April CU. http://support.microsoft.com/kb/2933444
*** Update 4/3/2014 - as a precaution both the SharePoint and Project Server SP1 downloads have been temporarily made unavailable - more information when I have it. The KB articles have been updated with:We have recently uncovered an issue with this Service Pack 1 package that may prevent customers who have Service Pack 1 from deploying future public or cumulative updates. As a precautionary measure, we have deactivated the download page until a new package is published.***
Busy day in Project Blog land – SP1 for Project 2013 and Project 2013 is out – see http://blogs.technet.com/b/projectsupport/archive/2014/02/25/project-2013-and-project-server-2013-service-pack-1.aspx
A couple of points to note – if you updated the sproc mentioned in KB 2933444 then you will need to update it again after applying SP1 as we re-write the sprocs (double checking this (thanks Corrie!)) – and if you didn’t – perhaps you should?
And the other point – the SP1 Server side scheduling engine reports a lower version number than the client – so if you want to control the allowed version of Project Professional that can connect then just go for 15.0.4569.1000 and all will be good!
Just in case you are in the dark ages and still on Project or Project Server 2003 – the article over on the Project Support blog will help you move on up before support runs out on 8th April 2014 - Project 2003 and Project Server 2003- End of Support Life Announcement