Unlock your Primavera P6 or Oracle Primavera Cloud (OPC) data that are hosted at Oracle, Loadspring, or On-Premise

and create comprehensive Project Management dashboards and KPI's with Microsoft Power BI

then share those dashboards with others in your organization.

​

P6ETL is a software utility that extracts P6 data and Oracle Primavera Cloud (OPC) data from any hosted environment, such as Oracle Hosting and Loadspring, and then stores the data into an MSSQL DB.  Once the data is in the MSSQL DB, users can connect to the MSSQL DB and create an unlimited number of reports using any report development tool including Microsoft Power BI and Tableau.  The MSSQL DB (we call it the P6ETL DB) is a reporting DB that simplifies dashboard and report development.  P6ETL extracts the P6 and OPC data using Web Services.   For more details, see the Features and Benefits section below or attend 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

​​​​​​

 

​