#1 most frequent
United States of America
70.6%314 installations of 445
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
1 / 4
Screenshot of 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.
Who Buys & Uses Datameer
#2 most frequent
Netherlands
5.4%24 installations of 445
#3 most frequent
India
4.5%20 installations of 445
Four secure ETL pipeline tools in one platform at a sensible, constant price.
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
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
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
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
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.
