Zu Hauptinhalt springen

Loading data from ODBC data sources

AUF DIESER SEITE

Loading data from ODBC data sources

You can access a DBMS (Database Management System) via ODBC with Qlik Sense in two ways:

  • You can use the Database connectors in the Qlik ODBC Connector Package that supports the most common ODBC sources. This lets you define the data source in Qlik Sense without the need to use the Microsoft Windows ODBC Data Source Administrator. To connect directly to a database through one of the Qlik-licensed ODBC drivers in the ODBC Connector Package, see the instructions for Database connectors on the Qlik Connectors help site.

  • For ODBC sources not covered by the ODBC Connector Package, you can install an ODBC driver for the DBMS in question, and create a data source DSN. You can then add it as a data connection in Qlik DataTransfer to upload data to your tenant. For more information, see Hochladen von lokalen Daten mit Qlik DataTransfer.

    Alternatively, you could load the data in an app in Qlik Sense Desktop and export data as a QVD to upload with Qlik DataTransfer. For information on using and configuring on-premise ODBC data sources with Qlik Sense Desktop, see ODBC.

You can access a DBMS (Database Management System) via ODBC with Qlik Sense:

Hinweis: In a server environment, the Microsoft Access Database driver has limitations. To avoid issues, use SQL Server Express Edition.
Microsoft Access Database Engine 2016 Redistributable.

ODBC data connection settings

ODBC data connection settings
UI item Description
User DSN

System DSN

Select which type of DSN to connect to.

For User DSN sources you need to specify if a 32-bit driver is used with Use 32-bit connection.

System DSN connections can be filtered according to 32-bit or 64-bit.

Single Sign-On

You can enable Single Sign-On (SSO) when connecting to SAP HANA data sources.

If this option is not selected, Engine service user credentials are used, unless you specify credentials in Username and Password.

If this option is selected, Engine service user or Username / Password credentials are used to do a Windows logon, followed by a subsequent logon to SAML (SAP HANA) using current user credentials.

Username

User name to connect with, if required by the data source.

Leave this field empty if you want to use Engine service user credentials, or if the data source does not require credentials.

Password

Password to connect with, if required by the data source.

Leave this field empty if you want to use Engine service user credentials, or if the data source does not require credentials.

Name Name of the data connection.

Best practices when using ODBC data connections

Security aspects when connecting to file based ODBC data connections

ODBC data connections using file based drivers will expose the path to the connected data file in the connection string. The path can be exposed when the connection is edited, in the data selection dialog, or in certain SQL queries.

If this is a concern, it is recommended to connect to the data file using a folder data connection if it is possible.

Stopping preview of large datasets in tables

If you have large data sets and you do not want to see a data preview while adding ODBC data sources to Data manager or Data load editor, hold down the Shift key while selecting your ODBC data connection.