locked
Import data from SAP? RRS feed

  • Question

  • 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

  • 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

  • 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
  • Thank you Chak!  This looks like EXACTLY the type of information we are looking for!

    DJ Johnson

    Thursday, March 7, 2013 6:08 PM