Skip to main content
Question

Can we use query the Oracle Database in Excel Power Query

  • June 26, 2026
  • 3 replies
  • 16 views
A
Do Gooder (Customer)
Forum|alt.badge.img+1

Hi

I have connected to our PROD environment via Oracle Database in Excel but I can’t seem to find the correct views.

I have searched within the folders listed but unable to see INVENTORY_PART view for example.

Is is possible to query these views in Excel?

 

3 replies

FlorianTauber
Hero (Partner)
Forum|alt.badge.img+6
  • FlorianTauber
  • Hero (Partner)
  • June 26, 2026

Hi ​@ashleigh.russ 

I’m not aware of the Excel Power Query function.

Regarding the DB Structure in IFS you’ve to look in the IFSAPP subfolder (database scheme).

 

KR

Regards, Florian from FLEXiCODE
A
Do Gooder (Customer)
Forum|alt.badge.img+1
  • ashleigh.russ
  • Author
  • Do Gooder (Customer)
  • June 26, 2026

Hi ​@FlorianTauber 

Thank you for your response.

I have looked under IFSAPP but can only find the below

 

FlorianTauber
Hero (Partner)
Forum|alt.badge.img+6
  • FlorianTauber
  • Hero (Partner)
  • June 26, 2026

It seems like you can access VRT (virtual tables). You might need to check for sufficient permissions or use system users like IFSINFO or IFSDBREADONLY

Regards, Florian from FLEXiCODE
    Terms & ConditionsAccessibility statement