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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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