Determine the TCP/IP Port Number of the Primavera Database

The Estimate Primavera Integration connects to the Primavera database using a host name and port number. You will need to know what port number to use in a later setup step.

Use the following step-by-step to view the Primavera TCP/IP Port Number.

Step by Step — Find the TCP/IP Primavera Port Number

  1. From the main Primavera client menu, choose Help.

  2. Then select About.

  3. Select the System tab.

  4. Locate the Bre Database line.

    5. Primavera v6.x and P6 v7 require Java Runtime Environment (JRE) version 1.4 or above. P6 v8 - P6 v8.4 require the i586 version of the Java Developer’s Kit (JDK) version 1.6.0_23 or above. The Primavera integration with Estimate will not function correctly with older versions of Java.

  5. The port number displays after the server (host) name and before the database instance name.

    • In the following example, the port number for the Microsoft SQL Server Primavera Database Server is 49251:

      • BRE Database: com.microsoft.sqlserver.jdbc.SQLServerDriver,

        jdbc:sqlserver://server1:49251;database=pmdb; 8.0, INTERNAL_PLUGINS)

    • In this example, the port number for the Oracle Database Server is 1521:

      • BRE Database: oracle.jdbc.driver.OracleDriver,

        jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Server2)

        (PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE))) (, 7.0, INTERNAL_PLUGINS)

  6. Take note of the port number. Then select Close to exit the About Primavera dialog box.

The integration of Primavera v6.x or P6 v7 with Estimate requires the Java Runtime Environment (JRE) to be installed on the Primavera Integration Server machine. The integration of P6 v8 - P6 v8.4 with Estimate requires the Java Developer’s Kit (JDK) to be installed on the Primavera Integration Server machine. If you are running 64-bit Windows, a 64-bit JDK is required. Install these files after following the previous step-by-step.