Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Import data from SAP? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    We are looking to import actual dollars and actual hours charged to specific WBS records in SAP into specific fields in Project Pro schedules.  We haven't fully mapped out the plan on exactly how we are going to accomplish the export/import yet but the initial thought is to write the data from SAP into a SQL table that can then be used to import into the Project Server databases.

    We've already created the custom fields in Project Server where we want to write the data but aren't sure how we can actually get the SAP data into the correct database so it resides in the fields where we need it.

    Can anyone tell me if:

    1) this kind of import is possible
    2) which database would we have to connect to on the Project Server side to write the data to

    Thanks for any thoughts and/or suggestions.

    DJ Johnson

    Thursday, March 7, 2013 4:29 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Daren,

    Please refer the following on SAP and Project Server integration:

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

      You can import SAP data into custom SQL tables using standard database tools (Export/Import, Integration Services etc.).  The important step is to show the data in Project Pro schedules, to do that you have use Project Server web service (PSI).  PSI will read the data from custom tables and update/create the data in appropriate Project Server databases.  So, you can see the SAP data in Project Pro schedules. The above link have the document which will give detail explanation about mapping the resource data, project task data using SAP/Project Server/PSI components.

    Thanks
    Chak

    Chak Tukkadi pVector Technologies Consulting: http://www.pvectortech.com Blog: http://www.epmcentral.com

    Thursday, March 7, 2013 5:06 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Daren,

    Please refer the following on SAP and Project Server integration:

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

      You can import SAP data into custom SQL tables using standard database tools (Export/Import, Integration Services etc.).  The important step is to show the data in Project Pro schedules, to do that you have use Project Server web service (PSI).  PSI will read the data from custom tables and update/create the data in appropriate Project Server databases.  So, you can see the SAP data in Project Pro schedules. The above link have the document which will give detail explanation about mapping the resource data, project task data using SAP/Project Server/PSI components.

    Thanks
    Chak

    Chak Tukkadi pVector Technologies Consulting: http://www.pvectortech.com Blog: http://www.epmcentral.com

    Thursday, March 7, 2013 5:06 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you Chak!  This looks like EXACTLY the type of information we are looking for!

    DJ Johnson

    Thursday, March 7, 2013 6:08 PM