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

Home > Paul Mather, Work > #ProjectOnline data via #ODATA and #SSIS in #SQL database table delta sync example #BI #Office365

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

August 11, 2014 Giles Hamson Leave a comment Go to comments

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

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://bit.ly/1svfgF2

http://bit.ly/1svffBe

For a walkthrough of an example SSIS package for Project Online see:

http://bit.ly/1jIsq9V

Or a great example from Martin here:

http://bit.ly/1svfgF6