Forum Discussion
Connect to multiple Oracle databases on the same server, but with different access credentials
Hello, After successfully connecting my PowerBI Desktop report to an Oracle database, I now need to retrieve data from another database, hosted on the same server but accessible through another us...
Hi V-lianl-msft ,
thank you for your reply. I had seen the thread you posted. But unfortunately, I am not sure how the tnsnames.ora name should be changed.
In the thread it is said: "I just changed my tnsname to have as many aliases as needed, all pointing to the same server but different schema"
But I don't know, in practice, how to change the lines:
Alias_1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host address>)(PORT = <port number>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <service1>)
)
)
Do you have any further advice?
Many thanks again,
Silvia