Oracle 12c Driver Download
Oracle Clietn need for remote connection from desktop to database with programms like SQLPLUS, PL/SQL Developer, TOAD, SQL Navigator and maty other. Oracle client for Windows you could download from Oracle website. For installation we need only winnt12102client32.zip. With 64 bit client, not works programms like PL/SQL Developer. First download the correct version of JDBC driver from Oracle website and then rename it to oraclethin.jar and then copy it to maximo applications maximo lib. Please note that Maximo Asset Management Feature Pack 7.6.1.1 supports Oracle database 12c R2 as well as Oracle 18c. It updates the oraclethin.jar file to the Oracle 18c JDBC driver. I am using Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production. I have visual studio 2008 and a windows 10 64-bit OS. Where can I get an odbc driver from to be able to create web applications with an oracle db because I can't find any downloads for it on the oracle website.
- I am using Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production. I have visual studio 2008 and a windows 10 64-bit OS. Where can I get an odbc driver from to be able to create web applications with an oracle db because I can't find any downloads for it on the oracle website.
- This post lists resources to download JDBC drivers for common databases, for your reference in database programming with Java. You know, in order for Java applications working with a database engine via Java Database Connectivity (JDBC), an appropriate JDBC driver library is required to be available in the application’s classpath.A JDBC driver library consists of Java classes which implement.
In order 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. Which Oracle client software you use depends on which version of Power BI Desktop you have installed - the 32-bit version or the 64-bit version.
Supported versions: Oracle 9 and later, Oracle client software 8.1.7 and later.
Determining which version of Power BI Desktop is installed
To determine which version of Power BI Desktop is installed, select File > Help > About then check the Version: line. In the following image, a 64-bit version of Power BI Desktop is installed:
Installing the Oracle client
For 32-bit versions of Power BI Desktop, use the following link to download and install the 32-bit Oracle client:
For 64-bit versions of Power BI Desktop, use the following link to download and install the 64-bit Oracle client:
Connect to an Oracle database
Once the matching Oracle client driver is installed, you can connect to an Oracle database. To make the connection, take the following steps:
From the Get Data window, select Database > Oracle Database
In the Oracle Database dialog that appears, provide the name of the server, and select Connect. If a SID is required, you can specify that using the format: ServerName/SID, where SID is the unique name of the database. If the ServerName/SID format doesn't work, try using ServerName/ServiceName, where ServiceName is the alias used when connecting.
Tip
If you're having trouble connecting in this step, try using the following format in the Server Name field: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=port_num))(CONNECT_DATA=(SERVICE_NAME=service_name)))
If you want to import data using a native database query, you can put your query in the SQL Statement box, available by expanding the Advanced options section of the Oracle Database dialog.
Once your Oracle database information is entered into the Oracle Database dialog (including any optional information such as a SID or a native database query), select OK to connect.
If the Oracle database requires database user credentials, input those credentials in the dialog when prompted.
Troubleshooting
If you downloaded Power BI Desktop from the Microsoft Store, you might be unable to connect to Oracle databases because of an Oracle driver issue. If you encounter this issue, the error message returned is 'Object reference not set'. To address the issue, do one of the following:
Download Power BI Desktop from https://powerbi.microsoft.com/desktop instead.
If you want to use the version from the Microsoft Store: on your local computer, copy oraons.dll from 12.X.Xclient_X into 12.X.Xclient_Xbin. The X represents version and directory numbers.
Oracle Database 12c Release 2 Jdbc Driver Downloads
If you see the error message Object reference not set in the Power BI Gateway when connecting to an Oracle database, you might be able to solve the issue by following the instructions found in the Manage your data source - Oracle article.