Create an Oracle connection

To access your data stored on an Oracle database, you will need to know the server and database name that you want to connect to, and you must have access credentials. Once you have created a connection to an Oracle database, you can select data from the available tables and then load that data into your app or document.

In Qlik Sense, you connect to an Oracle database through the Add data dialog or the Data load editor.

In QlikView you connect to an Oracle database through the Edit Script dialog.

Setting up the database properties

The Oracle Connector requires additional configuration for the TNS service. The following two TNS files must be modified for the Oracle environment. Sample versions of these files are available in the sample directory at the end of the path shown below for each of the Qlik Sense and QlikView locations. Or you can get the files from your Oracle configuration.

  • tnsnames.ora: set the host addresses and ports for the TNS service.
  • sqlnet.ora: set the location of the Oracle wallet.

These files must be placed in one of the following locations for Qlik Sense and QlikView.

Qlik Sense Desktop:

%USERPROFILE%\AppData\Local\Programs\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\oracle\lib\network\admin

Qlik Sense Enterprise:

C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\oracle\lib\network\admin

QlikView:

C:\Program Files\Common Files\QlikTech\Custom Data\QvODBCConnectorPackage\oracle\lib\network\admin

Database property Description Required
Host name Host name to identify the location of the Oracle database yes unless using TNS Service Name
Port Server port for the Oracle database yes unless using TNS Service Name
Service name The alias name for the TNS service yes unless using TNS Service Name
Use TNS Service name Use the TNS name defined in the tnsnames.ora file instead of the TNS alias name. no
TNS Name The TNS name defined in the tnsnames.ora file. no

Authenticating the driver

Note: The Oracle Connector does not support NTLM authentication in version 4.0. For that reason, the Windows integrated security option is not available.

Qlik Sense: Oracle authentication properties

Authentication property Description
Username User name for the Oracle connection
Password Password for the Oracle connection
Name

Name of the Oracle connection

The default name will be used if you do not enter a name.

QlikView: Oracle authentication properties

Authentication property Description
Username User name for the Oracle connection
Password Password for the Oracle connection

Using Advanced options

Option Description Required

Name

Name of additional properties

You can add more than one additional properties.

no
Value

Value of additional properties

You can add more than one additional properties.

no

See Oracle documentation for a complete list of options that can be set in the Advanced settings fields.

Note: When you connect to an Oracle database with the Data load editor or the Edit Script dialog, Test Connection enables you to test the connection before you attempt to create it.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?