Skip to main content Skip to complementary content
Qlik Resources

ODBC

To access a DBMS (DataBase Management System) via ODBC, it is necessary to have installed an ODBC driver for the DBMS in question. The alternative is to export data from the database into a file that is readable to Qlik Sense.

Normally, some ODBC drivers are installed with the operating system. Additional drivers can be bought from software retailers, found on the Internet or delivered from the DBMS manufacturer. Some drivers are redistributed freely.

The ODBC interface described here is the interface on the client computer. If the plan is to use ODBC to access a multi-user relational database on a network server, additional DBMS software that allows a client to access the database on the server might be needed. Contact the DBMS supplier for more information on the software needed.

Adding ODBC drivers

An ODBC driver for your DBMS(DataBase Management System) must be installed for Qlik Sense to be able to access your database. Please refer to the documentation for the DBMS that you are using for further details.

64-bit and 32-bit versions of ODBC configuration

A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open DataBase Connectivity (ODBC)Data Source Administrator tool (Odbcad32.exe):

  • The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWOW64 folder.
  • The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

Creating ODBC data sources

An ODBC data source must be created for the database you want to access. This can be done during the ODBC installation or at a later stage.

Information noteBefore you start creating data sources, a decision must be made whether the data sources should be User DSN or System DSN (recommended). You can only reach user data sources with the correct user credentials. On a server installation, typically you need to create system data sources to be able to share the data sources with other users.

Do the following:

  1. Open Odbcad32.exe.

  2. Go to the tab System DSN to create a system data source.

  3. Click Add.

    The Create New Data Source dialog appears, showing a list of the ODBC drivers installed.

  4. If the correct ODBC driver is listed, select it and click Finish.

    A dialog specific to the selected database driver appears.

  5. Name the data source and set the necessary parameters.
  6. Click OK.

Learn more

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here