Forum Discussion
Connecting to Oracle Wallet folder
I figured it out and am going to write a step by step explanation to anyone who might find it useful in the future.
Step 1: Download the latest Oracle instant client from https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
Step 2: Install/Extract the downloaded folder to C:\instantclient
Step 3: Add this location to Windows path (usually C:\instantclient\instantclient_19_5)
Step 4: Download and extract the wallet contents to /network/admin in the instant client folder
Step 5: Open the wallet file named tnsnames.ora in a text editor and note down the variable name such as db_high
Step 6: In Power BI navigate to Get Data --> Database --> Oracle
Step 7: In the field named server enter the variable name from step 5
Step 8: It will prompt for a username and password, enter each one as provided by owner of the wallet
Step 9: This should give you the database schema, select the desired table names and click transform/load
Install Oracle client and make sure you manually do the path entry where it installed. else it will not work
https://community.powerbi.com/t5/Desktop/Connecting-Power-BI-using-Oracle-e-wallet/m-p/545620
https://community.powerbi.com/t5/Desktop/Connect-To-Oracle-Database/m-p/188217
I don't even know what to put in any field. The installation process is very complicated. Apart from that, I cant understand where to find the server name. I have spent 5 hours looking at all of these posts on microsoft's pages, the pbi community and the oracle pages. I would appreciate a step by step process as I am very hard stuck. Thanks for the answer though
Hi asad ,
Did you install your oracle and power bi desktop on the same machine? Please try to use localhost as your server name to have a check.
And do I need to put all of the wallet files in a specific folder? How would power bi/ my pc know where to look for the wallet. I appreciate your help.
