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: 
gabrodru
Contributor II
Contributor II

Specifying SQL Server Instance Name in Advanced Options for On-Premise Setup

Hello everyone,

I am working with Qlik SaaS and trying to set up a connection to my on-premise SQL Server. I recall that there's a specific spot in the advanced options where I need to specify the SQL Server instance name, but I'm having a bit of trouble finding it.

Can anyone guide me on where exactly I should indicate the SQL Server instance name in the advanced options? Your insights would be greatly appreciated!

Thank you!

Labels (1)
3 Solutions

Accepted Solutions
Vinay_B
Support
Support

Hi @gabrodru 

 

Qlik Cloud cannot connect to on-premise DB via analytics connectors such as SQL. If you want to connect on-prem DB, then you would need to use Data gateway Direct access (recommended) or a Data transfer tool.

 

I hope this clarifies. Let me know!

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!

View solution in original post

gabrodru
Contributor II
Contributor II
Author

Hi @Vinay_B 

Thank you very much for your assistance. 😊 I have utilized Data gateway Direct access to make this connection and it worked wonderfully. I really appreciate your recommendation and the information provided. Thanks again and hope you have an excellent day!

Best, Gabrodru

View solution in original post

Vinay_B
Support
Support

Hi @gabrodru Thank you and have a good day!

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!

View solution in original post

3 Replies
Vinay_B
Support
Support

Hi @gabrodru 

 

Qlik Cloud cannot connect to on-premise DB via analytics connectors such as SQL. If you want to connect on-prem DB, then you would need to use Data gateway Direct access (recommended) or a Data transfer tool.

 

I hope this clarifies. Let me know!

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!
gabrodru
Contributor II
Contributor II
Author

Hi @Vinay_B 

Thank you very much for your assistance. 😊 I have utilized Data gateway Direct access to make this connection and it worked wonderfully. I really appreciate your recommendation and the information provided. Thanks again and hope you have an excellent day!

Best, Gabrodru

Vinay_B
Support
Support

Hi @gabrodru Thank you and have a good day!

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!