If you move an app between Qlik Sense sites/ Qlik Sense Desktop installations, data connections are included. Click OK three times to close all the dialogs.īest practices when using ODBC data connections Moving apps with ODBC data connections.When the file Sales.accdb is visible in the text box on the left, click on it to make it the database name.Under Directories, navigate to the location of your Sales.accdb file (a tutorial example file).Name the data source Scripting tutorial ODBC. Name the data source and set the necessary parameters.
#MICROSOFT ODBC 64 BIT DRIVER INSTALL#
Note: If you cannot find this driver in the list you can download it from Microsoft’s downloads website and install it. This can be done during the ODBC installation or at a later stage.
#MICROSOFT ODBC 64 BIT DRIVER SOFTWARE#
Therefore the instructions below may not match the software of all vendors. Must be installed for Qlik Sense to be able to access your database. Please refer to theĭocumentation for the DBMS that you are using for further details. Password to connect with, if required by the data source.Īn ODBC driver for your DBMS (DataBase Management System) Leave this field empty if you want to use Engine service user credentials, or if the data source does not require credentials. User name to connect with, if required by the data source. 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. If this option is not selected, Engine service user credentials are used, unless you specify credentials in Username and Password. You can enable Single Sign-On (SSO) when connecting to SAP HANA data sources.įor more information, see Configuring SAP HANA for SAML Single Sign-On with Qlik Sense. System DSN connections can be filtered according to 32-bit or 64-bit. For User DSN sources you need to specify if a 32-bit driver is used with Use 32-bit connection.