Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Binary load vs QVD load

Hi All

I just learn about binary load . am i right to said :-

1. Binary load will make the QV file size smaller. compare to load thru QVD.

2. it is more diffcuilt to write the script using binary loading , compare to QVD load .

3. Binary load can protect your source , thus prevent other accidently modify your code.

Pls let me know my above assumption it is correct ?

Paul

1 Solution

Accepted Solutions
MVP
MVP

Re: Binary load vs QVD load

Hi Paul,

In Binary Load, a Qlikview file is loaded into another qlikview file, in a file only one QVW file can be loaded into another Qlikview file.

But you can load any number of QVDs in one qlikview file.

I think there is no difference in size by using either QVD or Binary load.

Scripting using QVD and Binary load are same, no difference between this two.

Binary load is more secure, since your business logic is not in the presentation file (Dashboard), nobody can edit your code if you do binary load.

Generally in development 3 layers are used.

1) Data Load  Qlikview file - Data load from Database to QVDs

2) Transform Qlikview file - Data load from QVDs and create datamodel based on the business requirements

3) Presentation Qlikview file - Binary load of Transform file in above step is used.

This is the procedure followed by many companies.

Hope this helps you.

Regards,

Jagan.

5 Replies
Not applicable

Re: Binary load vs QVD load

according to my knowledge

Binary load is loading data from another QV file.  For example, you have application A.qvw.  You can create another application B.qvw with script

binary A.qvw.

When you reload it, your B.qvw has the same data as A,qvw. 

QVD

Reading from QVD is 10-100 times faster than reading from Data sources.

Consolidating data from multiple data sources and databases.Create multi layer QVDs to create a robust data model.

Incremental load can be implemented only by using QVDs

Re: Binary load vs QVD load

  1. Not necessarily. A binary load transfers all data from an existing document into your current document. User Interface nor variables are included in the transfer though.
  2. No. You're just moving your script from your current document to the document that you do a binary load from. Someone has to load and process  the raw data.
  3. True. You could close down the first document, so that nobody can access the load script (in a Hidden script or just username/password protected) and let the second document wide open so that users can change the User Interface.

Peter

Re: Binary load vs QVD load

Paul

I agree with Peter's comments above, but would add one major difference.

Loading from a QVD will only load a single table, although one could load multiple QVD's in multiple statement.

Whereas a binary load from a QVW will load all it tables in one go, as in could be many tables from the qvw.  So it can be used as a datamart that is very easy for those not experienced in scripting to use to create dashboards.

Best Regards,     Bill Markham

Employee
Employee

Re: Binary load vs QVD load

1. Binary load will make the QV file size smaller. compare to load thru QVD. Not too significant, if really happens

2. it is more diffcuilt to write the script using binary loading , compare to QVD load . Different situations, binary imports a full package of tables from another app, QVD load only one table each time

3. Binary load can protect your source , thus prevent other accidently modify your code. Yes

MVP
MVP

Re: Binary load vs QVD load

Hi Paul,

In Binary Load, a Qlikview file is loaded into another qlikview file, in a file only one QVW file can be loaded into another Qlikview file.

But you can load any number of QVDs in one qlikview file.

I think there is no difference in size by using either QVD or Binary load.

Scripting using QVD and Binary load are same, no difference between this two.

Binary load is more secure, since your business logic is not in the presentation file (Dashboard), nobody can edit your code if you do binary load.

Generally in development 3 layers are used.

1) Data Load  Qlikview file - Data load from Database to QVDs

2) Transform Qlikview file - Data load from QVDs and create datamodel based on the business requirements

3) Presentation Qlikview file - Binary load of Transform file in above step is used.

This is the procedure followed by many companies.

Hope this helps you.

Regards,

Jagan.

Community Browser