Forum Discussion

Mankney's avatar
Mankney
Regular Visitor
9 years ago
Solved

On premise Gateway and an Oracle Datasouce

Hi I am trying to configure an Oracle Datasource in our new On premise Gateway and am having difficulties. I have not found much on the web about it. Does anyone know of some good learning materials ...
Need Help
  • Mankney's avatar
    Mankney
    9 years ago

    We have solved it. We added the SERVICE_NAME parameter to the TNSNAMES.ORA file. In the Power BI Portal we also configured the server name as //<Host>/<Service_Name>. If we have a Host name of ORAPROD and a SERVICE_NAME of PRODDB then the Server name in the Power BI Console under Settings and then Manage Gateways, under your Gateway and Add Data Source  would be //ORAPRDO/PRODDB. It worked fine then.

     

    Thanks for the help.

Mankney's avatar
Mankney
Regular Visitor
9 years ago

We have solved it. We added the SERVICE_NAME parameter to the TNSNAMES.ORA file. In the Power BI Portal we also configured the server name as //<Host>/<Service_Name>. If we have a Host name of ORAPROD and a SERVICE_NAME of PRODDB then the Server name in the Power BI Console under Settings and then Manage Gateways, under your Gateway and Add Data Source  would be //ORAPRDO/PRODDB. It worked fine then.

 

Thanks for the help.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Mankney,

Glad to hear the issue is solved. You can accept helpful reply as answer, this way, other community members would easily find the solution when they have same issues.

Thanks,
Lydia Zhang