Connecting Oracle Primavera P6 which is in Azure Cloud to Power BI

[balajishriram]

Hi All,

This is regarding connecting Oracle Primavera P6 EPPM data with Power BI. Bascially my Primavera application in the Auzure cloud. I am trying to access Primavera database tables which are on cloud to do some reports. I have been told that this can be done though webservices/REST API using (web.contents()). Please can some guide me as to how I can access Primavera database tables from Power BI. Thanks in advance. 

[paulciszewski33]

If your P6 DB (or OPC DB) is on Oracle Hosting, Oracle makes it very hard to connect Power BI directly to P6 and OPC. So that is why we developed P6ETL®.

P6ETL® is a software utility that extracts P6 data and OPC data from Oracle Hosting – and stores the P6 and/or OPC data into a Microsoft SQL Server DB (we call it the P6ETL® DB).  Actually, P6ETL® can extract P6 data from any hosted environment - for example, Loadspring.

Once the data is in the P6ETL® DB, users can create robust reports and dashboards using Power BI (or any report development tool).

To learn more about P6ETL®, visit www.p6etl.com or send an email to pciszewski@MustangTechnologies.com. In addition, Mustang holds monthly P6ETL® webcasts. You can register for the webcast from the www.p6etl.com website.

[paulciszewski33]

When P6 or OPC are hosted at Oracle, Oracle prevents you from connecting Power BI directly to the P6 and OPC DB’s. 

So, we developed P6ETL.  P6ETL is a utility that extracts P6 and OPC data from Oracle Hosting (and from Loadspring) – then P6ETL stores the data into a MSSQL DB (we call it the P6ETL DB).  The P6ETL utility uses P6 and OPC web services to extract the data.

Once the P6 and/or OPC data is in the P6ETL DB, you can create an unlimited number of dashboards using any BI tool such as Power BI, Tableau, etc.

To learn more, visit www.p6etl.com.  Mustang Technologies provides monthly P6ETL webcasts.

[Mark_Porter]

Rico,
When the EPPM is hosted in the cloud (By Oracle et al.) users can only access the data via rest api.
How to create this connection appears to be the information that Balaishriram is chasing (& myself)

Kind Regards

Mark

[equivtech]

Look at PSIX Extractor, you can choose required columns and filter data as like P6 professional filtering and application extract data from any P6 Database located in any cloud, you can export more than 500+ columns from the backend, and application is using P6 webservices in the backend, you ddont need any developer to do any programming. if you know P6 then you can run the application. PSIX extractor works as integration tool as well

https://www.equivtech.com.au/Oracle-Primavera-P6-Extractor-Software.html 

[v-rzhou-msft]

Hi @balajishriram ,

Please make sure you have read access to Primavera P6 Database.

If the DBA doesn't want to give you the read access, you need to open the XER file with Excel (or Notepad), then connect that file to Power BI. 

Please click on the below links and read them.

Understanding Primavera XER Files 

P6 XER file using the XER File Parser 

Or you can try to connect to this database by REST API.

For reference: Using a REST API as a data source

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.