Project Online: Demonstration package for OData and SSIS

Thanks Marc Boyer and Diane Diaz for the new document and demonstration package that shows how to do incremental downloads of assignment time phased data from Project Online Project Web Apps into a SQL Server database table.  This makes use of the SQL Server Integration Services (SSIS) OData feed that was introduced earlier in the…


Project Online: Updating OData connections in Excel for different PWA instances

Interesting question came in from one of our good partners, Campana and Schott, concerning the update of the connection string for Excel reports based on OData when moving the Excel books between different Project Online tenants.  This works just fine when just using the normal Excel features such as PivotTables – but you run into…