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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Mankney,

What error message do you get when you add Oracle data source under on-premises gateway? As stated in the following article, Power BI gateway will go off of the net_service_name defined in the tnsnames.ora file. If it isn't configured, you will not be able to connect.

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-manage-oracle/

In your scenario, please ensure that you install the 64-bit Oracle client, verify that the tnsnames.ora file is properly configured and you are using the proper net_service_name. Also make sure that the net_service_name is the same between the machine using Power BI Desktop and the machine that is running the gateway.

 

Thanks,
Lydia Zhang

  • Mankney's avatar
    Mankney
    Regular Visitor
    9 years ago

    This is the error I am getting.

     

    Oracle: ORA-12154: TNS:could not resolve the connect identifier specified

     

    Here is my TNSNAMES file with names changed.

     

    PROD.WORLD=
      (DESCRIPTION=
        (ADDRESS=
          (PROTOCOL=TCP)(HOST=ORAPROD)(PORT=1521)
        )
        (CONNECT_DATA=(SID=PROD1)

     

    I am working with our Oracle DBA this afternoon to see if he can get the SERVICE_NAME variable working in TNSNAMES.ORA.
        )
      )

     

    Here is what I would put into the field when I configure the datasource.

     

    Data Source Name:   Oracle Test

    Data Source Type:    Oracle

    Server:                      PROD.WORLD

    Authentication Method:   Basic

    Username:   user1

    Password: xxxxxxxx

     

    Thanks for your reply. I am checking on the other items you mentioned.

    • 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