topic Re: Export data model and data associations in App Development

Export data model and data associations

abonnery — Tue, 21 Dec 2021 21:56:36 GMT

Hello,

I am looking for a way to store/export an entire data model (made of several tables and data associations/keys) into a single file (whatever the format as long as I can export it to a dedicated folder).

I know of qvd but, the exported data is flat for this format, meaning the relation between the table is lost during the export.

The purpose of the export would be to reload the data model into another app without having to recreate numerous tables and data associations in this new app.

Do you know of a specific format/feature of qlik sense that would allow this ? How could I implement it ?

Thank you very much for your help.

Re: Export data model and data associations

Patricia_Silva — Wed, 28 Apr 2021 11:01:39 GMT

Hello @abonnery I am not aware of any feature like this in Qlik Sense, I have just found the following for QlikView but I would say it would be the same in Qlik Sense side, but in cany case it is maybe not exactly what you expect, yes? https://audministrator.wordpress.com/2019/02/22/qlikview-how-to-export-the-full-data-model-to-excel/

On the other hand, I have also checked in our Ideation program and I could not see any idea submitted regarding this feature, so I would kindly suggest you to submit it there so our R&D team might assess this feature for future releases 😊

You can use the following link to submit any idea: https://community.qlik.com/t5/Suggest-an-Idea/idb-p/qlik-ideas

Thank you!

Re: Export data model and data associations

marcus_sommer — Wed, 28 Apr 2021 14:52:51 GMT

It sounds that you are looking for a binary load:

Binary ‒ Qlik Sense on Windows

- Marcus

Re: Export data model and data associations

abonnery — Tue, 08 Jun 2021 07:18:00 GMT

Hello,

I have heard the binary statement doesn't work for enterprises, instead we choose export a qvf and load it from the app where we want to exploit the data. Is this the way of doing ?

Re: Export data model and data associations

eddie_wagt — Tue, 08 Jun 2021 14:47:22 GMT

Hello @abonnery ,

There are some limitations, but also workarounds

Limitations:

You cannot use binary to load data from an app in a managed space. The app must be in a personal space or a shared space.

You cannot upload QVW or QVF files to the /DataFiles folder. Instead, you can upload the file to a file share, for example AWS S3 or Google Drive, and then load the data from a data connection connected to the file share.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Binary.htm

Regards Eddie