Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

laxmanqlik
Contributor

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
Contributor III

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

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
Contributor

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

Thanks for the reply Pham

i want to connect to microsoft SQL

and credentials and port number are correct itself.

kenphamvn
Contributor III

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

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

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

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
Contributor

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

Thanks a lot Pham.

laxmanqlik
Contributor

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

Thanks for the useful info Castellano.