Try our new research platform with insights from 80,000+ expert users
it_user259983 - PeerSpot reviewer
Lead Consultant with 501-1,000 employees
Vendor
Session management needs improvement, but performs well with larger data volumes because it uses massively parallel processing.

What is most valuable?

The performance is the most valuable.

How has it helped my organization?

There is only a fraction of performance tuning that you need to be careful about, compared to Oracle DB.

What needs improvement?

Session management for client tools needs work.

For how long have I used the solution?

I've used it for nine months.

Buyer's Guide
VMware Tanzu Data Solutions
September 2025
Learn what your peers think about VMware Tanzu Data Solutions. Get advice and tips from experienced pros sharing their opinions. Updated: September 2025.
870,701 professionals have used our research since 2012.

How are customer service and support?

Customer Service:

Nothing to complain about.

Technical Support:

Nothing to complain about.

Which solution did I use previously and why did I switch?

Previously, there was Oracle database, and the EMC Greenplum database was used for better performance from larger data volumes because it uses massively parallel processing. This increased the performances multiple times while reducing time needed for optimization of database queries.

What about the implementation team?

We had a team from EMC, who had a very high level of expertise.

What other advice do I have?

It's a very good product for reducing the time and man power needed for database optimization for datawarehousing purposes.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Technical Lead at a tech vendor with 1,001-5,000 employees
Real User
Top 20
Needs more stability in terms of query results but we have improved our query response time.

What is most valuable?

External tables to load the data from flat files.

How has it helped my organization?

It helped us in loading millions of data in quick time & improved query response.

What needs improvement?

More stability in terms of query result.

For how long have I used the solution?

Five years - DCA V2.0 EMC & Greenplum Database

What was my experience with deployment of the solution?

No.

What do I think about the stability of the solution?

Not usually, but sometimes we do.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

Excellent.

Technical Support:

Excellent.

Which solution did I use previously and why did I switch?

We applied MPP Appliance for the first time earlier we were running on SMP’s.

How was the initial setup?

It was straightforward.

What about the implementation team?

Vendor- they had good expertise.

What was our ROI?

Good.

Which other solutions did I evaluate?

We also looked at Teradata.

What other advice do I have?

Very good and cost effective with very good customer support.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
VMware Tanzu Data Solutions
September 2025
Learn what your peers think about VMware Tanzu Data Solutions. Get advice and tips from experienced pros sharing their opinions. Updated: September 2025.
870,701 professionals have used our research since 2012.
it_user76890 - PeerSpot reviewer
Engineer at a marketing services firm with 51-200 employees
Vendor
We use Greenplum for production but not for development and testing because it consumes too much resources

We use the scrum methodology to manage our engineering work. And while this does give us the flexibility to quickly respond to changing business needs, it also means that our databases’ schemas are not set in stone. To accomodate frequent changes to the way we structure our data, we’ve adapted Ruby on Rails database migrations for use beyond our Rails apps.

Our first challenge was to find and extract the migration’s functionality from Rails so that we could use it without needing to bring in the other features of Rails we didn’t need. Thankfully, this turned out to be relatively simple because almost all of the functionality can already be accessed by Rake tasks, so it was just a matter of building a Rake file that contains the tasks we wanted from Rails. The only thing we had to add to get started was a Rake task for creating new migrations, since Rails creates them either automatically when creating new model objects or through the `rails generate migration` command.

We quickly ran into problems, though, because we use Greenplum, a DBMS built on Postgres that adds support for features that help accomodate big data. Unlike standard Postgres, Greenplum adds features, such as table partitions, not found in most DBMSes, but Rails is designed to be DBMS agnostic so you can easily switch between, say, Postgres and MySQL and SQLite without any more trouble than changing a single configuration file. So we decided to cut around Rails’s database abstractions and instead directly write SQL in our migrations and dump SQL structure files rather than Rails schema files.

Only this didn’t work because, to complicate matters further, although we use Greenplum in production and staging environments, for local testing and development we use Postgres because Greenplum has minimum requirements that ended up consuming too much of our workstations’ resources. So we ultimately ended up developing a hybrid solution that allows us to support Greenplum and Postgres in the same migrations.

The two main aspects of the solution are selective application of options when making changes to the database and keeping two separate dumps of the database, one for Greenplum with Greemplum-only syntax and one for Postgres with Greenplum-only syntax removed. For example, we rewrote the Rails `create_table` migration function to add support for Greenplum options like partitions, data distribution, and append-only tables, but then have the function ignore those options when running the migrations against our development Postgres databases. This allows us to use a single set of migrations on all of our databases, drastically simplifying what could have otherwise been a gnarly challenge.

By no means is our solution complete or perfect. It only supports those features of Greenplum that we use, and new features only get added in as we need them, plus there is some risk associated with keeping two separate schema dumps and the potential for them to get out-of-sync. Still, compared to maintaining a database with frequently changing schemas without the aid migrations, it’s lightyears better.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Integration Consultant at a tech services company with 11-50 employees
Real User
Easy installation, excellent price point, with room for ongoing scalability
Pros and Cons
  • "The most valuable feature for me is that it is open source. The licensing costs are really low and they are transparent."
  • "I would like to see the performance of the administration portal improved and additional messaging protocols."

What is our primary use case?

Our primary use case is as a messaging broker between enterprise applications. It makes for reliable and secure communication.

What is most valuable?

The most valuable feature for me is that it is open source. The licensing costs are really low and they are transparent. You know how much you are going to pay if you want the commercial version. If you want the open-source version, you do not have to pay anything and that is just as reliable as the commercial one.

What needs improvement?

I would like to see the performance of the administration portal improved and additional messaging protocols.

For how long have I used the solution?

I have been working with VMware RabbitMQ for the past eight years.

What do I think about the stability of the solution?

It is highly stable, reliable, and persistent.

What do I think about the scalability of the solution?

VMware RabbitMQ is definitely scalable.

How are customer service and support?

Technical support is excellent.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup was very easy and takes about five minutes to install.

What's my experience with pricing, setup cost, and licensing?

If you want to pay for the licensing it costs eight hundred dollars per CPU core annually with the support.

What other advice do I have?

I would give the following advice prepare a demo, with the vendor and check if it really applies to their needs. I would rate VMware RabbitMQ a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
Buyer's Guide
Download our free VMware Tanzu Data Solutions Report and get advice and tips from experienced pros sharing their opinions.
Updated: September 2025
Buyer's Guide
Download our free VMware Tanzu Data Solutions Report and get advice and tips from experienced pros sharing their opinions.