TrustRadius: an HG Insights company

Datameer

Score8.4 out of 10

17 Reviews and Ratings

Get a Demo

What is Datameer?

Datameer helps businesses clean up, combine, and organize data to make sense of it and use it for reports and machine learning.

Categories & Use Cases

Media

DATA TRANSFORMATION: SQL or No Code SQL SELECT statements can be used to explore and shape data. Work is represented visually on a canvas like interface, making it easier to design and maintain projects. Datameer includes library of pre-built drag-and-drop transformations to accelerate SQL development or transform datasets without writing code.
DATA CATALOG: Collaboration in Snowflake Search, Metadata, Data Profiling, and Auto documentation
AUTOMATION & INSIGHTS Insights can be sent to email or Slack, integrated, and deployed to Snowflake
PRODUCTION PIPELINES: From ad-hoc exploration to production pipelines GIT version control, materialization, dependency management, monitoring

1 / 4

Reviews

What users are saying about Datameer.
View all reviews

Four secure ETL pipeline tools in one platform at a sensible, constant price.

Abhinav PatelView profile
ETL Developer in Information Technology at Zeus Industrial Products, Inc. (501-1000 employees employees)

Pros

  • Scales data processing using elastic compute framework (Spark)
  • Simplifies the process of building ETL data pipelines in the cloud
  • Extensive data source connectivity and easily connects to source data using connectors
  • A fast learning curve with a no-code interface so anyone can use it
  • It provides an Excel-like interface to have quick and simple access to data
  • Transformation speed

Cons

  • Many tabs sometimes reduce your focus
  • Might be better to have a more compact design
  • Video tutorials are a little long

Return on Investment

  • Quick time to value. Transition from developer to learning Datameer is less than a day.
  • Workspace is drag and drop, which makes it intuitive and easy to use.
  • Speed of data transformations.
  • Pulling data from various sources.
  • Easy to schedule data pipelines.
  • Tailor made for Snowflake and Redshift.
  • Documentation is sometimes not updated quickly.
  • Training videos are a bit long.

Alternatives Considered

Fivetran, Matillion, Informatica PowerCenter and Talend Data Integration

Other Software Used

MySQL, Snowflake, Teradata Vantage - Enterprise Data Warehousing

For those who lack knowledge of SQL, this tool is indispensable

Incentivized
Verified User
Engineer in Engineering (201-500 employees employees)

Use Cases and Deployment Scope

We choose Datameer as my go-to platform for building up data pipelines for real-world applications. Recently, we have also begun using it to ETL data from our local servers to our cloud-based data warehouse. These pipelines are the lifeblood of my company's reporting and dashboard infrastructure. With Datameer, we were able to save money and resources that would have been used to establish and maintain a dedicated data operations team. The fact that Datameer users don't need to know how to code has led to the platform's adoption by businesses.

Pros

  • Connect to a broad variety of data sources with the help of robust connector support.
  • Its user interface is quite similar to that of Excel, making it easy to access your data.
  • Since it doesn't require any prior understanding of programming, there is a minimal learning curve for new users.

Cons

  • Concentration issues are possible while using a lot of tabs at once.
  • In most cases, the length of a tutorial video is excessive.
  • A more condensed design is certainly a viable option.

Return on Investment

  • Expedite the process of reaping the rewards. To learn how to utilize Datameer as a developer takes less than a day.
  • The workspace's drag-and-drop feature makes it easy to move about in a hurry.
  • Simple-to-schedule information processing pipelines.

Alternatives Considered

Snowflake and Apache Hive

Other Software Used

MongoDB, Apache Hive, MySQL, Microsoft 365

Datameer is great for sum

Mike Blizman, PMPView profile
Administration of Hadoop cluster - Cloudera, Datameer in Information Technology at Equifax (5001-10,000 employees employees)

Pros

  • Datameer is an excellent "bridge" to Hadoop. Organizations who want to get started with a Hadoop cluster and the analytic capabilities provided by Hadoop, but do not have a large software development team to assist in creating Map/Reduce code are likely to be able to do some very cool things with their data with Datameer.
  • The support team at Datameer has been very responsive and quite helpful. Online ticket/email for creation of support tickets, phone or web-ex as necessary.
  • Much of the tool will be familiar looking to Excel users.
  • Provides a single interface to many of the things a developer/analyst would need to do.

Cons

  • No specific examples of this in general, but as you mature in your use of Datameer, you may have to decide between investing in training of your staff to use other tools in the Hadoop ecosystem, or you may need to increase your hardware investment a little faster than you would expect to keep pace with demand for the tool as it gains users. One con, specific to our organization is the ingestion-based license model, which could be too expensive for our uses. With other tools such as Hive, HBase, CouchDB, the costs are based on your hardware investment and support contracts (and license fees for Couch).
  • It would be nice to have a mature API (web service based perhaps) for sharing infographics generated in Datameer and forward through a proxy or web portal. If we could have used Datameer to provide customer facing graphical output through our other web portals in a secure and manageable way, the value proposition of the Datameer product would have been increased tremendously as a solution. When we assessed doing this more than a year ago, we found the older style security API inadequate for this purpose. I was able to do a prototype use case through custom configuration and development methods around reverse proxies and the custom wrappers I built, but maintenance and administration would have been awkward. At current state of maturity in Hadoop tools, I think using Hadoop and associated tools as a work horse and data lake, as part of a data stream that is secured deep in your environment is the best approach. Reporting tools are maturing quickly to provide connectors to Hadoop, while facilitating report sharing in a proven manner, so I am very, very bullish on Hadoop in the long run. Learn more about Hadoop at www.datafoam.com.

Return on Investment

  • Cannot determine this accurately due to multiple variables changing simultaneously.

Usability

Datameer Personal Edition

Incentivized
Hector Jimenez
Product Owner (Scrum/Agile) in Information Technology at TradeStation Securities (1001-5000 employees employees)

Pros

  • It is the only solution out there that provides a true face to Hadoop and all the other technologies around it.
  • It enables regular users and analysts with capabilities that are only available for data scientists in other solutions.
  • It provides an "Excel-like" interface to have quick and simple access to data in Hadoop.

Cons

  • Data visualization and graphics. Right now it's not very user friendly. Creating dashboards requires a lot of work that can be done by the application

Return on Investment

  • We have not been able to reach our business objectives just yet.
  • Hadoop its a hard sell in most companies still.
  • Legacy skills are still highly on demand and as long as an easier path leverage SQL for example is available, it would be hard to gain more adoption.

Datameer Review

Ryan Baltes
Application Developer in Information Technology at Equifax (5001-10,000 employees employees)

Pros

  • Importing data is quick and painless. Datameer has the ability to import anything through a JDBC connection and many other protocols.
  • Datameers Excel-like interfaces makes it easy for non-technical users to execute queries.
  • Datameers ability to also graphically represent their queries sets it apart from many tools.

Cons

  • Datameer does not have drill down capabilities on their infographics. This capability is will be supported by the end of Q1.
  • Datameer can be buggy if the version is not supported by the distribution of Hadoop being used.
  • Datameer does not make it simple to create samples of data sets.

Return on Investment

  • Datameer has significantly increased the speed in which we run queries.
  • Datameer has significantly increased the ease of use and is very user friendly.
  • Datameer has brought a new look into batch processing and presented new possibilities.

Related Products

Products similar to Datameer that may also meet your needs.
All comparisons
Alteryx Platform
CompareLearn more
Alteryx Designer Cloud, edition
CompareLearn more
Tableau Prep
CompareLearn more
Sigma Computing
CompareLearn more
dbt
CompareLearn more