- #Oracle database connect string install#
- #Oracle database connect string drivers#
- #Oracle database connect string software#
The Oracle client software you use depends on the Oracle server version, but will always match the 64-bit gateway. To connect to an Oracle database with the on-premises data gateway, the correct Oracle client software must be installed on the computer running the gateway.
#Oracle database connect string install#
Connect to an Oracle databaseĪfter you install the matching Oracle client driver, you can connect to an Oracle database. Make sure that checkbox is selected so that Power BI can connect to your Oracle database. Some versions of the Oracle client wizard selects the checkbox by default, others do not. For instance, ODAC 12.x does not always support Oracle Server version 9.Ĭhoose the Windows installer of the Oracle Client.ĭuring the setup of the Oracle client, make sure you enable Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level by selecting the corresponding checkbox during the setup wizard. In the following image, a 64-bit version of Power BI Desktop is installed:įor the 32-bit version of Power BI Desktop, download and install the 32-bit Oracle client.įor the 64-bit version of Power BI Desktop, download and install the 64-bit Oracle client.Ĭhoose a version of Oracle Data Access Client (ODAC) which is compatible with your Oracle Server.
To determine which version of Power BI Desktop is installed, on the Help ribbon, select About, then check the Version line. Determining which version of Power BI Desktop is installed If you're configuring an Oracle database for Power BI Desktop, On Premises Data Gateway, or Power BI Report Server, consult the information in the Oracle Connection Type article.
#Oracle database connect string drivers#
Once Oracle 18.x/19.x is installed the customer must follow the instructions here: Registering Oracle drivers for Power BI Desktop Administrators can still place ODP.NET in the GAC and add the configuration section handler and DbProviderFactory information to nfig manually if they wish to override ODP.NET settings for individual applications." "Machine-wide configuration is no longer supported beginning with ODAC 18c. You must choose a windows installer version since xcopy version does not work with Power BI Desktop. To install the 64-bit ODAC software, go to 64-bit Oracle Data Access Components (12.1.0.2.4) or choose a version you prefer. To install the 32-bit ODAC software, go to 32-bit Oracle Data Access Components (12.1.0.2.4) or choose a version you prefer. Oracle Data Access Client (ODAC) software 11.2 or greaterīefore you can connect to an Oracle database using Power BI, you need to install the Oracle Data Access Client (ODAC) software 11.2 or greater on your computer.It also depends on your version of Oracle server. The Oracle client software you use depends on which version of Power BI Desktop you've installed: 32-bit or 64-bit. To connect to an Oracle database with Power BI Desktop, the correct Oracle client software must be installed on the computer running Power BI Desktop.