Effortless data analytics with flexible integration and room for advanced schema capabilities
What is our primary use case?
We use Dremio for financial data analytics and as a data lake. We connect Dremio with Oracle, Docker, MySQL, and utilize it for Power BI.
Additionally, we use it to process data from MongoDB, although we face occasional challenges with NoSQL integration.
What is most valuable?
Dremio is very easy to use for building queries. It's easy to connect Dremio to various databases and data sources like Oracle and MySQL. It is also very flexible, providing us with scalability and integration capabilities effortlessly.
What needs improvement?
There are performance issues at times due to our limited experience with Dremio, and the fact that we are running it on single nodes using a community version. We face certain issues when connecting Dremio to MongoDB, especially with max values, which seem to be inconsistent in Dremio.
Additionally, licensing is quite expensive, and we feel the need for more flexible schema capabilities, especially in embedding JSON from MongoDB.
For how long have I used the solution?
We have been using Dremio for more than two years.
What do I think about the stability of the solution?
In terms of stability, we experience performance issues occasionally, partly due to our limited experience.
What do I think about the scalability of the solution?
We have not yet scaled Dremio because we are using the community version, and require a license for scaling. We need to learn how to scale up and out more effectively.
How are customer service and support?
We haven't submitted any questions for technical support yet.
Which solution did I use previously and why did I switch?
We have worked with various data warehouse solutions, like Oracle, and also used databases on Azure.
How was the initial setup?
The initial setup was straightforward. We run Dremio on an Ubuntu dedicated server on-premises, and it took us about a day to set up.
What was our ROI?
We see savings because we don't need more personnel to develop and maintain Dremio. It's cost-effective in terms of manpower.
What's my experience with pricing, setup cost, and licensing?
The licensing is very expensive. We need a license to scale as we are currently using the community version.
Which other solutions did I evaluate?
We used Oracle and databases on Azure before using Dremio.
What other advice do I have?
Dremio is very flexible and easy to use, making it very suitable for our team. I would recommend Dremio for similar use cases due to its flexibility.
On a scale of one to ten, I would rate Dremio at eight.
Dremio is an excellent semantic layer and caching/acceleration/extract layer
What do you like best about the product?
The Reflections feature is awesome. It allows you to seamlessly accelerate queries by pre-aggregating query results at various aggregations that you can define over time, based on actual query usage. If you move away from Tableau, Dremio is how you can replace Tableau's Extract feature. Or, if you're using Superset, you can insert Dremio in between Superset and the data sources to auto-magically speed up slow queries and dashboards.
What do you dislike about the product?
Dremio OSS does not support encrypted ODBC or Flight connections. You need Enterprise for that.
What problems is the product solving and how is that benefiting you?
Speeding up slow Superset dashboards.
Good enterprise version bad open source
What do you like best about the product?
Easily centralizing data, with many sources and resources
What do you dislike about the product?
High difficult to mantain the environment, high resources demands
What problems is the product solving and how is that benefiting you?
Centralizing data
Data Engineer with 2 years experiences with Dremio
What do you like best about the product?
Virtualization data , also the open sources like Arrow, Iceberg.
What do you dislike about the product?
sometimes I had the OOM error and dont' know exactly why
What problems is the product solving and how is that benefiting you?
Data virtualization. that helps us a lot because at RTE, we have many different databases
Dream big with Dremio for big data processing
What do you like best about the product?
Dremio is a game changing tools that enhance our consultation service company to provide client with all the forecast, data management, and data transformation that client require. Easy tools to operate is the main attraction and visualized analytics report tools help client understand data that we present. Running K8 deployment/setup is easy with the help from detailed documentation. Apache Hadoop integration simplify data distribution workflow.
What do you dislike about the product?
Bugs on every version that they releases. After one bugs is fixed on update, other is emerged and need to wait for hotfix or update. The problem keep cycles.
What problems is the product solving and how is that benefiting you?
Simple solution for data analytics workflow and operation. Data integrity tools that remove and eliminate data duplication.
Powerful tool for me but with steep learning curve.
What do you like best about the product?
It handles big data well and supports SQL very easily when i start.
The performance improvements are noticeable easily.
It integrates with other tools which i use.
The data reflections feature enhances query speed and saves my times.
What do you dislike about the product?
Learning how to use it was hard for new user.
Setup took a long time.
Some features are not easy understand.
The interface could be more user friendly and with simple setup.
What problems is the product solving and how is that benefiting you?
Dremio helps us analyze large datasets without needing to move data.
The setup is hard but works is faster than other.
Easy to use for them who already know some.
Integration are good.
overall it is nice and good for me in my big small data analysis and management .
Data Visualization tool
What do you like best about the product?
It supports mutiple clouds such as aws and azure for data manipulation. It has amazing data manipulation capabilities. Its data managing capabilities are really good it works amazing in that regard. The usage is also smooth and easy. It has totally modernized our data visualizing approach.
What do you dislike about the product?
We dont have that issue but it can be pricy for the new organizations or startups.
What problems is the product solving and how is that benefiting you?
It helps us analyze and visualize data which is scattered across multiple places. Traditional data querying is really slow and inefficient but with dremio its really not that big of a challenge.
quick queries with a few issues.
What do you like best about the product?
with reflections, queries execute quickly. functions with a wide variety of data formats. appearance is good. personalisation is a plus for me.
What do you dislike about the product?
Sometimes software makes mistakes. Customer assistance is slow.
What problems is the product solving and how is that benefiting you?
our data analysis duties are completed more quickly. now, we can provide clients with insights more quickly.
Best way to manage Big data and Query !
What do you like best about the product?
Been using Dremio for a year now and it has been game changer for big data management and data distribution . It keeps the data workflow going smoothly without any issue. Its best part is that it is totally scalable and very secure. I would definately recommend this tool.
What do you dislike about the product?
It has all the necessary required tools for managing big data but it is not beginner friendly and have steep learning curve.
What problems is the product solving and how is that benefiting you?
Dremio play major role in managing data warehouse and creating bi data models . It made our team more productive and efficient . Queries run faster without error even on complex modelling.
Data lake house platform that provides high quality data visualization
What do you like best about the product?
Mainly we use it for data visualization It pulls data from various sources we use aws cloud and NOSQL stores. Dremio accelerates query performance by storing query response. It saves time without any manual intervention. Its stupidly easy to use and overall efficient.
What do you dislike about the product?
Nothing as such i think its a complete package. Customer support surely can be improved a little tiny bit.
What problems is the product solving and how is that benefiting you?
Data visualization and processing is the core usage of dremio for us we use it with nosql database and aws. It works really smoothly and we havent personally faced any issues with it.
