Forum Discussion
Connecting Oracle Primavera P6 which is in Azure Cloud to Power BI
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...
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.