Forum Discussion

RSPPBI's avatar
RSPPBI
Regular Visitor
8 years ago
Solved

connecting to the same oracle database with different user accounts

Hello,   I am running into a power BI issue and maybe you can tell me if there is a solution for it by using Power query. I am trying to connect to an oracle database with the name database 1 and ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi RSPPBI,

     

    Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi RSPPBI,

 

Based on my test, we can use different server names to connect to the same Oracle database using different usernames. So In your scenario, you can use four kinds of server names to meet your requirement. Here I make a test using IP address, servername and FQDN.

 

 

Regards,
Frank

  • RSPPBI's avatar
    RSPPBI
    Regular Visitor
    8 years ago

    I am not sure what you mean...

     

    How do you make 4 times connection to the same Oracle database

     

    I try to do this in the Gateway, via Add Source, which method(s) do you use?

     

    Someone also sugested to use different aliases in  the tnsnames.ora file.

     

    Have you experience with that and what should I fill in iin this file, can you give me an example?

     

     

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      8 years ago

      Hi RSPPBI,

       

      Based on my test, all the four kinds of server names could be added in the gateway. Please notice, only the gateway is installed on the same machine with Oracle, the localhost could be used.

       

      Please refer to the pictures as below.

       

       

      Regards,

      Frank

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        8 years ago

        Hi RSPPBI,

         

        Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.

         

        Regards,

        Frank