Unlock and extract your Primavera P6 or Oracle Primavera Cloud (OPC) data—whether hosted in Oracle Cloud, Loadspring, or on-premise environments—and transform it into comprehensive project management dashboards and KPIs

using Microsoft Power BI. These dashboards can then be easily shared across your organization to support better visibility and decision-making.

​​

P6ETL® is a software utility that extracts P6 and OPC data from virtually any hosted environment, including Oracle Hosting and Loadspring, and loads it into a Microsoft SQL Server (MSSQL) database. Once stored in the reporting database—known as the P6ETL DB—users can connect any reporting tool to the P6ETL DB, including Microsoft Power BI and Tableau, to build unlimited dashboards and reports.

​

Designed specifically for reporting efficiency, the P6ETL DB simplifies dashboard and report development by providing a centralized, analytics-ready data structure. P6ETL extracts data using Web Services, ensuring reliable and repeatable data delivery from Primavera systems into your reporting environment.

​

For more information, explore the Features and Benefits section below or join our next P6ETL webcast.

​

​​​​

 

Here are two (2) typical P6ETL configurations. 

​

​

​​

​​

​​

​

​

​

​​

 

 

 

​

​

​

Here is a Resource Lookahead dashboard and a Project Overview dashboard created with the P6ETL DB:

  

​

​

 

 

 

 

 

 

 

 

​

​​​​​​​​​​​​​​​​​

Here are a few P6ETL features and benefits:

• No need to copy/paste your data from P6/OPC into an Excel spreadsheet for your reports.  P6ETL automatically extracts the P6 and OPC data.

• No manual steps for data extraction.  P6ETL automatically extracts the P6 or OPC data on a schedule from any hosted environment and then P6ETL organizes the data in the P6ETL DB for easy dashboard and report development.

• No manual steps to refresh the Power BI dashboards.  Once the Power BI dashboards are created and published to the Power BI service, dashboards are automatically refreshed using the data in the P6ETL DB.

• Create robust dashboards and reports in any report development tool including Power BI and Tableau.

• Create an unlimited number of Power BI dashboards using the P6ETL DB – and share those dashboards with anyone in your organization.

• Mustang provides six (6) Power BI dashboards with your P6ETL purchase to jump start your Project Management Reporting System.

• You can try P6ETL for a 30-day trial without any financial obligation to Mustang.

• P6ETL can populate your data warehouse too with P6 and OPC data using the P6ETL DB.

• Consolidate multiple P6 and/or OPC databases into a single P6ETL DB for portfolio-level reporting.

• Split data from your P6 or OPC hosted DB into separate P6ETL DB's.  

• The P6ETL DB can be stored on-premise, on Azure, on AWS, or any hosted environment that supports MSSQL DB's.

• Create snapshots of your Projects on a daily, weekly, and/or monthly basis

• And more​

​​​​​

​

​​

​

Other Software Products and Services provided by Mustang (click here to request more information):​

1. XENA – an XER scrubbing tool used by 1000’s of schedulers around the world
   XENA Download 

2. Auto Baselining – creates baselines in P6 on a schedule
   More Information on Auto Baselining 

3. Report Development with Oracle Analytics (formerly BI Publisher)
   Reports developed with Oracle Analytics are run from the Reports tab in P6 EPPM

4. Report Development with Microsoft Power BI

5. Custom P6 Interfaces that update data in P6 via Web Services

6. Custom Oracle Primavera Cloud (OPC) Interfaces that update data in OPC via Web Services

7. Training for Report Developers

​​​​​​

 

​​