What is our primary use case?
I have used this ETL tool for working with data in projects across several different domains. My use cases include tasks such as transforming data that has been taken from an API like PayPal, extracting data from different sources such as Magenta or other databases, and transforming all of the information.
Once the transformation is complete, we load the data into data warehouses such as Amazon Redshift.
How has it helped my organization?
There are a lot of different benefits we receive from using this solution. For example, we can easily accept data from an API and create JSON files. The integration is also very good.
I have created many data pipelines and after they are created, they can be reused on different levels.
What is most valuable?
The best feature is that it's simple to use. There are simple data transformation steps available, such as trimming data or performing different types of replacement.
This solution allows us to create pipelines using a minimal amount of custom coding. Anyone in the company can do so, and it's just a simple step. If any coding is required then we can use JavaScript.
What needs improvement?
I have been facing some difficulties when working with large datasets. It seems that when there is a large amount of data, I experience memory errors. If there is a large amount of data then there is definitely a lag.
I would like to see a cloud-based deployment because it will allow us to easily handle a large amount of data.
For how long have I used the solution?
I have been working with Hitachi Lumada Data Integration for almost three years, across two different organizations.
What do I think about the stability of the solution?
There is definitely some lag but with a little improvement, it will be a good fit.
What do I think about the scalability of the solution?
This is a good product for an enterprise-level company.
We use this solution for all of our data integration jobs. It handles the transformation. As our business grows and the demand for data integration increases, our usage of this tool will also increase.
Between versions, they have added a lot of plugins.
How are customer service and support?
The technical support does not reply in a timely manner. I have filled out the support request form, one or two times, asking about different things, but I have not received a reply.
The support they have in place does not work very well. I would rate them one or two out of ten.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
In this business, they initially began with this product and did not use another one beforehand. I have also worked on the cloud-level integration tool.
How was the initial setup?
The initial setup and deployment are straightforward.
I have deployed it on different servers and on average, it takes an hour to complete. I have not read any documentation regarding installation. With my experience, we were able to set everything up.
What's my experience with pricing, setup cost, and licensing?
I primarily work on the Community Version, which is available to use free of charge. I have asked for pricing information but have not yet received a response.
What other advice do I have?
We are currently using version 8.3 but version 9 is available. More features to support big data are available in the newest release.
My advice for anybody who is considering this product is if they're looking for any kind of custom transformation, or they're gleaning data from multiple sources and sending it to multiple destinations, I definitely recommend this tool.
Overall, this is a good product and I recommend it.
I would rate this solution an eight out of ten.
Which deployment model are you using for this solution?
On-premises