How to Install Oracle Primavera SDK: A Comprehensive Step-by-Step Guide

There are many different project management tools, but Oracle’s Primavera P6 is one of the most trusted project management tools in the world. 

Oracle’s Primavera SDK (Software Development Kit) is available for advanced functionality, like integration of Primavera with other applications, and automating workflows.

As a powerful tool, the SDK provides developers with the ability to pull Primavera data into other systems and processes in a completely integrated fashion.

In this guide, we are going to walk you through the steps of installing the Primavera SDK which is what makes P6 work, so we can help you do it, even if you’re new to all this!

‍

What is Oracle Primavera SDK?

Your licensed Primavera P6 software includes an optional but very powerful feature called the Software Development Kit (SDK).

It is used as a mediating point for users to use Primavera’s backend database and have the opportunity to integrate with external systems and custom applications.

‍

Key Features of Primavera SDK

• Database Integration: Access to all project data stored in Primavera P6’s database tables, including activities, WBS elements, and codes.

• Custom Automation: It gives developers a way to write scripts or applications that talk to Primavera data.

• Advanced Reporting: It will automate data extraction and help create the reports according to your requirements.

But to effectively use the SDK you need to have a handle on database schemas; mapping data properly to the appropriate fields (unique project IDs and WBS codes) makes for good integration.

Boost Your Project Timelines with Scheduling Tools

Streamline project schedules and meet deadlines effortlessly with Clue and Primavera P6. Ideal for any project-driven industry, these tools optimize timelines, resources, and collaboration.

Read Our Blog⟶

‍

Why Install Oracle Primavera SDK?

Installing the SDK adds significant value to your Primavera P6 setup by enabling:

• Efficient Data Handling: Removes manual data extraction processes.

• System Integration: It seamlessly connects Primavera with ERP CRM or any other Enterprise Tool.

• Customized Solutions: Services that support specific project-tailored workflow and automation support.

• Advanced Reporting: It gives you granular data to create insightful, real-time reports.

The SDK bridge between project management tools and other business systems allows organizations that are dependent on Primavera P6 to become more productive and make wiser decisions.

‍

Preparations Before Installation

So before installing, there are a few things to check first to avoid hindrances during installation itself.

1. System Requirements

Make sure your system is equipped with:

• Operating System: Windows 10 or higher.

• Database Compatibility: Oracle Database or Microsoft SQL Server.

• Hardware: 2 GB free storage space and 8GB RAM (minimum).

‍

2. Software Requirements

• It is already installed, Primavera P6 Professional.

• Access of installation to your computer via administrative access.

‍

3. Accessing the SDK Files

The Primavera SDK installer is part of the Primavera P6 software package.

Your organization allows it to run under an enterprise license, so download it if you are on that enterprise license from the Oracle website or through your system administrator.

‍

Step-by-Step Installation Guide

We can break the process into smaller steps so it’s clearer.

Step 1: Find and Install SDK Installer

1. Go to your Oracle account and log in to it.

2. Simply head over to the Primavera P6 software section and proceed forward to download the SDK.
3. Once the ZIP file is downloaded, save it to another directory on your computer, which is accessible.

‍

Step 2: Extract the Installer Files

Once the download is complete:

1. Download the file, and open it with tools such as 7-Zip or WinRAR.
2. Then get the contents and extract it to a new folder, preferably on your desktop or some easily accessible directory.

‍

Step 3: Begin the Installation

1. Extract the files and open the folder.
2. Locate the setup.exe file and run it as an administrator by right-clicking and then selecting “Run as Administrator”.

3. Follow the on-screen instructions given by the installer wizard. Choose Typical Installation type.

Step 4: Configure Database Settings

When installing the SDK, you will be asked to connect the SDK to your Primavera database. Here’s how to proceed:

• Choose Database Type: Choose between Oracle Database or Microsoft SQL Server.

• Input Server Details: Provide your server name, including the port number (by default 1521 for Oracle and 1433 for SQL Server).

• Authentication: Enter your database username and password.

Check to see if everything is set up correctly by testing the connection.

‍

Step 5: Finalize Installation

When the database configuration is finished, then install the SDK following the wizard’s prompts. It will show a confirmation window when done.

‍

Key Post-Installation Steps

Additional steps to get it working smoothly are usually needed after installation.

1. Verify the SDK Installation

To confirm the SDK is correctly installed:

• Open Primavera P6 Professional.

• Then check the system settings to ensure that SDK-related tools are available.

‍

2. Configure ODBC Connection

Database communication into Primavera SDK is done through ODBC (Open Database Connectivity).

Follow these steps:

• Head over to Windows, and then open the ODBC Data Source Administrator tool.

• Click on Select Add New Data Source, then choose the appropriate database driver.

• Write the same database credentials that were used during SDK installation.

• Ensure the successful configuration and then test the connection.

‍

3. User Permissions

Grant necessary permissions to users who need SDK access:

1. Once you are logged in as an administrator, it will open the Primavera P6.
2. Go to user settings and give SDK-related roles.

‍

Troubleshooting SDK Installation Issues in Primavera

Primavera P6 Software Development Kit (SDK) serves as a good aid for users who require direct access to Oracle P6’s large data of project management information.

The SDK offers a link to the database to be used in connection with third-party application extensions, detailed report generation, or extraction of data from the database.

That said, the installation and configuration process of the SDK can be complex, filled with hurdles that could later become problematic for the users. 

This guide will enable developers to have an overview of some of the most frequently occurring problems, their root causes, and how to avoid the issues likely to cause problems in the setup of SDKs.

‍

Common Installation Issues and Troubleshooting Steps

1. SDK Component Not Available During Installation

Some users may find that they cannot see the installer's option to add the SDK during installation.

Which components of the SDK appear in your installer relies on which version of Primavera P6 you have installed.

While Oracle does offer an SDK, it has recently removed the option from newer Primavera P6 versions.

This is to encourage users to use modern integration methods like APIs and web services instead.

For Primavera P6 Versions 15.2 and Earlier:

1. Start setup.exe from your Primavera P6 installation disc.
2. To add or make changes, choose the "Modify" button inside the installer.
3. Click the "+" icon beside "P6 Professional Common Components" on the "Select Features" page.
4. Choose "Software Development Kit (SDK)", and install it on the hard drive of your computer.
5. Follow and answer all setup instructions.

For Primavera P6 Versions 16.1 and Later

Starting with version 16.1, Oracle deleted the SDK from their software. Using P6 Integration API or Primavera Web Services gives you better tools and is recommended if you are working with P6 version 16.1 and later. The SDK allows more complex connections and works with software hosted in the cloud.

‍

2. Database Connection Errors

Users encounter database connection issues during SDK setup, such as:

• “Bad public user name or password.”

• “Login failed for user 'pubuser'.”

• “Unable to connect to the database.”

These errors are typically caused by incorrect database configuration details, lack of permissions for the pubuser account, or improperly installed database clients.

For Oracle Databases

1. Verify that the Oracle client is installed and configured properly.
2. During installation, ensure the correct "Oracle Connect String" is entered in the SDK configuration. This string corresponds to the database's Service Name or SID.
3. Confirm that the pubuser account exists in the Oracle database and has the required permissions.

Use the ODBC Data Source Administrator to test the connection. Under "System DSN," select the Primavera SDK data source and click “Test Connection” to validate.

‍

3. ODBC Configuration Issues

After installing the SDK, users may find that the Primavera SDK Data Source Name (DSN) is not visible or does not work as expected.

Improper ODBC configuration or missing driver files can lead to these issues.

1. Open the ODBC Data Source Administrator:

• On 64-bit systems: Navigate to C:\Windows\SysWOW64\odbcad32.exe.

• On 32-bit systems: Use Control Panel > Administrative Tools > Data Sources (ODBC).

‍

2. Under the "System DSN" tab, check for "Primavera SDK." If it’s missing:

• Click “Add.”

• Select the “Primavera SDK” driver and configure the connection.

‍

3. Provide the following details:

• Data Source Name: Primavera SDK

• Server Name: Hostname or IP of the database server.

• Database Name: Name of the Primavera P6 database.

• User ID/Password: Typically pubuser and its associated password.

4. Test the connection to ensure proper setup.

‍

4. Missing Data Tables or Access Issues

Even after successful installation, some users report missing tables or being unable to retrieve specific data through the SDK.

These issues often arise due to:

• Limited permissions assigned to the database user (e.g., pubuser).

• Misconfigured schemas or filters within the database.

Solution:

• Ensure the pubuser account has full read and write permissions for all necessary tables.

• Verify that the correct schema is being accessed.

• Refer to the Primavera P6 SDK documentation for the table structures and their expected contents.

‍

Alternative Integration Options

If SDK installation proves too problematic or if you’re working with a version of Primavera P6 that doesn’t include the SDK, consider these alternatives:

1. Primavera P6 Integration API

This API allows for programmatic access to P6 data using Java. It is well-documented, supports RESTful principles, and works with both on-premise and cloud installations.

2. Primavera Web Services

Ideal for cloud-based Primavera P6 environments, this option provides a SOAP-based interface for interacting with P6 data.

3. Custom ETL Solutions

Regular users can import data into Power Query, but as databases grow more complex, advanced users may need to build automated data transfers with Python, SQL Server Integration Services, or Oracle Data Integrator.

‍

Preventive Measures and Best Practices

1. Prepare Your Environment: Verify system requirements and compatibility for your Primavera P6 version. Ensure all prerequisite software (e.g., Oracle Client) is installed.
2. Leverage Documentation: Use Oracle’s official documentation for additional guidance.
3. Keep Software Updated: Regularly update both Primavera P6 and its supporting components to benefit from bug fixes and improvements.
4. Test Frequently: Validate your setup at each step to catch configuration errors early.
5. Backup Databases: Before making significant changes, always back up your Primavera P6 database to prevent data loss.

‍

Best Practices for Oracle Primavera SDK Usage

To maximize the utility of Primavera SDK:

1. Regular Updates: You need to keep your Oracle’s SDK updated for its better features and security.
2. Database Backups: Never use custom queries or integrations without also backing up your database first.
3. Documentation: To access advanced capabilities, you must familiarise yourself with Oracle’s SDK documentation.
4. Access Management: Limit SDK usage to people who have permission to do so so it’s not accidental.

‍

Conclusion

Installing Oracle Primavera SDK doesn’t have to seem like an overwhelming process.

With enough prep and a step-by-step guide, you can take your Primavera P6 setup to the next level and even harness powerful integration and automation.

The SDK is a necessary resource if you’re a project manager trying to streamline reporting or a developer who wants to use Primavera with external tools.

Following the steps explained above will prepare you to install and use Primavera SDK with zero problems.

‍

FAQs

1. What is the difference between Primavera and P6?

Oracle’s suite of project management tools includes multiple products — referred to as Primavera. This suite includes a specific tool to manage project scheduling, resource management, and complex project planning, which is known as Primavera P6.

2. Is Primavera P6 an ERP System?

Primavera P6 is not an ERP (Enterprise Resource Planning) system. It is, however, a project management software meant to do complex scheduling, resource management and project planning on large projects.

3. What database does Primavera use?

In case you plan to use Primavera P6 as a standalone user, you will need to set up a SQLite Database. With this type of database, only one user can access it. Multiple collaborators would not be able to access it at all. P6 comes prepackaged with SQLite Database.