Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView Revision control / version control / source control software

Hi all,

I'm working with a solution where we use SQL server and SSIS as our data warehouse and ETL tool. The data warehouse generates most of the data for our QlikView reports.

Regarding our SSIS packeges we use the Tortoisesvn (http://tortoisesvn.tigris.org/) software for Revision control / version control / source control software, etc.

------

I'm wondering if anyone knows about software we can use for Revision control / version control / source control software for our ClikView soulution?

And tips and advices for stuff we have to think about when implenting such a solution...?

Our current sollution is not good enough where we store al qvw/qvd files on one server and with noe check-in control or "rules" for deployment and change handeling...

Hope any one can help - all advice is appreciated especially experiences anyone might have considering this issue...

1 Solution

Accepted Solutions
StefanBackstrand
Partner - Specialist
Partner - Specialist

Take a look at the prj functionality in QlikView. Create a folder next to the document, with the same name only without ".qvw" and with added "-prj" - for example; for "Films.qvw", then name the folder "Films-prj". The next time you save the qvw document, the definition of the file with show up in xml files here. Changing the document and saving will update the xml references.

To re-create a document from the prj references, just create a blank document (Ctrl+N in QlikView), save it with the same name as the document, close it and re-open it in QlikView, and the document will be created after the definition.

Hope this helps!

View solution in original post

36 Replies
StefanBackstrand
Partner - Specialist
Partner - Specialist

Take a look at the prj functionality in QlikView. Create a folder next to the document, with the same name only without ".qvw" and with added "-prj" - for example; for "Films.qvw", then name the folder "Films-prj". The next time you save the qvw document, the definition of the file with show up in xml files here. Changing the document and saving will update the xml references.

To re-create a document from the prj references, just create a blank document (Ctrl+N in QlikView), save it with the same name as the document, close it and re-open it in QlikView, and the document will be created after the definition.

Hope this helps!

mr_barriesmith
Partner - Creator
Partner - Creator

Agreed. We did that in QV10 and now in QV11 we tested TFS and the integration is very good.

Our experience is in the development environment only... No QVDs.

Not applicable
Author

Hi Stefan,

Really helpfull! Just one question, what is the DocBinary.dat file? Do I need to track that as well in my version control?

Thanks

Ed

StefanBackstrand
Partner - Specialist
Partner - Specialist

I actually don't know. It's not something that I recognize..

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

If I recall correctly, this file contains the encrypted password and username for database connections. I am note sure what else, if anything. But yes, I would include it in your version control. I know it binary, but I have never seen it get large.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
giakoum
Partner - Master II
Partner - Master II

Hi Stefan.

I am not sure I understand how this will help versioning, as every change you make, updates the xml files so there is no history.

Am I missing something here?

Thank you.

magavi_framsteg
Partner - Creator III
Partner - Creator III

This will help versioning by tracking changes made to, but not limited to:

- Changes on object properties

- Changes on sheet properties

- Changes on document properties

- Changes in the load script

- etc.

All changes made to any part of your document will be recorded in the -prj XML-files.

Thus you will be able to diff them in a diff tool.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

giakoum
Partner - Master II
Partner - Master II

Thank you Magnus.

so you mean to say that in the xml files changes are recorded so there is history in them. Do you have any diff tool in mind I can use to check that?

BR, Ioannis.

Not applicable
Author

Hi,

I have three QV developers and need to be able to keep track of changes. I started testing QV10 with GIT and it looks promising.

Check these links out if you need more info

Rgdz,

Ed