Forum Discussion

pierredelareux's avatar
pierredelareux
Helper I
9 years ago
Solved

Primavera Datas

Hi,   I would like to use Power BI to see and analyse datas coming from Primavera P6, an Oracle tool. Should I use web service ? SQL requests ?   How do I log into the P6 data-base ?   I hope ...
paulciszewski33's avatar
paulciszewski33
Frequent Visitor
2 years ago

If your P6 EPPM or Oracle Primavera Cloud (OPC) is hosted at Oracle, Oracle makes it difficult to connect Power BI to the P6 EPPM or OPC DB.  You need to extract the P6 or OPC data out of Oracle Hosting using a utility such as P6ETL (www.p6etl.com).  Actually, P6ETL can extract P6 data out of any hosted environment such as Loadspring.  P6ETL then stores the P6 or OPC data into a MSSQL DB (on-premise, at Azure, or at AWS).  Once the P6 or OPC data is in the MSSQL DB, you can create Power BI P6 and OPC dashboards.  And P6ETL will automatically update/refresh the P6 and OPC data in the MSSQL DB throughout the day

 

But, if your P6 DB is on-premise, you can connect Power BI to your P6 Native DB.  Checkout the “Primavera P6 Reporting with Microsoft Power BI” LinkedIn group (https://www.linkedin.com/groups/13914226/).  There are a few videos to show you the steps for connecting Power BI to your on-premise P6 DB.

 

And if you are using P6 EPPM on-premise and Publishing is enabled, you also have access to the P6 Report DB (which has most calculated and time-phased data).