Try our new research platform with insights from 80,000+ expert users

Actian Ingres vs Azure Data Factory comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Actian Ingres
Average Rating
9.0
Number of Reviews
1
Ranking in other categories
Data Warehouse (22nd)
Azure Data Factory
Average Rating
8.0
Number of Reviews
86
Ranking in other categories
Data Integration (1st), Cloud Data Warehouse (3rd)
 

Featured Reviews

EG
Jan 28, 2021
Good multi-platform SQL compatibility, as well as performance and data integrity
We currently run Web server solutions (CMS, CRM business solutions). Our CMS solution is obviously very text-oriented, and our CRM Business Solution was built for a finance and asset management business, which is capable of handling millions of transactions. Performance, access control, data…
Camilo Velasco - PeerSpot reviewer
Oct 27, 2022
No deployment cost, quick implementation, pay only for the processing time and data
The primary use case of this solution is to extract ETLS, transform and load data, and organize database synchronization The most valuable feature of this solution is the data flow, which is the same SQL server in important service, integration services, which is a very robust and powerful tool…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server."
"Its integrability with the rest of the activities on Azure is most valuable."
"We haven't had any issues connecting it to other products."
"We have found the bulk load feature very valuable."
"I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."
"Feature-wise, one of the most valuable ones is the data flows introduced recently in the solution."
"It is beneficial that the solution is written with Spark as the back end."
"It makes it easy to collect data from different sources."
"The trigger scheduling options are decently robust."
 

Cons

"The ability to reset the log file without stopping the DBMS would be helpful for us."
"DataStage is easier to learn than Data Factory because it's more visual. Data Factory has some drag-and-drop options, but it's not as intuitive as DataStage. It would be better if they added more drag-and-drop features. You can start using DataStage without knowing the code. You don't need to learn how the code works before using the solution."
"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."
"Data Factory could be improved in terms of data transformations by adding more metadata extractions."
"The Microsoft documentation is too complicated."
"There is always room to improve. There should be good examples of use that, of course, customers aren't always willing to share. It is Catch-22. It would help the user base if everybody had really good examples of deployments that worked, but when you ask people to put out their good deployments, which also includes me, you usually got, "No, I'm not going to do that." They don't have enough good examples. Microsoft probably just needs to pay one of their partners to build 20 or 30 examples of functional Data Factories and then share them as a user base."
"The solution needs to be more connectable to its own services."
"Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."
"When working with AWS, we have noticed that the difference between ADF and AWS is that AWS is more customer-focused. They're more responsive compared to any other company. ADF is not as good as AWS, but it should be. If AWS is ten out of ten, ADF is around eight out of ten. I think AWS is easier to understand from the GUI perspective compared to ADF."
 

Pricing and Cost Advice

Information not available
"Azure Data Factory gives better value for the price than other solutions such as Informatica."
"I don't see a cost; it appears to be included in general support."
"While I can't specify the actual cost, I believe it is reasonably priced and comparable to similar products."
"The solution is cheap."
"Product is priced at the market standard."
"Data Factory is expensive."
"The pricing is a bit on the higher end."
"I would not say that this product is overly expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
814,763 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
25%
Government
11%
Manufacturing Company
9%
Educational Organization
7%
Financial Services Firm
13%
Computer Software Company
13%
Manufacturing Company
9%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

Ask a question
Earn 20 points
How do you select the right cloud ETL tool?
AWS Glue and Azure Data factory for ELT best performance cloud services.
How does Azure Data Factory compare with Informatica PowerCenter?
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 an...
How does Azure Data Factory compare with Informatica Cloud Data Integration?
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 Q...
 

Also Known As

Ingres, Ingres 2006
No data available
 

Learn More

Video not available
 

Overview

 

Sample Customers

Groupe Adeo, IsCool Entertainment
1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse. Updated: October 2024.
814,763 professionals have used our research since 2012.