Help for getting data from Oracle

[Anonymous]

Hi,

We are using Oracle cloud CRM. Our organization has been using it since quite few years and the people who set it up have already left. I am new here and am trying to connect the CRM data to Power BI. I intalled the ODAC drivers and everything. However, I do not know what to enter in my tnsnames.ora file. That file has asked for service name, server name and hostID/name. No one in the organization has this information. I reached out to Oracle support and here is the response they gave:

Oracle’s response to the service request: “These details are not found in Documentation because they cannot be provided. You'll need to reach out to Power BI support to see if there are alternate ways to create this integration without these details.” 

Does anyone know why Oracle would not share these details with us? If there is any other way to find out the server and service name? How should I proceed in such scenarios.

Thanks,
HV

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

By default, the tnsnames.ora file is located in the ORACLE_HOME\network\admin directory on Windows and the $ORACLE_HOME/network/admin directory on Linux/UNIX.
You could find "ORACLE_HOME" here:
This PC-->Properties-->Advanced system settings-->Environment Variables

Then you could find server name in it.