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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I add more data source providers

I am a new user who has downloaded the Personal Edition on a 64bit Windows7 machine.

I would like to connect to an SQL data source (ODBC connection established & tested using the ODBC administrator tool within Qlikview) however when I access the data source list I don't have Microsoft SQL as a provider. In fact I only have 3 providers as can be seen below.

How do I add other providers ?

qlikview data sources.jpg

3 Replies
Not applicable
Author

You have to create a Conenction to the Data Source first with the ODBC Administration from Windows, you can open them direct from QlikView in the Script Editor -> Tools -> ODBC Administration (select the Bit Version your driver is)

Not applicable
Author

Thanks for the reply Daniel.

I have created the ODBC connection in the windows administration  as follows :

ODBC.jpg

My issue is that SQL is not listed as a provider when I am trying to connect to a data source

qlikview data sources.jpg

Not applicable
Author

It is better to create a System DSN, is it a 32bit Conenction, in this case you have to Force 32bit

force 32.png