Compare Pivotal Greenplum vs. SAP IQ

Pivotal Greenplum is ranked 7th in Data Warehouse with 4 reviews while SAP IQ is ranked 10th in Data Warehouse with 1 review. Pivotal Greenplum is rated 7.2, while SAP IQ is rated 8.0. The top reviewer of Pivotal Greenplum writes "A scalable and future-proof solution for data warehousing". On the other hand, the top reviewer of SAP IQ writes "An excellent column-based, enterprise relational database solution with good speed and compression". Pivotal Greenplum is most compared with Apache Hadoop, Amazon Redshift and Teradata, whereas SAP IQ is most compared with SAP Adaptive Server Enterprise, Apache Hadoop and SAP HANA.
Cancel
You must select at least 2 products to compare!
Pivotal Greenplum Logo
12,124 views|8,593 comparisons
SAP IQ Logo
3,738 views|2,640 comparisons
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: March 2020.
406,312 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
Pivotal Greenplum's shared-nothing architecture.The most valuable feature for us is horizontal scaling.Scalability is simple because it's an MPP database. If you need more processing power or you need more storage, you just add a few more nodes in the cluster. It works on common commodity hardware. You can use any type of server. You don't need to have proprietary hardware. It's fairly flexible.We chose Greenplum because of the architecture in terms of clustering databases and being able to have, or at least utilize the resources that are sitting on a database.

Read more »

Unbeatable speed and compression with a colummn-structured relational database.

Read more »

Cons
Initial setup is a little complex. It took around two weeks to deploy.I saw some limitation with respect to the column store, and removing this would be an improvement.Some integration with other platforms like design tools, and ETL development tools, that will enable some advanced functionality, like fully down processing, etc.The installation is difficult and should be made easier.

Read more »

The organization who owns the product does not support it well and appears not to be doing significant development for the future.

Read more »

Pricing and Cost Advice
We are using the open-source version of this solution.

Read more »

The only costs after standard licensing fees are for add-ons and upgrades.

Read more »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
406,312 professionals have used our research since 2012.
Ranking
7th
out of 31 in Data Warehouse
Views
12,124
Comparisons
8,593
Reviews
5
Average Words per Review
433
Avg. Rating
7.4
10th
out of 31 in Data Warehouse
Views
3,738
Comparisons
2,640
Reviews
1
Average Words per Review
1,235
Avg. Rating
8.0
Top Comparisons
Compared 37% of the time.
Compared 13% of the time.
Compared 11% of the time.
Compared 19% of the time.
Compared 18% of the time.
Also Known As
GreenplumSybase IQ
Learn
Pivotal
SAP
Overview

Advanced analytics meets traditional business intelligence with Pivotal Greenplum, the world’s first fully-featured, multi-cloud, massively parallel processing (MPP) data platform based on the open source Greenplum Database. Pivotal Greenplum provides comprehensive and integrated analytics on multi-structured data. Powered by one of the world’s most advanced cost-based query optimizers, Pivotal Greenplum delivers unmatched analytical query performance on massive volumes of data.

SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.

Offer
Learn more about Pivotal Greenplum
Learn more about SAP IQ
Sample Customers
General Electric, Conversant, China CITIC Bank, Aridhia, Purdue UniversityASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
Top Industries
REVIEWERS
Financial Services Firm44%
Marketing Services Firm19%
Comms Service Provider19%
Pharma/Biotech Company6%
VISITORS READING REVIEWS
Software R&D Company34%
Financial Services Firm15%
Comms Service Provider14%
Insurance Company4%
REVIEWERS
Financial Services Firm67%
Insurance Company11%
Healthcare Company11%
Marketing Services Firm11%
VISITORS READING REVIEWS
Software R&D Company30%
Comms Service Provider17%
Financial Services Firm13%
Government8%
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: March 2020.
406,312 professionals have used our research since 2012.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.