connection from PB to Oracle database

[Anonymous]

Hi, 

I have Power BI Desktop 64-bits, to install oracle client software for connection to Oracle database, there are two packages for download. which one will be the good one to download?

thansk!

[Greg_Deckler]

The 64-bit one.

[Anonymous]

Under 64-bits, there are two download options, one is 3MB ODP_Net_managed,, the other is 77MB, called ODACxxxxx. NOt sure which one to install. 

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

For oracle:

Supported Oracle versions:

• Oracle Server 9 and later
• Oracle Data Access Client (ODAC) software 11.2 and later

So you should install the one with "ODAD":

Moreover,I think the one released on 2018 may be better:

Here is the link:

https://www.oracle.com/database/technologies/odac-downloads.html

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , as far as I know you need OADC. The instruction there in the zip file itself. After installation add path to the window's environment path, otherwise it will not work