Connect two different server of oracle database

[neetikulkarni]

Hi,

I want to connect two different server of oracle database for reports in Power BI Desktop using ODAC (Oracle Data Access Components). How to do it (if it is possible) ?

[neetikulkarni · Accepted solution]

After a bit digging up I found the solution to add different oracle server in PBI.

To connect with oracle server we have to install oracle client i.e ODAC in which we have tnsnames file which basically stores the information about network service names in which using following systax we can add multiple servers oracle servers to PBI

service_name =
(DESCRIPTION_LIST=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = example1.com) )
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = example2.com) )
)
)

[amitchandak]

@neetikulkarni , In import mode you can get data from more than one connection. As long as you are able to connect.

[neetikulkarni]

@amitchandak thank you for reply, but I want to connect two different server of oracle, using the method you mentioned I'm getting error as: Details: "Oracle: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

[V-lianl-msft]

Hi @neetikulkarni ,

Refer:

https://stackoverflow.com/questions/10786782/ora-12514-tnslistener-does-not-currently-know-of-servic... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.