No deployment cost, quick implementation, pay only for the processing time and data
Pros and Cons
"The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."
"The solution can be improved by decreasing the warmup time which currently can take up to five minutes."
What is our primary use case?
The primary use case of this solution is to extract ETLS, transform and load data, and organize database synchronization.
What is most valuable?
The most valuable feature of this solution is the data flow, which is the same SQL server in important service, integration services, which is a very robust and powerful tool to transform data.
What needs improvement?
The solution can be improved by decreasing the warmup time which currently can take up to five minutes.
For how long have I used the solution?
I have been using the solution for two years.
What do I think about the stability of the solution?
The solution is extremely stable.
What do I think about the scalability of the solution?
The solution is scalable.
Which solution did I use previously and why did I switch?
Previously I used AWS Glue and SSIS.
How was the initial setup?
The initial setup is straightforward.
What about the implementation team?
The implementation was completed in-house and is immediate because it is a native cloud tool.
What was our ROI?
I have seen an ROI with the time saved migrating data for reports.
What's my experience with pricing, setup cost, and licensing?
The solution's fees are based on a pay-per-minute use plus the amount of data required to process. The more data you process the more CPUs and time is required which increases the cost of using this solution.
What other advice do I have?
I give the solution ten out of ten.
The only thing you need to deploy the solution is to click on publish.
The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability.
We have three people using the solution in our organization and one engineer that maintains it.
I recommend to any potential user to factor in the five-minute warm-up time that is required for each execution.
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Disclosure: I am a real user, and this review is based on my own experience and opinions.