Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!
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
Hi @gabrodru Thank you and have a good day!
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!
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
Hi @gabrodru Thank you and have a good day!