We changed our name from IT Central Station: Here's why

Azure Data Factory vs Informatica Cloud Data Integration comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: January 2022.
564,643 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The initial setup is very quick and easy.""The security of the agent that is installed on-premises is very good.""The best part of this product is the extraction, transformation, and load.""The solution can scale very easily.""Its integrability with the rest of the activities on Azure is most valuable.""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.""It is easy to integrate.""The most valuable feature is the ease in which you can create an ETL pipeline."

More Azure Data Factory Pros →

"The mass ingestion functionality and the elasticity of the solution are great.""Whether we need data cleansing or data mastering, we get it all in one platform.""The solution's initial setup is quite straightforward.""The user interface which is very easy to use if we have any problems to solve.""I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful.""Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors."

More Informatica Cloud Data Integration Pros →

Cons
"It can improve from the perspective of active logging. It can provide active logging information.""The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others.""If the user interface was more user friendly and there was better error feedback, it would be helpful.""My only problem is the seamless connectivity with various other databases, for example, SAP.""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.""The support and the documentation can be improved.""Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful.""The speed and performance need to be improved."

More Azure Data Factory Cons →

"I would like to see support for more data sources.""There may be some types of limitations with the performance.""A general improvement in icons and the virtual interface would be good.""The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions.""The price modeling could be more flexible.""Connectivity could be improved, it can be a little slow."

More Informatica Cloud Data Integration Cons →

Pricing and Cost Advice
  • "The price you pay is determined by how much you use it."
  • "Understanding the pricing model for Data Factory is quite complex."
  • "I would not say that this product is overly expensive."
  • "The licensing is a pay-as-you-go model, where you pay for what you consume."
  • "Our licensing fees are approximately 15,000 ($150 USD) per month."
  • "The licensing cost is included in the Synapse."
  • "It's not particularly expensive."
  • "Product is priced at the market standard."
  • More Azure Data Factory Pricing and Cost Advice →

  • "My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
  • More Informatica Cloud Data Integration Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
    564,643 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    AWS Glue and Azure Data factory for ELT best performance cloud services.
    Top Answer: 
    Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up and… more »
    Top Answer: 
    Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power… more »
    Top Answer: 
    Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge… more »
    Top Answer: 
    The mass ingestion functionality and the elasticity of the solution are great.
    Top Answer: 
    I think the price modeling could be improved. Currently, the IPU consumption is defined on a monthly basis and if you don't use all the IPUs available in a particular month, they are lost. A more… more »
    Ranking
    2nd
    Views
    27,271
    Comparisons
    22,407
    Reviews
    23
    Average Words per Review
    506
    Rating
    7.7
    2nd
    Views
    13,107
    Comparisons
    10,463
    Reviews
    6
    Average Words per Review
    417
    Rating
    7.8
    Comparisons
    Learn More
    Overview

    Create, schedule, and manage your data integration at scale with Azure Data Factory - a hybrid data integration (ETL) service. Work with data wherever it lives, in the cloud or on-premises, with enterprise-grade security.

    Informatica Cloud Data Integration is a unified and modern user experience across all iPaaS patterns, supported by a meta-data driven, modular, artificial intelligence-based microservices architecture tailored for IT, developers, and business users. It help delivers accessible, trusted, and secure data to facilitate more valuable business decisions and identify competitive advantages. Informatica Cloud Data Integration can help to distribute data warehouse and analytics projects. Features include the following: Deliver integrated and relevant data, Scale with data synchronization and replication, Integrate asset management, Support high-volume workloads, Design cloud mappings and Execute visual data integration flows.
    Offer
    Learn more about Azure Data Factory
    Learn more about Informatica Cloud Data Integration
    Sample Customers
    Milliman, Pier 1 Imports, Rockwell Automation, Ziosk, Real Madrid
    Chicago Cubs, Telegraph Media Group
    Top Industries
    REVIEWERS
    Computer Software Company29%
    Insurance Company12%
    Logistics Company6%
    Healthcare Company6%
    VISITORS READING REVIEWS
    Computer Software Company31%
    Comms Service Provider14%
    Financial Services Firm7%
    Energy/Utilities Company6%
    REVIEWERS
    Computer Software Company45%
    Pharma/Biotech Company18%
    Individual & Family Service9%
    Manufacturing Company9%
    VISITORS READING REVIEWS
    Computer Software Company34%
    Comms Service Provider10%
    Energy/Utilities Company7%
    Financial Services Firm7%
    Company Size
    REVIEWERS
    Small Business23%
    Midsize Enterprise28%
    Large Enterprise49%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise7%
    Large Enterprise75%
    REVIEWERS
    Small Business27%
    Midsize Enterprise23%
    Large Enterprise50%
    Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: January 2022.
    564,643 professionals have used our research since 2012.

    Azure Data Factory is ranked 2nd in Data Integration Tools with 21 reviews while Informatica Cloud Data Integration is ranked 2nd in Cloud Data Integration with 6 reviews. Azure Data Factory is rated 7.6, while Informatica Cloud Data Integration is rated 7.8. The top reviewer of Azure Data Factory writes "Easy to bring in outside capabilities, flexible, and works well". On the other hand, the top reviewer of Informatica Cloud Data Integration writes "Flexible licensing, good connectors, and timely upgrades and patches". Azure Data Factory is most compared with Informatica PowerCenter, Talend Open Studio, Palantir Foundry, Alteryx Designer and SAP Data Services, whereas Informatica Cloud Data Integration is most compared with Informatica PowerCenter, AWS Glue, Mule Anypoint Platform, Matillion ETL and Oracle Integration Cloud Service.

    We monitor all Data Integration Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.