Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-02-28 02:15 PM

Importing Users

Having some trouble importing users to Qlik Sense, hoping someone can help.

I am attempting to store my users in a SQL Server database.  I cannot currently use Excel due to a 32 bit/64bit driver issue (I have 32 bit Office products installed, which makes the 64 bit Excel driver impossible to install).

Here is the error I am getting:

error.png

(I tried with the table names as Table1, Table2 and as dbo.Table1 and dbo.Table2.

Here is my 64 bit ODBC app:

odbc.png

(Not sure this even needs to be created with the Native Connection, but did anyway...though no where in the QMC does it ask for the DSN)

Here is my SQL Server and tables:

sqlserver.png

Can anyone help?users.png

333 Views
0 Likes
0 Replies