Forum Discussion
Connecting to Oracle Wallet folder
A client has shared a folder containing the following files:
- cwallet.sso
- ewallet.p12
- keystroke.jks
- ojdbc.properties
- sqlnet.ora
- tnsnames.ora
- truestroke.jks
Supposedly I would be connecting to a db in the cloud. I dont know how to connect to this in Power BI. So far, I have installed Oracle database 19c. I am using the feb 2020 update of Power BI and am on Windows 10 Enterprise. I have bever used Oracle or any other sql servers or databases before. If someone could provide guidance in this regard, it will be highly appreciated.
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
5 Replies
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.
