Coming October 25: PeerSpot Awards will be announced! Learn more

Azure Data Factory Valuable Features

GaryM - PeerSpot reviewer
Data Architect at World Vision

The most valuable aspect has been a large list of no-cost source/target adapters.

It is also providing a PaaS ELT solution that integrates with other Azure resources. 

Its graphical UI is very good and is even now improving significantly with the latest preview feature of displaying inner activities within other activities such as ForEach and If condition.   

Its built-in monitoring and ability to see each activity's JSON inputs/outputs provides an excellent audit trail.

The trigger scheduling options are decently robust.

The fact that it's continually evolving is hopeful that even if some feature is missing today, it may be soon resolved. For example, it lacked support for simple SQL activity until earlier this year, when that was resolved.  

The Copy Activity Upsert option did not function when I first started using the tool but now seems to function quite well.  

It is built to be metadata driven to do large numbers of patterned ETL processes similar to what BIML provides for SSIS but much simpler to use than BIML. 

View full review »
Richard Domikis - PeerSpot reviewer
Chief Technology Officer at cornerstone defense

It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory.

It is very flexible. You can build any features you want.

View full review »
Brian Sullivan - PeerSpot reviewer
Chief Analytics Officer at Idiro Analytics

It's cloud-based, allowing multiple users to easily access the solution from the office or remote locations. I like that we can set up the security protocols for IP addresses, like allow lists. It's a pretty user-friendly product as well. The interface and build environment where you create pipelines are easy to use. It's straightforward to manage the digital transformation pipelines we build.

View full review »
Buyer's Guide
Azure Data Factory
September 2022
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
633,184 professionals have used our research since 2012.
Dan_McCormick - PeerSpot reviewer
Chief Strategist & CTO at a consultancy with 11-50 employees

The most valuable feature of Azure Data Factory is that it has a good combination of flexibility, fine-tuning, automation, and good monitoring.

View full review »
AS
Senior Manager at a tech services company with 51-200 employees

The overall architecture has been very valuable to us. It has allowed us to scale up pretty rapidly. That's something that has been very good for us. 

The solution can scale very easily.

The stability is very good and has improved very much over time.

View full review »
Kamlesh Sancheti - PeerSpot reviewer
Director at a tech services company with 1-10 employees

Azure Data Factory's most valuable features are the packages and the data transformation that it allows us to do, which is more drag and drop, or a visual interface. So, that eases the entire process.

Azure Data Factory setup is quite user-friendly.

I am happy with the interface.

View full review »
BG
Data Analytics Specialist at a pharma/biotech company with 10,001+ employees

One of the most valuable features of Azure Data Factory is the drag-and-drop interface. This helps with workflow management because we can just drag any tables or data sources we need. Because of how easy it is to drag and drop, we can deliver things very quickly. It's more customizable through visual effect. 

View full review »
Manoj Kukreja - PeerSpot reviewer
Technical Director, Senior Cloud Solutions Architect (Big Data Engineering & Data Science) at NorthBay Solutions

If you have a very simple pipeline you can use Data Factory for transformations, but it's really for serious analytics. This is an excellent tool for pipeline orchestration; connecting the different components and activities as well as gathering data. It's an orchestration tool, not a transformation tool. The monitoring feature has drastically improved.

View full review »
PD
User with 5,001-10,000 employees

Essentially, Azure Data Factory is more aligned to ETL, but I wanted to provide a solution for a full data lake solution where I could leverage functionality, whether it is ETL, data ingestion, data warehousing, or data lake.

View full review »
Anand Kumar Singh - PeerSpot reviewer
Enterprise Architect at TechnipEnergies

The best part of this product is the extraction, transformation, and load. In fact, we have found that the three of them work quite well. We are implementing the cloud-based system right now.

We see a lot of improvement with the most recent version of this solution. Some of the new features are very important to us.

View full review »
RK
Business Unit Manager Data Migration and Integration at a tech services company with 201-500 employees

The flexibility that Azure Data Factory offers is great.

View full review »
Charles Nordine - PeerSpot reviewer
Senior Partner at Collective Intelligence

The data mapping and the ability to systematically derive data are nice features. It worked really well for the solution we had. It is visual, and it did the transformation as we wanted.

View full review »
MG
Lead BI&A Consultant at a computer software company with 10,001+ employees

Azure Data Factory was chosen by the team that I was not on at the time and who decided that this would be the move to the future. So I just went along with it.

In terms of my personal experience, it works fine.

View full review »
Thomas Fuchs - PeerSpot reviewer
General Manager Data & Analytics at a tech services company with 1,001-5,000 employees

The data pipeline and the orchestration functionality are the most valuable aspects of the solution.

The interface is very good. It seeks to be very responsive and intuitive.

The initial setup is very quick and easy.

View full review »
Richard Griffin - PeerSpot reviewer
Manager Data & Analytics at Fletcher Building

It's fairly simple to use. The most valuable feature of this solution would be ease of use.

View full review »
BM
IT Analyst at a tech vendor with 10,001+ employees

The most important feature is that it can help you do the multi-threading concepts. It's in Informatica, but the resourcing is quite robust. You can scale up and scale down as per your needs.

View full review »
GB
Principal Engineer at a computer software company with 501-1,000 employees

The most valuable feature is the copy activity. Instead of creating a pipeline and then doing a source to target copy, this feature will create the pipeline directly.

View full review »
HF
Data engineer at INICON

The solution is okay.

View full review »
DD
PRESIDENT at a computer software company with 51-200 employees

The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components.

View full review »
Gyanendu Rai - PeerSpot reviewer
Senior Tech Consultant at Crowe

The most valuable feature of Azure Data Factory is the improved flexibility compared to SSIS that we previously used for our ETL transformation. I also enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management. All we need to do is create ARM templates.

View full review »
Anirban Bhattacharya - PeerSpot reviewer
Vice President at a tech vendor with 10,001+ employees

The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain.

Across the whole field of use, from accepting the ingestion and real-time SaaS ingestion for which we often use other components. These areas have been instrumental across the board.

View full review »
Andres Felipe Naranjo - PeerSpot reviewer
.NET Architect at a computer software company with 10,001+ employees

I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot.

View full review »
TD
Data engineer at Target

The most valuable feature of this solution is that it allows more data between on-premises and cloud solutions. It's also useful for orchestration for complex data flows and allows us to do ETL-based transitions heavily. In addition, it allows us to integrate with other third-party systems and compare features and pricing. Other valuable features include database replication, SQL service products, SLA support, data sharing, vendor lock-in, and support for developer tools.

View full review »
LB
IT Functional Analyst at a energy/utilities company with 1,001-5,000 employees

The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable.

View full review »
Balan Murugan - PeerSpot reviewer
Azure Technical Architect at a computer software company with 10,001+ employees

It has built-in connectors for more than 100 sources and onboarding data from many different sources to the cloud environment.

It has everything we needed.

Being able to post your feedback and queries is a very good feature that is offered by Azure Data Factory.

View full review »
Soumyojit Sen - PeerSpot reviewer
Director of Product Management at EIM solutions

The most valuable features are data transformations.

View full review »
SW
Senior Data Engineer at a real estate/law firm with 201-500 employees

I like Azure Data Factory, it works quite well.

It is always effective. It's extremely consistent.

View full review »
Sunil Singh - PeerSpot reviewer
Lead Engineering at GlobalLogic

I like that it's a monolithic data platform. This is why we propose these solutions.

View full review »
LS
Enterprise Data Architect at a financial services firm with 201-500 employees

Its integrability with the rest of the activities on Azure is most valuable.

It is also easier to work with. It has a nice user interface that would seem very familiar to some of the people who are coming from Microsoft SSIS and other similar kinds of activities. It makes it easy for them to pick it up quickly.

View full review »
Abdelmonem Metwally - PeerSpot reviewer
ETL/BI Senior Consultant at Qrious

This solution has provided us with an easier, and more efficient way to carry out data migration tasks.

View full review »
PedroNavarro - PeerSpot reviewer
BI Development & Validation Manager at JT International SA

The overall performance is quite good.

View full review »
NT
Senior Systems Analyst at a non-profit with 201-500 employees

The data copy template is a valuable feature. With the pipeline template, it takes only a few clicks for the on-premises data to come in. 

View full review »
Katarzyna Palikowska - PeerSpot reviewer
ETL Developer at a tech company with 10,001+ employees

Data Factory's most valuable feature is Copy Activity.

View full review »
AK
Director Technology at a computer software company with 10,001+ employees

Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations. It also has good integration with other Azure services.

View full review »
Buyer's Guide
Azure Data Factory
September 2022
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
633,184 professionals have used our research since 2012.