topic Re: How to load .sql file in Connectivity & Data Prep

How to load .sql file

user12 — Tue, 09 Aug 2022 07:55:03 GMT

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?

Re: How to load .sql file

saso70 — Tue, 09 Aug 2022 08:58:43 GMT

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

Re: How to load .sql file

user12 — Tue, 09 Aug 2022 09:33:06 GMT

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

Re: How to load .sql file

saso70 — Tue, 09 Aug 2022 09:36:43 GMT

Hi, no you can not use any SQL file directly

Re: How to load .sql file

user12 — Tue, 09 Aug 2022 11:32:53 GMT

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

Re: How to load .sql file

saso70 — Tue, 09 Aug 2022 11:37:11 GMT

Why you are not exporting the data from Postgresql in csv file?

Re: How to load .sql file

Lakshminarayanan_J — Tue, 09 Aug 2022 12:41:59 GMT

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,

Re: How to load .sql file

user12 — Tue, 09 Aug 2022 12:47:52 GMT

Hi @Lakshminarayanan_J

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

Re: How to load .sql file

Lakshminarayanan_J — Tue, 09 Aug 2022 12:59:11 GMT

From Data Load editor

like "$(Include="lib://DataFiles/sample-data.sql"];"

And follow the steps show in that link

Re: How to load .sql file

user12 — Tue, 09 Aug 2022 13:14:54 GMT

Okay but that's a PostgreSQL dump how can we execute it