PostgreSQL vs. QlikView

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
PostgreSQL
Score 8.6 out of 10
N/A
PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.N/A
QlikView
Score 8.0 out of 10
N/A
QlikView® is Qlik®’s original BI offering designed primarily for shared business intelligence reports and data visualizations. It offers guided exploration and discovery, collaborative analytics for sharing insight, and agile development and deployment.N/A
Pricing
PostgreSQLQlikView
Editions & Modules
No answers on this topic
QlikView
Custom
per user
Offerings
Pricing Offerings
PostgreSQLQlikView
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional DetailsOn an perpetual license basis, based on server plus number of users. Contact vendor for pricing.
More Pricing Information
Features
PostgreSQLQlikView
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
PostgreSQL
-
Ratings
QlikView
8.0
67 Ratings
2% below category average
Pixel Perfect reports00 Ratings8.049 Ratings
Customizable dashboards00 Ratings8.065 Ratings
Report Formatting Templates00 Ratings8.059 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
PostgreSQL
-
Ratings
QlikView
8.3
66 Ratings
3% above category average
Drill-down analysis00 Ratings9.065 Ratings
Formatting capabilities00 Ratings7.066 Ratings
Integration with R or other statistical packages00 Ratings8.336 Ratings
Report sharing and collaboration00 Ratings9.061 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
PostgreSQL
-
Ratings
QlikView
7.9
61 Ratings
5% below category average
Publish to Web00 Ratings8.048 Ratings
Publish to PDF00 Ratings9.056 Ratings
Report Versioning00 Ratings7.542 Ratings
Report Delivery Scheduling00 Ratings7.347 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
PostgreSQL
-
Ratings
QlikView
7.3
57 Ratings
10% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings7.754 Ratings
Location Analytics / Geographic Visualization00 Ratings7.546 Ratings
Predictive Analytics00 Ratings6.85 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
PostgreSQL
-
Ratings
QlikView
8.2
59 Ratings
4% below category average
Multi-User Support (named login)00 Ratings8.558 Ratings
Role-Based Security Model00 Ratings8.054 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.054 Ratings
Report-Level Access Control00 Ratings8.52 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
PostgreSQL
-
Ratings
QlikView
8.0
47 Ratings
1% above category average
Responsive Design for Web Access00 Ratings8.044 Ratings
Mobile Application00 Ratings9.028 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings8.038 Ratings
Best Alternatives
PostgreSQLQlikView
Small Businesses
InfluxDB
InfluxDB
Score 8.5 out of 10
SAP Crystal
SAP Crystal
Score 9.0 out of 10
Medium-sized Companies
SQLite
SQLite
Score 9.1 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
SQLite
SQLite
Score 9.1 out of 10
Jaspersoft Community Edition
Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
PostgreSQLQlikView
Likelihood to Recommend
8.7
(53 ratings)
8.5
(87 ratings)
Likelihood to Renew
9.0
(1 ratings)
8.8
(29 ratings)
Usability
9.0
(6 ratings)
8.2
(14 ratings)
Availability
9.0
(1 ratings)
9.8
(4 ratings)
Performance
7.0
(1 ratings)
8.6
(4 ratings)
Support Rating
9.3
(7 ratings)
3.3
(15 ratings)
Online Training
-
(0 ratings)
8.0
(3 ratings)
Implementation Rating
9.0
(1 ratings)
7.4
(13 ratings)
Product Scalability
8.0
(1 ratings)
8.9
(2 ratings)
User Testimonials
PostgreSQLQlikView
Likelihood to Recommend
PostgreSQL Global Development Group
PostgreSQL, unlike other databases, is user-friendly and uses an open-source database. Ideal for relational databases, they can be accessed when speed and efficiency are required. It enables high-availability and disaster recovery replication from instance to instance. PostgreSQL can store data in a JSON format, including hashes, keys, and values. Multi-platform compatibility is also a big selling point. We could, however, use all the DBMS’s cores. While it works well in fast environments, it can be problematic in slower ones or cause multiple master replication.
Read full review
Qlik
Sales data validations have helped manage our justifications in the past, especially with regard to new product development and new business introduction. It has also been helpful in identifying trends with business impact and direction specific to quarter and monthly sales from ERP data as well as decisions to purchase equipment of staffing based on run rates and product demand.
One thing that can get out of hand is data output - if you aren't careful in your query, you may be overloaded with data dumps and drown in the amount of info you have to filter through. This is a user caution, not a comment on the software itself.
Read full review
Pros
PostgreSQL Global Development Group
  • The stability it offers, its speed of response and its resource management is excellent even in complex database environments and with low-resource machines.
  • The large amount of resources it has in addition to the many own and third-party tools that are compatible that make productivity greatly increase.
  • The adaptability in various environments, whether distributed or not, [is a] complete set of configuration options which allows to greatly customize the work configuration according to the needs that are required.
  • The excellent handling of referential and transactional integrity, its internal security scheme, the ease with which we can create backups are some of the strengths that can be mentioned.
Read full review
Qlik
  • QlikView has a simple, relational data model that's REALLY fast. Filtering and changing data is dead simple results are almost immediately available.
  • The free version of Qlikview is almost completely featured, so you roll a pro-level product out to an entire department for really cheap.
  • QlikView is really flexible--if you can imagine it, you can build it.
Read full review
Cons
PostgreSQL Global Development Group
  • The query syntax for JSON fields is unwieldy when you start getting into complex queries with many joins.
  • I wish there was a distinction (a flag) you could set for automated scripts vs working in the psql CLI, which would provide an 'Are you sure you want to do X?' type prompt if your query is likely to affect more than a certain number of rows. Especially on updates/deletes. Setting the flag in the headless(scripted) flow would disable the prompt.
  • Better documentation around JSON and Array aggregation, with more examples of how the data is transformed.
Read full review
Qlik
  • We found that QlikView can be a bit slow in supporting some forms of encryption. It is web-based and we needed to upgrade all of our server to not support the older SSL and TLS 1 protocols, only support TLS 1.2 and TLS 1.3. However, QlikView could not run with TLS 1.2 and TLS 1.3. We had to wait over six months to get a version that would handle the newer TLS versions.
  • There are so many options with QlikView that you can get lost when developing a visualization. There are still items I have not yet figured out, such as labeling a graph with the name of a selected detail item.
  • QlikView works by pulling the data it is going to use for visualization into its database. I am a security reviewer and I need to make certain that PII and PHI is not pulled by QlikView for a visualization, otherwise this could become a reportable indecent.
Read full review
Likelihood to Renew
PostgreSQL Global Development Group
As a needed software for day to day development activities
Read full review
Qlik
Ease of use, ability to load from pretty much any data source. today I created an application that loaded time sheets from excel that are not in a table format. With Qlik's "enable transformation steps" I was able to automate loads of multiple spreadsheets and multiple tabs easily. Could not do that with any other tool.
Read full review
Usability
PostgreSQL Global Development Group
Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
Read full review
Qlik
QlikView is very easy to implement. The installation is very straight forward. QlikView has several different data connectors that can connect to different data sources very smoothly. The user interface to build the reports is very easy to understand. This helps to have a smaller learning curve. Something very helpful is that QlikView is a browser application for the end users. So, you don't need to install any applications on the user's computer.
Read full review
Reliability and Availability
PostgreSQL Global Development Group
PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.
Read full review
Qlik
We have not had any downtime issues with the product nor uncovered any significant bugs
Read full review
Performance
PostgreSQL Global Development Group
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
Read full review
Qlik
It is not a SAAS product.
Read full review
Support Rating
PostgreSQL Global Development Group
There are several companies that you can contract for technical support, like EnterpriseDB or Percona, both first level in expertise and commitment to the software.
But we do not have contracts with them, we have done all the way from googling to forums, and never have a problem that we cannot resolve or pass around. And for dozens of projects and more than 15 years now.
Read full review
Qlik
My experience with the Qlik support team has been somewhat limited, but every interaction I have had with them has been very professional and I received a response quickly. Typically if there is a technical issue, our IT team will follow up. My inquiries are specific to product functionality, and Qlik has been very helpful in clarifying any questions I might have.
Read full review
In-Person Training
PostgreSQL Global Development Group
No answers on this topic
Qlik
My team attended, but I cannot myself rate, but I think it was good as they've successfully launched a training program at our company themselves for users. It was 3-4 day training.
Read full review
Online Training
PostgreSQL Global Development Group
The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
Read full review
Qlik
Training was as expected. The demo environments tend to be more fully featured that our own environment, but the training was clear and well delivered.
Read full review
Implementation Rating
PostgreSQL Global Development Group
The online documentation of the PostgreSQL product is elaborate and takes users step by step.
Read full review
Qlik
"Implementation" can mean a few things... so I'm not sure that this is the answer you want.... but here it goes: To me, implementation means: "Is the user interface intuitive and can I produce meaningful reports with ease?" On that score, I'd say YES. The amount of training required was minimal and the results were powerful. The desktop implementation is a simple, "blank" interface just waiting for your creativity. The pre-populated templates give you a reasonable start to any project -- and a good set of objects to "play around with" if you're just getting started. Finally, note that the "implementation" I used was baked into QuickBooks 2016 Enterprise -- called "Advanced Reporting"..... That integration makes it ultra useful and simple.
Read full review
Alternatives Considered
PostgreSQL Global Development Group
Postgres stacks up just [fine] along the other big players in the RDBMS world. It's very popular for a reason. It's very close to MySQL in terms of cost and features - I'd pick either solution and be just as happy. Compared to Oracle it is a MUCH cheaper solution that is just as usable.
Read full review
Qlik
The only other vendor product that I have worked with that provides a similar experience to Qlikview is Tableau. I would recommend Tableau if your use case is to build a fixed dashboard. You can share reports for free without needing to buy additional licenses. I would recommend Qlikview if your users are looking for a more interactive experience. They can create new objects to represent the data which can't be accomplished as easily in Tableau
Read full review
Scalability
PostgreSQL Global Development Group
The DB is reliable, scalable, easy to use and resolves most DB needs
Read full review
Qlik
No answers on this topic
Return on Investment
PostgreSQL Global Development Group
  • The user-role system has saved us tons of time and thus money. As I mentioned in the "Use Case" section, Postgres is not only used by engineering but also finance to measure how much to charge customers and customer support to debug customer issues. Sure, it's not easy for non-technical employees to psql in and view raw tables, but it has saved engineering hundreds of man-hours that would have had to be spent on building equivalent tools to serve finance or customer support.
  • It provides incredibly trustworthy storage for wherever customer data dumped in. In our 6 years of Postgres existence, we have not lost a byte of customer data due to Postgres messing up a transaction or during the multiple times the hard-drives failed (thanks to ACID compliance!).
  • This is less significant, but Postgres is also quite easy to manage (unless you are going above and beyond to squeeze out every last bit of performance). There's not much to configure, and the out of the box settings are quite sane. That has saved us engineers lots of time that would have gone into Postgres administration.
Read full review
Qlik
  • You can use the free desktop version to do a lot of reporting and analysis work more quickly so the ROI is huge
  • QlikView is great at finding outliers such as data entry errors
  • QlikView is great at helping you quickly discover new insights about your business that can prompt you to take action that can immediately affect your cash flow.
Read full review
ScreenShots

QlikView Screenshots

Screenshot of QlikView Sales DashboardScreenshot of QlikView on all devicesScreenshot of QlikView using mobile touch screen