Prerequisites

Before you can use Oracle as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:

Client

Before you can use Oracle as a source in a Qlik Compose project, make sure that the following client prerequisites have been met:

• The Oracle database should be configured with the required permissions (see below) and accessible from the Compose machine.

• Install Oracle Data Access Components (x64) on the computer where Qlik Compose is located. Then, add the full path of the Oracle Data Access DLL to the system environment variables.

  The default path should be:

  <ORACLE_PRODUCT_CLIENT_DIR>\ODP.NET\bin\4\

  Information note

  • The path to the Oracle Data Access DLL also needs to be specified in both the machine.conf file and the Global Assembly Cache (GAC). In addition, make sure that the Oracle.DataAccess.dll file exists in the following location: C:\Windows\Microsoft.NET\assembly\GAC_64.

    For more information, see Oracle Help Center.
    

  • The Qlik Compose service needs to be restarted after installing the required components.
• Install Oracle Instant Client for Microsoft Windows (x64) 19.0 or later on the computer where Qlik Compose is located.

• If you want to use an Oracle TNS name in the connection settings, you first need to set the ORACLE_HOME environment variable.

  Example:

  <ORACLE_PRODUCT_CLIENT_DIR>\product\<version>\client_1

Permissions

To use Oracle as a Data Warehouse a Qlik Compose project, the Compose user must be granted the following privileges in the Oracle database:

• grant create session
• grant create table
• grant create view
• grant connect
• grant resource
• grant create sequence
• grant create any directory
• grant SELECT on SYS.DBA_REGISTRY
• grant select any table
• grant delete any table
• grant drop any table
• grant unlimited tablespace

• grant create any table

• grant insert any table

• grant update any table

• grant drop any table

• grant alter any table

• grant create any view

• grant drop any view

• grant create any index