Share via

Using the Service for EDM

  • Article

The Project Data Service (PDS) provides the primary interface to integrate Microsoft Office Project Server 2003 with other business applications. The Service for Enterprise Data Maintenance (EDM) builds on the PDS to provide a higher-level API and easier ways to exchange data between Project Server and other applications. Data exchange can be accomplished through a file drop mechanism or through a SOAP programmatic interface. For more information, see About the Service for EDM.

The ERP Connector Solution Starter uses the Service for EDM file drop to automatically execute the underlying PDS methods and extensions for integration with the mySAP™ ERP Human Capital Management and Financials solutions. To export actuals to mySAP ERP, the ERP Connector also drops XML files in a directory for the Service for EDM. The Service for EDM listens to that directory, and sends the files to the ERP Connector service, which validates and processes the XML data for mySAP ERP.

To use the Service for EDM:

  1. Configure the file drop location and monitor settings on the Project Server computer, as described in Configuring the Service for EDM.

    Note  The registry already includes Service for EDM settings for the default Project Server URL. You can use the default file drop setting for the ERP Connector if that is the only location and Project Server URL the Service for EDM needs to monitor. You must create a unique monitor location for each application and for each Project Server URL that uses the Service for EDM.

    The following registry key specifies the default monitor settings:

    [HKLM]\Software\Microsoft\Office\11.0\MS Project
   \Services\Configuration\Connector\ProjectServer1

    For example, if you use both of the Project Server URLs http://ServerName/ProjectServer and http://ServerName/Sample, create an additional file drop directory and a new Service for EDM location.

    [HKLM]\Software\Microsoft\Office\11.0\MS Project
   \Services\Configuration\Connector\SAPConnector4Sample

    Make sure the Project Server URL string value in the SAPConnector4Sample key is set to the correct URL, for example http://ServerName/Sample. If the Project Server Connector Service is already running, you need to stop and restart it.

  2. Start the Project Server Connector Service.

    • On the Windows Start menu, click Run, and then type services.msc.
    • In the Services window, right-click Project Server Connector Service, and then click Properties.
    • In the Project Server Connector Service Properties dialog box, click the Log On tab. You should change the logon account from the local system to a domain user that has administrative rights on Project Server. If you do change the account, click Apply.
    • If you want the Project Server Connector Service to start whenever Windows starts, on the General tab, change the Startup type to Automatic. Click Start, wait to see the service status change to Started, and then click OK.
    • Restart Internet Information Services (IIS) to initialize it for the new Service for EDM sites. In a Command Prompt window, type iisreset /restart. Or, in the Internet Information Services Manager, click the local computer name, in the Action menu click All Tasks, and then click Restart IIS.

  3. Set directory permissions. Add NETWORK SERVICE read/write access for the file drop directory and for the directory where you installed the ERP Connector Admin Web page. The following example uses the default directories.

    • Right-click the directory [Program Files]\Microsoft Office Project Server 2003\BIN\Connector, click Properties, and then click the Security tab.
    • Click Add, and in the Select Users, Computers, or Groups dialog box, click Locations. In the Locations dialog box, click your local computer name, and then click OK. Type NETWORK SERVICE in the text box of the Select Users, Computers, or Groups dialog box. Click Check Names, and then click OK.
    • In the Connector Properties dialog box, click the NETWORK SERVICE user name, and then check the following boxes in the Allow column: Read & Execute, List Folder Contents, Read, and Write. Click OK.
    • Add the NETWORK SERVICE user and the same permissions to the directory [Program Files]\Microsoft Office Project Server 2003\IIS Virtual Root\SAPConnectorAdmin.

  4. Use the Internet Information Services Manager to make sure anonymous access is disabled for the pds.wsdl, pds.wsml, pdsbiz.wsdl, and pdsbiz.wsml files in the Project Server virtual directory.

    • On the Windows Start menu, click Run, type inetmgr, and then click OK.

    • Expand the Default Web Site, and right-click the virtual directory name (for example ProjectServer), and in the right pane, right-click on each of those files.

    • Click Properties, click the File Security tab, click Edit, and make sure Enable anonymous access is cleared. You can also check the security settings for individual files if you are not sure they have the same settings as the parent virtual directory.

      Note  Anonymous access is disabled by default in IIS 6.0.

  5. Adjust settings for the SOAP call. The execution time of some PDS extensions can result in a timeout, and the SOAP message size can exceed the default limit. To prevent these errors, change the following settings:

    • On the Windows Start menu, click Run, type regedit, and then click OK. Using the Registry Editor, change the Service for EDM timeout to 300000 milliseconds (5 minutes), or adjust as you need in the registry connector key you are using for the ERP Connector. If you are using the default Service for EDM connector, edit the following key:

      [HKLM]\Software\Microsoft\Office\11.0\MS Project
   \Services\Configuration\Connector\ProjectServer1\Timeout

    • With the registry editor still open, increase the maximum HTTP POST size for SOAP. The default value is 102400 bytes (100 KB). Change the MaxPostSize value to 204800, which is 0x32000 bytes (200 KB) in the following key, or adjust as you need.

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSOAP\30\SOAPISAP

      Note  If the previous key is not in your Project Server computer's registry, then the SOAP Toolkit 3.0 is not installed. You can download soapsdk.exe from SOAP Toolkit 3.0 in the Microsoft Download Center. Although the SOAP Toolkit is now deprecated by the Microsoft .NET Framework, the Service for EDM uses the SOAP Toolkit.

    • Change the connection timeout of the default Web site on the Project Server computer. On the Windows Start menu, click Run, and then type inetmgr. Expand the local computer Web Sites, right-click the Default Web Site, and click Properties. The default setting of Connection timeout on the Web Site tab is 120 seconds; change that to 300 seconds (5 minutes), or adjust as you need. Click OK, and then close Internet Information Services Manager.