How to Integrate Primavera with SAP ERP

Recently, One of my clients is implemented SAP EPR. The Top Management wants to establish Integration between SAP & Primavera. Management wants that Projects should be created in the SAP PS module and then should be moved to Primavera for scheduling & monitoring purpose.

In this post, I will share my experience of SAP-Primavera connection establishment via API method.

Basically, the entire connection establishment process can be divided into three phases.

1. Configuration required at infra, Network & Server end
2. Installation & configuration required at Primavera Application end
3. Installation & configuration required at SAP ERP end

1. Configuration at Network & Server end:
 – Applications, Database & API servers must communicate with each other.
For this, you need to coordinate with the Network/Firewall/Server team to open the SAP application ports, Primavera application ports & RMI ports.

Please ensure the network connectivity between following servers on required ports

a. Primavera P6 Integration API server must be able to connect to the Primavera Database Server. To get steps, refer my post how to connect Primavera database with Primavera Integration API
b. SAP EPC server must be able to connect to both the SAP ERP and Primavera P6 Integration API Server.
c. SAP EPC components should be able to establish network communication using Java RMI with Primavera P6 API                application running in REMOTE mode.
d. SAP EPC components should be able to establish network communication using SAP RFC and HTTP/HTTPS network protocols.

I will suggest you, ask the Network/Firewall team provide the result of a successful telnet connection as communication is one the biggest reason for error during the connection establishment.

2. Installation & configuration required at Primavera Application end
2.1 Install the Primavera P6 Integration API in Remote mode (Server Side application). Refer my post on Primavera P6 Integration API remote installation mode to get installation steps 

2.2 Configuration & Deployment Primavera P6 Integration API: Refer my post on How to create WebLogic domain and Deploy Primavera P6API.war 
2.3 RMI server configuration in P6 Administration.
Set the Primavera administrator settings (Integration API Server/RIM) as below to use port RMI port to get connected to API server.

2.4 Primavera P6 user setup: Create a dedicated user to SAP-Primavera connection. Please ensure the user has following access & permission.

               – Global Security Profile: <Admin Superuser>
               – All Resource Access
               – Licensing: Project Management and Integration API
               – Module Access: Projects, Integration API, Portfolios, Resources

3. Installation & configuration required at SAP ERP end

3.1 Installation of Primavera P6 Integration API (client-side package): – Refer my post on Primavera P6 Integration API client side installation to get installation steps
By installing the client-side package, you will get the libraries (intclient jar) on SAP NetWeaver AS Java host machine.

Please note it down the location where the Primavera P6 Integration API client-side library (intgclient jar) is installed; you need to refer to it during the SAP EPC configuration process (below step no 3.5).

3.2 Installation of SAP EPC:  It uses Primavera P6 EPPM Integration API client which is using Java RMI to communicate to Primavera P6 Integration API Server (P6 Integration API REMOTE-mode installation) – Please refer SAP EPC doc for installing it

3.3 SAP EPC Configuration: Follow the below steps for EPC Configuration

1. SAP EC is configured through the product configuration template by accessing the following URL http://<host>:<port>/nwa.

2. On the SAP NetWeaver AS Java Administrator Console, go to Configuration, then Scenarios, then Configuration Wizard.
3. On the Tasks tab page, select the SAP Enterprise Project Connection. And Click Start
4. Log on as EPC_ADMIN.
5. On the Configuration Wizard, select your installation type I.e. Development or Production.
6. Select your configuration choices then click Next.
7. You are prompted for the SAP Enterprise Project Connection home path if you selected Development as the installation type. On the Deploy Solution page, enter the folder name on the server to which configuration copies SAP Enterprise Project Connection.

3.4 Connection Management: Managing Connections with Oracle Primavera P6 EPPM
SAP Enterprise Project Connection has two Primavera Adaptors: select Primavera Integration API one
2. On the Configuration Setup page, select Manage Connection with 3rd Party Systems.
3. Select Oracle Primavera Connection and Click Next.
4. Select the Primavera Integration API setup option and Click Next.

3.5 Configuration steps for the Primavera Integration API option:

   1. On the Oracle Primavera Configuration page, enter the path to the P6 EPPM Integration API client side library file intgclient.jar. (\\ <your_hostname>>\IntegrationAPI\clientlib\intgclient.jar) and click Next.
2. In the Primavera API Home field, enter the path to the P6 EPPM Integration API folder name.
Example – (\\<your_hostname>\C:\IntegrationAPI) if the P6 EPPM Integration API directory is shared.
   3. Enter the P6 EPPM User credentials (User with all required access & Permission)
   4. In Calling Mode, Remote is selected.
   5. In the Host field, enter the hostname or IP address where you deployed Primavera Integration API.
   6. In the Port field, enter the port number as configured in P6 Administrator, above step 2.3 (for example, default RMI port 9099).
   7. In the RMI Type field, select the RMI type (Keep it default standard)
   8. On the Test Oracle Primavera Connection page, click the https link.
   9. If browser authentication is required, enter the EPC_ADMIN information.

If the connection is successful, the browser returns a response XML with the Oracle Primavera system details.

3.6 SAP EPC to Oracle Primavera P6 connection Test:

Follow steps to validate that SAP EPC to Primavera connection:

a) Open Web browser, enter and execute the following URL
b) If prompted, enter epcrestuser as a username and password for this user.
c) If the connection is successful, below XML document structure is returned.

It will with the show a success with connection information or will show you SAP EPC exception with error details thrown by Primavera P6 Integration API.

Now the connection across SAP – Primavera established, and You are ready to move data between SAP & Primavera applications.