SharePoint 2013 and Project Server 2013 Preview Installation with PowerShell

My first problem encountered – Create Web App Cmdlet requires a new parameter

WARNING: The Windows Classic authentication method is deprecated in this release and
the default behavior of this cmdlet, which creates Windows Classic based web applic
ation, is obsolete. It is recommended to use Claims authentication methods. You can
create a web application that uses Claims authentication method by specifying the Au
thenticationProvider parameter set in this cmdlet. Refer to the http://go.microsoft.
com/fwlink/?LinkId=234549 site for more information. Please note that the default be
havior of this cmdlet is expected to change in the future release to create a Claims
authentication based web application instead of a Windows Classic based web applica
tion.

I just had to specify  -AuthenticationMethod  per graphic

image

 

To create a Project Web App is changed and not well documented in the Preview. It took a few tries but I got it to work. Here is what you need to do different.

The four databases in Project Server 2010 are combined into a single Project database in Project Server 2013 Preview. Custom SQL for Reports should use only the reporting tables and views, which have the dbo prefix, and are in Lower Case. All other tables in upper case are not to be touched because the Project Professional cache, the tables for draft and published data, and the reporting tables all rely on a cache synchronization protocol that can be disrupted by direct data editing. The reporting tables and views are also exposed only by the OData interface, you can use the OData interface or directly access the reporting tables and views in the ProjectService database in the SharePoint farm.

The OData service internally runs SQL queries on the reporting tables and views, and delivers an XML or JSON payload. For an introduction to the OData service for reporting in Project Server 2013 Preview, and for the ProjectData schema reference, see ProjectData – Project 2013 OData service reference. For general information about OData queries, see OData: URI conventions. for example http://ServerName/ProjectServerName/_api/ProjectData/Projects?$filter=startswith(ProjectName, ‘Test’) eq true

To import project data into PowerPivot in Excel 2013 Preview, on the DATA ribbon, select From OData data feed in the From Other Sources drop-down menu. In the Data Connection Wizard dialog box, type http://ServerName/ProjectServerName/_api/ProjectData/ in the data feed location, choose Next, and then select the Projects table in the Select Tables page of the wizard. Name and save the .odc file, and then choose Finish. In the Import Data dialog box, choose PivotTable Report. On the Excel worksheet, choose fields for the pivot table rows and columns that you want to show.

You can also retrieve Project Server data online or on-premises through REST endpoints for the OData service. For preliminary documentation of the OData XML schema for the ProjectData service, see ProjectData – Project 2013 OData service reference.

Additional resources


Advertisements