topic Repository Database in QlikView

Repository Database

Sun, 25 Sep 2011 13:45:28 GMT

Hi All,

I was reading a pdf about system requirements and confused about two things:

1. For Repository Database, we need to have SQL Server 2005/2008 database. Do we need to buy a separate license for this or is it included in the QlikView license? We have a SQL Server 2005 instance, but it is on a separate server, can we install publisher on ServerA and have the Reposiory Databse on ServerB?

2. If you see the attached document, the first page talk about QlikView and secong page talk about QlikView Server. What is the difference?

Please advice and thanks a ton in advance!

Repository Database

Oleg_Troyansky — Sun, 25 Sep 2011 15:06:07 GMT

Hi,

this question belongs in the Server community, try there if you don't get your questions answered here.

1. Regarding SQL - I don't think that it's a good idea to have the Publisher installed on one machine and the Repository database running on another machine, even if it's technically possible.

2. If I''m not mistaken, you can always use XML as an alternative to SQL Server for the Repository. Can someone confirm or explain this better? If it still holds true, then you don't need another SQL license.

3. In the data sheet, "QlikView" pertains to the installed QlikView client, or QlikView Developer tool, as opposed to QlikView Server.

good luck!

Oleg

Re: Repository Database

jonathandienst — Sun, 25 Sep 2011 15:19:03 GMT

These are questions that you should address to your Qlikview partner/supplier, but here goes...

peaceout wrote:
1. For Repository Database, we need to have SQL Server 2005/2008 database. Do we need to buy a separate license for this or is it included in the QlikView license? We have a SQL Server 2005 instance, but it is on a separate server, can we install publisher on ServerA and have the Reposiory Databse on ServerB?

No, the Qlikview license does not include a SQL Server license. I don't know of any reason why the repository DB can't be on separate server - but I am not sure about this

peaceout wrote:
2. If you see the attached document, the first page talk about QlikView and secong page talk about QlikView Server. What is the difference?

The first page is talking about the QV clients - the first part is the QV desktop aplication, the second half is the browser compability chart for web clients.

Hope that helps

Jonathan

Re: Repository Database

Sun, 25 Sep 2011 15:34:45 GMT

Thanks for your replies,

If SQL Server license is not included and if it's not a good practice to have SQL and Reposiory Databse on different servers, then it implies that we have to buy SQL Server just for QlikView. Doesn't make much sense.

What other options do we have?

Re: Repository Database

nagaiank — Sun, 25 Sep 2011 17:58:16 GMT

Did you try using the free SQL Server Express edition?

Re: Repository Database

Sun, 25 Sep 2011 18:03:25 GMT

I can try it, but am aware of the limitations it put on the size of the Database etc. Moreover, there is no SQL Agent in the Express Edition and I don't even know if SQL Agent is needed for Publisher to do its tasks.

Repository Database

Oleg_Troyansky — Sun, 25 Sep 2011 23:07:11 GMT

The free alternative is to use XML repository.