Easy-To-Use, One-Stop-Shop For All Your Data Integration Needs
What do you like best?
Datameer Spectrum connects to a multitude of data sources making it a great data integration solution. Very easy GUI lets us design complex ETL pipelines without spending time on coding. Easy to learn and master and includes transformation functions for any scenario. The Spark engine auto-scales and is very efficient. Datameer keeps adding more features and data connectors in Spectrum.
What do you dislike?
They have a large training library but some videos should be updated.
Recommendations to others considering the product:
1. Try it out quickly, alongside a modern DW like Snowflake or AWS. Run a project for a month or two and make your own conclusions.
2. Datameer is affordable compared to other vendors like Informatica and Fivetran. Spectrum engine autoscale is included in the price so test it without worring about additional costs.
3. Embrace their ELT approach and ask support for help if you need it. Support is very responsive.
What problems are you solving with the product? What benefits have you realized?
- ETLing of SaaS data to Cloud DWs (Snowflake & Redshift)
- Replication of custom databases to DW (postgres, MySQL, etc)
- Ingestion of CSV, JSON, and text files
- Data virtualization of production databases
Simplicity and consistency across the application. It just works as expected. People are surprised when I show them how easy it is to replicate a new dataset into our lake.
- We completely modernized our pipelines 6 months earlier than planned with Datameer Spectrum without the need for any additional headcount.
- Reduced production database import/export time from 5+ days to 10+ minutes and 300 TB storage is avoided with the virtualized databases.
