Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
zzler
Contributor
Contributor

Connect QlikSense to SQL server on premise

Hi there,

Not sure if I should ask this here or on the Qlik community. I want to access an on premise SQL server with QlikSense. I'm working with a cloud version of Qlik.

How can I connect to this SQL database? It seems to be accessible locally only? Are there certain tools or settings I can use to connect to it?

Labels (1)
4 Replies
maheshkuttappa
Creator II
Creator II

Similar issue is discussed here 

https://community.qlik.com/t5/Connectivity-Data-Prep/Connect-QlikSense-to-SQL-server-on-premise/td-p...

 

You can use Qlik Data Transfer 

WaltShpuntoff
Employee
Employee

What you are describing sounds like the data gateway component.

Data Gateway Help Page

-ws

WaltShpuntoff
Employee
Employee

@maheshkuttappa 

That is a file transfer utility. That would require generating intermediate files from the SQL server and is a messy solution when Data Gateway will do the job simply.

-ws

maheshkuttappa
Creator II
Creator II

@WaltShpuntoff  Thanks