Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

connect power bi to oracle cloud database

Hi Everyone, I got a requirement for my client where I need to build reports by connecting power bi to oracle database cloud and have to implement data level security.  is there an possibility to a...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I am able to conect to the cloud database bt creating alias name for the entire string and passsed it in the service name box. 

    ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LOACAHOST)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=Servicename)))

     

    Thanks!

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 Thank you so much for the response.

I am able to connect to the oracle database which is residing in my local machine and on premise server too. Actually, I want to connect the cloud oracledata base which is sitting in the oracle server. Do I need to follow the same process to connect to the Oracle cloud?

However, I tried to connect the oracle cloud database by following the below steps.

https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database

Server entry box is not allowing me to put more than 128 char as my server name is exceeding 128 char string limit 

I used below format for the server name

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LOACAHOST)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=Servicename)))

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I am able to conect to the cloud database bt creating alias name for the entire string and passsed it in the service name box. 

    ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LOACAHOST)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=Servicename)))

     

    Thanks!

     

  • Salama's avatar
    Salama
    New Member
    3 years ago

    Dear could you please more details about how to connect to oracle cloud ? 

    thanks in advance