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 about connecting Oracle to the On Premise Gateway datasouce? I am specifically looking for examples of how it is configured so I can adapt it to our situation.

 

I do have the Oracle client on the Gateway box and can use the SQLPLUS command to open a connection to the oracle database in question but I just can't get the gateway to work. We do not use Service_Names in our TNSNAMES file and I wonder if that might have something to do with it.

 

A month ago I new nothing about Power BI or Oracle and am trying to come up to speed real quick. Any help would be appreciated on this specific issues and where I can learn more.

Thanks

 

 

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.

6 Replies

  • 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.