Data sources supported in Direct Discovery

Qlik Sense Direct Discovery can be used against the following data sources, both with 32-bit and 64-bit connections:

• ODBC/OLEDB data sources - All ODBC/OLEDB sources are supported, including SQL Server, Teradata and Oracle.
• Connectors that support SQL – SAP SQL Connector, Custom QVX connectors for SQL compliant data stores.

See: ODBC

See: OLE DB

Qlik Connectors

Both 32-bit and 64-bit connections are supported.

SAP

For SAP, Direct Discovery can be used only with the Qlik SAP SQL Connector, and it requires the following parameters in SET variables:

SAP uses OpenSQL, which delimits columns with a space rather than a comma, so the above set statements cause a substitution to accommodate the difference between ANSI SQL and OpenSQL.

Google Big Query

Direct Discovery can be used with Google Big Query and requires the following parameters in the set variables:

Google Big Query does not support SELECT DISTINCT or quoted column/table names and has non-ANSI quoting configuration using '[ ]'.

MySQL and Microsoft Access

Direct discovery can be used in conjunction with MySQL and Microsoft Access but may require the following parameters in the set variables due to the quoting characters used in these sources:

DB2, Oracle and PostgreSQL

Direct discovery can be used in conjunction with DB2, Oracle and PostgreSQL but may require the following parameter in the set variables due to the quoting characters used in these sources:

Sybase and Microsoft SQL Server

Direct discovery can be used in conjunction with Sybase and Sybase and Microsoft SQL Server but may require the following parameter in the set variables due to the quoting characters used in these sources: