Help for getting data from Oracle

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