P6ETL® for BI Reporting is a software utility that extracts P6 data or Oracle Primavera Cloud (OPC) data from an Oracle-hosted environment and stores the data into an on-premise P6ETL® SQL Server database.  Once the data is in the P6ETL® Database, users can create BI reports using a variety of report development tools such as Microsoft Power BI and Tableau.  The P6ETL® Database is a reporting database that mimics the Oracle P6 Reporting Database 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 Database nor the publishing step in P6 EPPM.  Below are 2 diagrams with typical configurations.  To schedule a meeting with Mustang, click here.

 

 

 

 

 

 

Here are a few P6ETL® for BI Reporting features:

  • Extracts P6 and OPC Projects based on EPS/Workspace Node, Project Code, Project Status, and/or a Project UDF value - or P6ETL®  can extract ALL P6 Projects

  • Combine P6 and OPC Projects from multiple P6 and OPC Databases into a single P6ETL® Database for consolidated, portfolio-level reports. 

  • If your P6 or OPC Database has Projects from mutliple customers, you can extract individual Projects into their own P6ETL® Databases for customer-specific reports  

  • 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

 

P6ETL® for BI Reporting