No more typing reviews! Try our Samantha, our new voice AI agent.

ETL Solutions Transformation Manager vs Elastic Search comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

Elastic Search
Average Rating
8.2
Reviews Sentiment
6.5
Number of Reviews
91
Ranking in other categories
Indexing and Search (1st), Cloud Data Integration (5th), Search as a Service (1st), Vector Databases (2nd)
ETL Solutions Transformatio...
Average Rating
9.0
Reviews Sentiment
6.8
Number of Reviews
3
Ranking in other categories
Data Integration (55th)
 

Featured Reviews

Anurag Pal - PeerSpot reviewer
Technical Lead at a consultancy with 10,001+ employees
Search and aggregations have transformed how I manage and visualize complex real estate data
Elastic Search consumes lots of memory. You have to provide the heap size a lot if you want the best out of it. The major problem is when a company wants to use Elastic Search but it is at a startup stage. At a startup stage, there is a lot of funds to consider. However, their use case is that they have to use a pretty significant amount of data. For that, it is very expensive. For example, if you take OLTP-based databases in the current scenario, such as ClickHouse or Iceberg, you can do it on 4GB RAM also. Elastic Search is for analytical records. You have to do the analytics on it. According to me, as far as I have seen, people will start moving from Elastic Search sooner or later. Why? Because it is expensive. Another thing is that there is an open source available for that, such as ClickHouse. Around 2014 and 2012, there was only one competitor at that time, which was Solr. But now, not only is Solr there, but you can take ClickHouse and you have Iceberg also. How are we going to compete with them? There is also a fork of Elastic Search that is OpenSearch. As far as I have seen in lots of articles I am reading, users are using it as the ELK stack for logs and analyzing logs. That is not the exact use case. It can do more than that if used correctly. But as it involves lots of cost, people are shifting from Elastic Search to other sources. When I am talking about pricing, it is not only the server pricing. It is the amount of memory it is using. The pricing is basically the heap Java, which is taking memory. That is the major problem happening here. If we have to run an MVP, a client comes to me and says, "Anurag, we need to do a proof of concept. Can we do it if I can pay a 4GB or 16GB expense?" How can I suggest to them that a minimum of 16GB is needed for Elastic Search so that your proof of concept will be proved? In that case, what I have to suggest from the beginning is to go with Cassandra or at the initial stage, go with PostgreSQL. The problem is the memory it is taking. That is the only thing.
Ravi Kuppusamy - PeerSpot reviewer
CEO and Founder at BAssure Solutions
It lets us create models so we can generate real-time predictions and insights for a our clients
Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing. I would like it if we could set the solution up to process and respond to real-time events. For example, say I want to configure an app to run based on the mileage a car has driven, and I configure the metering system, so the event occurs every 15 days. Let's say we want to automatically send an alert to EMS, police, etc. if a car gets into an accident. Transformation Manager is more of a conventional tool for reporting, extracting volume, bulk loading, etc. but there should be more provisions for dealing with real-time events, creating some insights, and dealing with perishable data. Ten minutes after the accident, the data doesn't have value. It has value before you saved the person.

Quotes from Members

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

Pros

"I value the feature that allows me to share dashboards with different people with different levels of access."
"We are developing a SIEM application that is similar to QRadar, ArcSight, or Splunk, and this application uses Elasticsearch as its search engine because we want to retrieve information fast."
"The solution offers good stability."
"Elastic Search makes handling large data volumes efficient and supports complex search operations."
"I appreciate the indexing capabilities and the speed of indexing in their product, which demonstrates how quickly logs are collected and stored."
"The most valuable feature of Elastic Enterprise Search is user behavior analysis."
"Elastic Search is the perfect tool for scalability."
"The special text processing features in this solution are very important for me."
"It is a reliable solution."
"Transformation Manager is the backbone of every data pipeline these days because the solution has been on the market for 20 to 30 years, and we use it for various industries, including financial services, manufacturing, healthcare, etc."
"It is among the best, even if not widely known."
"Back in the day, we could only get reports and analyze what happened after the fact, but today now we can generate real-time insights. Transformation Manager feeds your data science projects. We generate models and then give them to the clients, so they can come up with real-time predictions and recommendations in addition to reporting."
 

Cons

"There are a lot of manual steps on the operating system. It could be simplified in the user interface."
"We'd like to see more integration in the future, especially around service desks or other ITSM tools."
"The solution must provide AI integrations."
"The most significant issue I find with Elastic Search is that it gets out of sync, and this has happened in both cases where I have implemented it."
"To do what we want to do with Elastic Search, the queries can get complex and require a fuller understanding of the DSL."
"Enterprise scaling of what have been essentially separate, free open source software (FOSS) products has been a challenge, but the folks at Elastic have published new add-ons (X-Pack and ECE) to help large companies grow ELK to required scales."
"I have not been using the solution for many years to know exactly the improvements needed. However, they could simplify how the YML files have to be structured properly."
"Machine learning on search needs improvement."
"We get decent support. It's okay but not great."
"They should build a functional architecture based on queuing."
"There is room for improvement in the solution's visualization tool."
"Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing."
 

Pricing and Cost Advice

"The solution is free."
"The pricing structure depends on the scalability steps."
"This product is open-source and can be used free of charge."
"The tool is an open-source product."
"The price of Elastic Enterprise is very, very competitive."
"This is a free, open source software (FOSS) tool, which means no cost on the front-end. There are no free lunches in this world though. Technical skill to implement and support are costly on the back-end with ELK, whether you train/hire internally or go for premium services from Elastic."
"The solution is not expensive because users have the option of choosing the managed or the subscription model."
"We are using the Community Edition because Elasticsearch's licensing model is not flexible or suitable for us. They ask for an annual subscription. We also got the development consultancy from Elasticsearch for 60 days or something like that, but they were just trying to do the same trick. That's why we didn't purchase it. We are just using the Community Edition."
"It is an expensive solution."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
885,376 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
11%
Computer Software Company
10%
Manufacturing Company
9%
Retailer
7%
Construction Company
15%
Computer Software Company
13%
Outsourcing Company
12%
Retailer
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business38
Midsize Enterprise10
Large Enterprise46
No data available
 

Questions from the Community

What do you like most about ELK Elasticsearch?
Logsign provides us with the capability to execute multiple queries according to our requirements. The indexing is very high, making it effective for storing and retrieving logs. The real-time anal...
What is your experience regarding pricing and costs for ELK Elasticsearch?
On the subject of pricing, Elastic Search is very cost-efficient. You can host it on-premises, which would incur zero cost, or take it as a SaaS-based service, where the expenses remain minimal.
What needs improvement with ELK Elasticsearch?
From the UI point of view, we are using most probably Kibana, and I think they can do much better than that. That is something they can fine-tune a little bit, and then it will definitely be a good...
Ask a question
Earn 20 points
 

Also Known As

Elastic Enterprise Search, Swiftype, Elastic Cloud
Transformation Manager
 

Overview

 

Sample Customers

T-Mobile, Adobe, Booking.com, BMW, Telegraph Media Group, Cisco, Karbon, Deezer, NORBr, Labelbox, Fingerprint, Relativity, NHS Hospital, Met Office, Proximus, Go1, Mentat, Bluestone Analytics, Humanz, Hutch, Auchan, Sitecore, Linklaters, Socren, Infotrack, Pfizer, Engadget, Airbus, Grab, Vimeo, Ticketmaster, Asana, Twilio, Blizzard, Comcast, RWE and many others.
Honda, BNP Paribas, RBS, JPMorgan, Volkswagen, Thorn Lighting, OpenSpirit, Rolls-Royce, Ulster Bank
Find out what your peers are saying about ETL Solutions Transformation Manager vs. Elastic Search and other solutions. Updated: March 2026.
885,376 professionals have used our research since 2012.