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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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