Forum Discussion

dramus's avatar
dramus
Continued Contributor
5 years ago

Getting Power BI Desktop to work with Oracle ODAC AFTER version 12.2

Power BI Desktop needs the Oracle data providers installed at the machine level. After ODAC 12.2, Oracle removed this option from the install, which means out of the box Oracle 18.x and 19.x ODAC ins...
Tips and Tricks
dramus's avatar
dramus
Continued Contributor
3 years ago

To uninstall a version of ODAC. I haven't run this, but it should be close.

 

 

OraProvCfg.exe /action:ungac /providerpath:"Oracle.DataAccess.dll"

OraProvCfg /action:unconfig  /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319
IncrementalValu's avatar
IncrementalValu
New Member
2 years ago

I made a slight change but overall it works well, thank you!

 

 

set oracle19cprovider="C:\oracle\ora19c64\client\ODP.NET\bin\4"
OraProvCfg.exe /action:ungac /providerpath:'%oracle19cprovider%\Oracle.DataAccess.dll'
OraProvCfg /action:unconfig /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:'%oracle19cprovider%\Oracle.DataAccess.dll'

 

*Note, your location of Oracle.DataAccess.dll may be different than what I am using.