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: 
aheavy95
Creator
Creator

Load into SQL Server from Qlik Sense

Hi all
I have recently began a new project in which SQL server is the main DB.

There is a request to insert data (a table) from Qlik Sense into SQL. Is it possible? If so, how?
I have seen a few posts about it but none of them are up to date. Some mention that it can be done by Stored Procedure

Thanks 

Labels (4)
2 Replies
vikasmahajan

hi,

try this

https://community.qlik.com/t5/Official-Support-Articles/Can-Qlik-Sense-Write-back-to-Database/ta-p/1...

 

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
NadiaB
Support
Support

Hi @aheavy95 

Are just planning to insert a few records? If so this might help:

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/How-to...

If you are planning to insert a huge amount of records it will probably be better to do it outside of QS app, probably use a BULK INSERT statement from a csv or something like that. 

For external execution this could help:

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

Hope it helps. 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm