top of page

Connect Power BI to your Primavera P6 or Oracle Primavera Cloud (OPC) data hosted at Oracle, Loadspring, or On-Premise.

P6ETL is a software utility that extracts P6 data or Oracle Primavera Cloud (OPC) data from a 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 such as Microsoft Power BI and Tableau.  The MSSQL DB (we call it the P6ETL DB) is a reporting DB that mimics the Oracle P6 Reporting DB created by the publishing step in P6 EPPM.  However, P6ETL extracts the data using Web Services therefore P6ETL is not dependent on Oracle's P6 Reporting DB nor the publishing step in P6 EPPM. 

Here are two (2) typical P6ETL configurations. 

 

 

 

Here is a Resource Lookahead dashboard and a Project Overview dashboard created by connecting to P6ETL DB:

  

 

 

 

 

 

 

 

 

Here are a few P6ETL features:

  • Extracts P6 and OPC Projects based on EPS/Workspace Node, Project Code, and/or Project Status - or P6ETL can extract ALL P6 Projects and all baselines.

  • Combine projects from multiple P6 and OPC DB's into a single P6ETL DB for consolidated, portfolio-level reports. 

  • Split data from your P6 or OPC DB in 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

Click here for an information sheet on P6ETL or BI Reporting

Other Software Products and Services (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

 

image.png
image.png

P6ETL for BI Reporting

bottom of page