Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
laxmanqlik
Creator II
Creator II

Does Qlik Sense 2017 require any additional connector to connect with data base..?

i am currently using Qlik Sense 2017 edition and while i am trying to connect to a database it showing the below error..

can any one let me know the way to resolve it.....

6 Replies
kenphamvn
Creator III
Creator III

which database you want to connect?

please ensure the port connect to database is open (ex default port: 1521 for Oracle, 1433 for sqlserver) and qlik server allowed connect to Database server

and username/password is correct?

laxmanqlik
Creator II
Creator II
Author

Thanks for the reply Pham

i want to connect to microsoft SQL

and credentials and port number are correct itself.

kenphamvn
Creator III
Creator III

Hi

Qlik support connect to SQL via (ODBC, OLE DB...), you do not need install additional connector

Here my example connect to SQL server using OLE DB

8-10-2017 17-04-05.jpg

Not applicable

If you use qlik sense desktop you must first create an odbc connection. Either user or system dns.
If you use qlik cloud you must have a static ip and open the port of router 1433 and direct it to the computer that has the SQL.

laxmanqlik
Creator II
Creator II
Author

Thanks a lot Pham.

laxmanqlik
Creator II
Creator II
Author

Thanks for the useful info Castellano.