#ProjectOnline data via #ODATA and #SSIS in #SQL database table delta sync example #BI #Office365

Microsoft recently released some great documentation and an example SSIS package on only pulling down the changes from Project Online to your custom SQL database – this will improve the efficiency of your Project Online SSIS packages. I recommend you take a look if you haven't already: http://msdn.microsoft.com/en-us/library/office/dn794163(v=office.15).aspx http://www.microsoft.com/en-us/download/details.aspx?id=43736 For a walkthrough of an example SSIS...

#ProjectOnline data via #ODATA and #SSIS in #SQL database table on-premise #MSProject #SharePointOnline #BI #SSRS #Office365 #Cloud

Following on from my post earlier today regarding the SSIS component that enables you to extract data from ODATA feeds in Office 365, I have created a blog post that demonstrates this new functionality. See the steps below: Firstly I installed the SQL Server data tools and Integration Services feature on my Test Project Server...

#Odata #SQL SSIS component now available for SQL Server 2012 #ProjectOnline #SSRS #SharePointOnline #SharePoint #BI

Quick post to let you know that the SSIS component to export data via ODATA that was mentioned here is now available for download, see the link below: http://www.microsoft.com/en-us/download/details.aspx?id=42280 This will enable you to copy data from Project Online into a custom SQL database, from there you can easily create SSRS reports, custom OLAP cubes,...

#SSRS for #ProjectOnline by #FluentPro #PS2013 #Office365 #Cloud

A quick post to highlight a recently approved app that allows you to report on your Project Online data with SSRS! http://office.microsoft.com/en-gb/store/fluentpro-online-reporting-services-WA104196765.aspx This is great, something I know  a lot of people would have been waiting for!

#ProjectServer #Excel report with SQL Temporary Tables #PS2010 #PS2013 #SQL

I came across an issue a while back and meant to blog about it but forgot until a colleague of mine today mentioned the same issue. This jogged my memory of the fix so I thought it was a good time to write the post. The issue isn’t Project Server related but the reports and...

#ProjectServer #SSRS Report with multivalued parameters #SQL #PS2010 #SP2010

A quick blog post to highlight the use of one of the Project Server Reporting database functions to resolve an issue when using an SSRS multi value parameter. There are several methods to get multi value parameters working in SQL Server Reporting Services (SSRS) including dataset filters, joining parameters and custom SQL functions – other...

#ProjectServer #PowerView report in #Excel 2013 #PS2010 #PS2013 #Office2013

This post will take a brief look at creating a map view of Project Server data – this does assume you tag your projects with a location! For the purpose of this post I will use the example Excel file shown below – this pulls data from one of my test Project Server PWA instances,...

#ProjectServer 2010 Resource assignments display issue #PS2010 #SP2010 #PS2013 #SP2013

Recently I was reminded of a minor issue that I thought I would share with you. While working with a client for a recent migration from Project Server 2007 to Project Server 2010, a query was raised regarding material resources and the resource assignment view in PWA. Material resources show a work and remaining work...

#ProjectServer optimisations for #SQL Server and #PS2010 databases #SP2010 #MSProject

https://technet.microsoft.com/en-us/library/cc298801(v=office.14).aspx#Section6_3A quick blog post to show the recommended SQL Server and database settings for optimal performance of your Project Server environment. See the SQL queries below along with the TechNet documents for reference. SQL CLR: sp_configure 'clr enabled', 1 go reconfigure go Print 'CLR Enabled' https://technet.microsoft.com/en-us/library/ee662108(v=office.14).aspx#section3 SQL Server MAX Degree of Parallelism (Specific for SharePoint...

#SharePoint 2007 / 2010 and #ProjectServer 2007/ 2010 #BI Reporting made easy #SP2010 #PS2010 #businessintelligence #SQL

Following from my previous post where I briefly introduced a new product from CPS called SharePoint ReportLink, as promised, this post demonstrates the ease of use and ease of reporting on SharePoint data when using SharePoint ReportLink. For the purpose of this blog post, I have already deployed the solution to my test VM. Worth...