topic XML Or Sql Server in QlikView

XML Or Sql Server

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

As per the user manual we can have the XML or Sql Server as the Repositary. Which is the best in terms of the performance.

Regards,

xxx

XML Or Sql Server

dpietersz — Tue, 14 Jun 2011 10:29:09 GMT

I would only use SQL if you are in a big enterprise environment (High security, lots of IT-control, Test environments, etc).

Otherwise just use XML. Reading/Writing to XML is fast enough.

It's not a performance choice, it's more an interfacing/control choice.

I've implemented a lot of QlikView servers and I always use XML.

XML Or Sql Server

Tue, 14 Jun 2011 11:09:51 GMT

Thanks for your response ,

I am installing the QlikView Server for the Big Enterprise environment. I would like to have control over the performance and manageability. And would like to know only sql server is supported or anyother database will be supported since sql server costing is there.

XML Or Sql Server

dpietersz — Tue, 14 Jun 2011 11:42:57 GMT

I'm not sure if other databases than SQL are supported. I will have to check for you. But can't do it at this moment.

Maybe someone else knows. Otherwise I will come back to you on that.

XML Or Sql Server

danielrozental — Tue, 14 Jun 2011 13:31:50 GMT

Here's what the Server reference manual says about it, sounds like a good starting point.

BTW, only SQL Server is supported.

Database requirements and recommendations for QlikView Publisher
The database in QlikView Publisher can be either a Microsoft SQL Server or an XML repository that
requires no pre-installed software.
The supported versions of Microsoft SQL Server are SQL Server 2000, SQL 2005 or SQL 2008. If you
have a Microsoft SQL Server already set up we recommend using that. The XML repository is sufficient for most installations when it comes to performance.
If you do not have a Microsoft SQL Server available we recommend that you start with an XML
repository installation and upgrade to Microsoft SQL Server if the performance is insufficient. It is possible to migrate all data in the database between XML repository and SQL Server.

XML Or Sql Server

Wed, 15 Jun 2011 06:09:09 GMT

Thanks for your response Daniel Rozental and Dimitri Pietersz