Azure Data Factory Room for Improvement
Senior Manager at a tech services company with 51-200 employees
My only problem is the seamless connectivity with various other databases, for example, SAP. Our transaction data there, all the maintenance data, is maintained in SAP. That seamless connectivity is not there.
Basically, it could have some specific APIs that allow it to connect to the traditional ERP systems. That'll make it more powerful. With Oracle, it's pretty good at this already. However, when it comes to SAP, SAP has its native applications, which are the way it is written. It's very much AWS with SAP Cloud, so when it comes to Azure, it's difficult to fetch data from SAP.
The initial setup is a bit complex. It's likely a company may need to enlist assistance.
Technical support is lacking in terms of responsiveness.View full review »
We are too early into the entire cycle for us to really comment on what problems we face. We're mostly using it for transformations, like ETL tasks. I think we are comfortable with the facts or the facts setting. But for other parts, it is too early to comment on.
We are still in the development phase, testing it on a very small set of data, maybe then the neatest four or bigger set of data. Then, you might get some pain points once we put it in place and run it. That's when it will be more effective for me to answer that.View full review »
At this point in time, they should work on somehow integrating the big data capabilities within it. I have not explored it, but it would be good if somehow we could call a Spark job or something to do with the Spark SQL within ADS so that we wouldn't need a Spark tested outside.
On the UI side, they could make it a little more intuitive in terms of how to add the radius components. Somebody who has been working with tools like Informatica or DataStage gets very used to how the UI looks and feels.
In ADS, adding a new table or joining a new table and overriding that with an override SQL that I could customize would be helpful.
Being able to debug from the design mode itself would be helpful.View full review »
The user interface could use improvement. It's not a major issue but it's something that can be improved.
It has the ability to create separate folders to organize objects, Data Factory objects. But any time that we created a folder we were not able to create objects. We had to drag and drop into the folder. There were no default options. It was manual work. We offered their team our feedback and they accepted my request.View full review »
The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others.View full review »
Delivery Manager at a tech services company with 1,001-5,000 employees
The setup and configuration process could be simplified.View full review »
Head of IT at a logistics company with 10,001+ employees
Because I have not really done a really deep benchmark against competitors, I may not be familiar enough with the potential of competing products and capabilities to be able able to say what is missing or should be improved definitively.
From my perspective, the pricing seems like it could be more user-friendly. Of course, nothing is ever as inexpensive as you want.
Perhaps one good additional feature would be incorporating more ways to import and export data. It would be nice to have the product fit our service orchestration platform better to make the transfer more fluid.View full review »
Business Unit Manager Data Migration and Integration at a tech services company with 201-500 employees
The number of standard adaptors could be extended further. What we find is that if we develop data integration solutions with Data Factory, there's still quite a bit of coding involved, whereas we'd like to move in a direction with less coding and more select-and-click.View full review »
Principal Consultant at a tech services company with 11-50 employees
I think more integration with existing Azure platform services would be extremely beneficial.
In the next release, it's important that some sort of scheduler for running tasks is added. A built-in scheduling mechanism for running the treasury will be a very helpful improvement.View full review »
I'm more of a general manager. I don't have any insights in terms of missing features or items of that nature.
Integration of data lineage would be a nice feature in terms of DevOps integration. It would make implementation for a company much easier. I'm not sure if that's already available or not. However, that would be a great feature to add if it isn't already there.View full review »
Principal Engineer at a computer software company with 501-1,000 employees
Data Strategist | Azure Solutions Architect at a tech services company with 11-50 employees
I'm not sure if I have any complaints about the solution at the moment. There are a few bits and pieces that we would like to see improved. These include improvements related to the solution's ease of use and some quality flash upgrades. However, these are minor complaints.
If the user interface was more user friendly and there was better error feedback, it would be helpful.View full review »
CTO at a construction company with 1,001-5,000 employees
The pricing scheme is very complex and difficult to understand. Analyzing it upfront is impossible, so we just decided to start using it and figure out the costs on a weekly or monthly basis.View full review »
Microsoft Consultant at a tech services company with 201-500 employees
BI Practice Lead at a tech services company with 1,001-5,000 employees
I find that Azure Data Factory is still maturing, so there are issues. For example, there are many features missing that you can find in other products.
You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats. For example, there are problems dealing with data that is comma-delimited.View full review »
It would be better if it had machine learning capabilities. For example, at the moment, we're working with Databricks and Azure Data Factory. But Databricks is very complex to do the different data flows. It could be great to have more functionalities to do that in Azure Data Factory.View full review »
Understanding the pricing model for Data Factory is quite complex. It needs to be simplified, and easier to understand.
We have experienced some issues with the integration. This is an area that needs improvement.View full review »
The solution could use some merge statements.
The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way.View full review »
Azure Data Factory is a bit complicated compared to Informatica. There are a lot of connectors that are missing and there are a lot of instances where I need to create a server and install Integration Runtime.
The support and the documentation can be improved.
There are a lot of tasks that you need to write code for.View full review »
The speed and performance need to be improved.
This solution should be able to connect with custom APIs.View full review »
Team Leader at a insurance company with 201-500 employees
The only thing that we're struggling with is increasing the competency of my team. So we think that the Microsoft documentation is too complicated.
I would like to see it more connected. I know they're working on the Snowflake data warehouse connector, but more connectors would be helpful.View full review »