![](https://static.wixstatic.com/media/bcd031_db9c0b162e304b769f3195d79107e324~mv2.png/v1/fill/w_49,h_14,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/bcd031_db9c0b162e304b769f3195d79107e324~mv2.png)
P6ETL® for BI Reporting 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 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.
​
​
​
​
​
​
​
​
​
​
​
​
Here are a couple Power BI dashboards created from the P6ETL® Database:
​
​
​
​
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
​
​
​
​
​
​
​
![](https://static.wixstatic.com/media/bcd031_24b176b020f04915b54620dc2d8f4405~mv2.jpg/v1/fill/w_944,h_312,al_c,q_80,usm_0.66_1.00_0.01,enc_auto/bcd031_24b176b020f04915b54620dc2d8f4405~mv2.jpg)
![](https://static.wixstatic.com/media/bcd031_d25926730224483da8d22d7f85cba07d~mv2.jpg/v1/fill/w_946,h_268,al_c,q_80,usm_0.66_1.00_0.01,enc_auto/bcd031_d25926730224483da8d22d7f85cba07d~mv2.jpg)