none
PSI API for Project Server 2010 RRS feed

  • Question

  • Hi,

    I am creating third party timesheet application in Oracle ADF. I am trying to acess Project Server 2010(SQL Server Database).

    I have created web services data conrol and Provided necessary wsdl for Project, Resource and Timesheet.

    I want to write Program to read and write data into Project Server Database.

    How I can start with ?

    Can you Please give me code refrence for this case?

    Wednesday, November 21, 2012 4:54 PM

All replies

  • Hi there,

    I would start with the Project 2010 SDK for code examples:

    http://msdn.microsoft.com/en-us/library/ms512767(v=office.14).aspx

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Wednesday, November 21, 2012 10:31 PM
    Moderator
  •  Hi Savan, you do not want to write any information to existing tables in the project server databases. puts you in unsupported mode right away. You could write your own database application and create tables in the reporting database.

    As stated look to the SDK for examples and search on psi or go to this overview:

    http://msdn.microsoft.com/en-us/library/office/ms457477(v=office.14).aspx

    You will need visual studio, need to compile the PSI DLL and have a bunch of reading ahead of you. Search this forum as well. lots of goodies here.

    good luck!


    Ray Letts Arbutus Solutions

    Wednesday, November 21, 2012 10:36 PM
  • Hi Ray,

    Thank you very much for your response. I am new in development please assist me I have some questions.

    As you mentioned the If i write any information in the existing project server tables puts me in unsupported mode even I use PSI API from third party application(In my case Oracle ADF Application).

    Please give me some direction How I can use Oracle Jdeveloper instead of visual studio for compile the PSI DLL to create third party application if is possible to do? if no, then How can Integrate visual studio compiled PSI DLL in oracle JDeveloper.

    Please provide me some thread links if you know any.

    Thank you,

    Savan Shah.

    Monday, November 26, 2012 2:58 PM
  • Hi Savan,

    You may need to create a WCF using the Project server's web services & then you can consume the WCF in your Java apps. 
    Please refer to below articles:
    http://msdn.microsoft.com/en-us/library/office/ee767684(v=office.14).aspx
    http://msdn.microsoft.com/en-us/library/office/ff843379(v=office.14).aspx
    http://msdn.microsoft.com/en-us/library/office/ff843378(v=office.14).aspx

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Tuesday, November 27, 2012 5:54 AM
  • Ray,

    the PSI are WCF webservices which can be consumed in an Java environment. The challenge will be to establish the initial connectivity and lateron the PSI specific means of impersonation (adding some HTTP headers). It will not be necessary to create any C# (of VB.net) DLLs on the 'Microsoft' side, but you will not find much documentation that is directly applicable to your environment. I would recommend to start with a little Java sample to set up the connectity - e.g. reading a projectdataset for a given GUID. The main source of information will be generic 'How to connect to WCF from Java' questions. Once you have this up and running de details of the PSI become relevant - and you should start 'transposing' the Microsoft oriented documentation to your environment. As results are dataset oriented this should not be too difficult.


    Jan Cirpka

    Tuesday, November 27, 2012 6:43 AM
  • Hi Jan,

    Can you please give me some helpful link I can use 'connect to WCF From Java'. I have search and not found anything helpful.

    Can you please provide me sample code set up the connectity - e.g. reading a projectdataset for a given GUID.

    Thank you,

    Savan Shah.

    Thursday, December 13, 2012 10:38 PM