Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a PostgreSQL dump .sql file I want to load it into QlikSense, Is there any way to load the file using load editor?
Hi, before to use in qlik sense you will need to load your dump file in Postgresql database, Please check the following link https://www.postgresql.org/docs/8.1/backup.html#BACKUP-DUMP-RESTORE
This is first step what have to be done , Second step will be loading in Qlik Sense
Isn't it possible to directly utilise dump over Qlik Sense such that I can restore it in Qlik.
Secondly Is it possible to load any SQL file in Qlik Sense
Hi, no you can not use any SQL file directly
My problem is I want to regularly update data over Qlik but the constraint is i can't make a direct connection as the database is inside a virtual private network. So I'm taking a dump with only the required information and I want to use that. Is there ant approach for this problem
Why you are not exporting the data from Postgresql in csv file?
Hi @user12
Kindly check on the below link,
https://community.qlik.com/t5/QlikView-App-Dev/Import-sql-file-into-qlikview/td-p/112263
Regards,
LN
When uploading a data file in Qlik Sense it shows unsupported format for .sql files. So how can I include a .sql file without uploading it
From Data Load editor
like "$(Include="lib://DataFiles/sample-data.sql"];"
And follow the steps show in that link
Okay but that's a PostgreSQL dump how can we execute it