Connect IFS with powerbi

Hi ​@MANI0202 ,

possible but please be aware of the following.
 

The IFS ORACLE Database contains more than 12.000 tables and more than 15000 views.
When you use PowerBI (like QuickReport) to query IFS live(!) data you will probably run into the following scenario:
A) start quick with a so called “self service client” (that is the marketing “claim” from Microsoft)
B) use the first PowerBi reports.
C) user will ask for more and more (and more :-)
D) the amount of PowerBI reports will increase rapidly.
E) imagine: you have - let’s say - 3 reports with calculation of order entry, turnover and contribution margin. (CustomerInvoiceLines and CustomerOrderLines based data)
The probabilty that your 3 reports are slightly different (first because you learn and add new filters, cases, etc) is very high.
This will result in “discussions”: My report is “better”, “newer” but mine is the first one -- and so on.
 

So my recommendation:
Use the BI models from IFS (FACT_ and DIM_ Views) eventually materialized in your ORACLE DB already.
Or use a common ETL process to fetch data from ORACLE into a Microsoft DataWareHouse (DWH) DB and build your own structures.

As you can see in the screenshot, we use Microsoft LinkedServer technology to fetch data
(every nigth done by the MS SQL Agent Job).
We use the SSIS-way for xls, csv and txt files but not for the ORACLE data.
You can do that as well, we recommend the other way (and try to avoid APIs as long as possible)

When your “raw” data is extractet (first of ETL process) you can build your own FACT and DIM tables.

One last “picture”:
Imagine a Stihl chainsaw. There is one battery, small one. Beautiful to cut smaller trees/branches and for carving.You can use it to cut an oak tree. It will do! (amazingly :-)
But to cut trees every body will use the big, professional chainsaw.
(even if you can carve with it as well! Done that several times!)

So your “big saw” is the backend = MS SQL Server.
Your “small one” is the frontend = PowerBI (but also other tools like exel, even IFS Business Reporter if you like that tool)
 

Hope that information helps.

Best regards
Michael