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.
To learn more about connectors, see 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:
Apache Hive
Direct discovery can be used in conjunction with Apache Hive but may require the following parameter in the set variables due to the quoting characters used in these sources:
Cloudera Impala
Direct discovery can be used in conjunction with Cloudera Impala but may require the following parameter in the set variables due to the quoting characters used in these sources:
This parameter is required when using the Cloudera Impala Connector in the Qlik ODBC Connector Package. It may not be required when using ODBC through DSN.