Azure Data Factory Room for Improvement

AS
reviewer1501113
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 »
Kamlesh Sancheti
Director at a tech services company with 1-10 employees

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 »
MayankRakesh
Sr. Technology Architect at a tech services company with 10,001+ employees

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 »
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: June 2021.
509,820 professionals have used our research since 2012.
Balan Murugan
Azure Technical Architect at a computer software company with 10,001+ employees

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 »
Anand Kumar Singh
Associate General Manager-Architecture at TechnipFMC

The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others.

View full review »
NK
reviewer982071
Delivery Manager at a tech services company with 1,001-5,000 employees

The setup and configuration process could be simplified.

View full review »
GV
reviewer1007019
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 »
RK
reviewer1435158
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 »
LG
Principa677
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 »
Thomas Fuchs
General Manager Data & Analytics at a tech services company with 1,001-5,000 employees

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 »
GB
reviewer1576407
Principal Engineer at a computer software company with 501-1,000 employees

Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful. I think that everything is there, but we need more tutorials.

View full review »
SB
reviewer1363377
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 »
AS
Avi Shvartz
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 »
AK
reviewer1236675
Microsoft Consultant at a tech services company with 201-500 employees

It would be helpful if they could adjust the data capture feature so that when there are source-side changes ADF could automatically figure it out.  

The solution needs to integrate more with other providers and should have a closer integration with Oracle BI.

View full review »
AJ
reviewer1418205
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 »
Andres Felipe Naranjo
.NET Architect at a computer software company with 10,001+ employees

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 »
Balan Murugan
Azure Technical Architect at a computer software company with 10,001+ employees

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 »
DawidDetko
Principal Data Architect at Predica

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 »
Suraj Kshirsagar
Azure Architect\Informatica ETL Developer at Relativity

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 »
Soumyojit Sen
Director of Product Management at EIM solutions

The speed and performance need to be improved.

This solution should be able to connect with custom APIs.

View full review »
AT
reviewer1248231
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 »
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: June 2021.
509,820 professionals have used our research since 2012.