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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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