What is our primary use case?
We use the solution for executing the ADF pipelines through the database port. We provide the scripts in the database, we run it, and it goes through the ADF pipeline. Afterward, through the database command, the ADF pipeline will run and push the data into Azure SQL.
What is most valuable?
I have found the solution to be flexible, easy to use, and the documents are straightforward to understand. For example, it is flexible, we have a single pipeline that has three phases, within approximately 15 minutes the records get transferred into this solution efficiently.
Additionally, the solution is well integrated with other solutions such as Power BI.
What needs improvement?
When we are doing transfers of records in large amounts, for example, petabytes of data or few long datasets, the performance should not degrade as it does. I am working on big data platforms like Informatica and others and even though there are terabytes of data being transferred it does it immediately. However, in this solution, I would like the performance to be there when building a large dataset to integrate the data.
For how long have I used the solution?
I have been using the solution for the past three years.
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
I have found the solution to be scalable. We use Teradata for large data and we are building the pipelines for it, so far it has operated well. We have approximately 25 individuals using the solution in my organization.
How are customer service and technical support?
The technical support is very good, if you have an issue they will be able to help.
Which solution did I use previously and why did I switch?
I have used Informatica in the past and it has some performance advantages compared to this solution.
What's my experience with pricing, setup cost, and licensing?
The solution does require a license.
What other advice do I have?
I would recommend this solution to others and we are going to continue using it in the future. We have numerous clients switching to this solution.
I rate Microsoft Azure a nine out of ten.
Which deployment model are you using for this solution?