We performed a comparison between Actian Ingres and Azure Data Factory based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse."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."
"The most valuable features are data transformations."
"I like the basic features like the data-based pipelines."
"The feature I found most helpful in Azure Data Factory is the pipeline feature, including being able to connect to different sources. Azure Data Factory also has built-in security, which is another valuable feature."
"The workflow automation features in GitLab, particularly its low code/no code approach, are highly beneficial for accelerating development speed. This feature allows for quick creation of pipelines and offers customization options for integration needs, making it versatile for various use cases. GitLab supports a wide range of connectors, catering to a majority of integration needs. Azure Data Factory's virtual enterprise and monitoring capabilities, the visual interface of GitLab makes it user-friendly and easy to teach, facilitating adoption within teams. While the monitoring capabilities are sufficient out of the box, they may not be as comprehensive as dedicated enterprise monitoring tools. GitLab's monitoring features are manageable for production use, with the option to integrate log analytics or create custom dashboards if needed. The data flow feature in Azure Data Factory within GitLab is valuable for data transformation tasks, especially for those who may not have expertise in writing complex code. It simplifies the process of data manipulation and is particularly useful for individuals unfamiliar with Spark coding. While there could be improvements for more flexibility, overall, the data flow feature effectively accomplishes its purpose within GitLab's ecosystem."
"The most valuable feature of this solution would be ease of use."
"An excellent tool for pipeline orchestration."
"It's extremely consistent."
"This solution has provided us with an easier, and more efficient way to carry out data migration tasks."
"The ability to reset the log file without stopping the DBMS would be helpful for us."
"The deployment should be easier."
"One area for improvement is documentation. At present, there isn't enough documentation on how to use Azure Data Factory in certain conditions. It would be good to have documentation on the various use cases."
"This solution is currently only useful for basic data movement and file extractions, which we would like to see developed to handle more complex data transformations."
"We have experienced some issues with the integration. This is an area that needs improvement."
"In the next release, it's important that some sort of scheduler for running tasks is added."
"Some known bugs and issues with Azure Data Factory could be rectified."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"There's no Oracle connector if you want to do transformation using data flow activity, so Azure Data Factory needs more connectors for data flow transformation."
Earn 20 points
Actian Ingres is ranked 22nd in Data Warehouse while Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews. Actian Ingres is rated 9.0, while Azure Data Factory is rated 8.0. The top reviewer of Actian Ingres writes "Good multi-platform SQL compatibility, as well as performance and data integrity". On the other hand, the top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". Actian Ingres is most compared with Snowflake, Oracle Database Appliance, Databricks and Teradata, whereas Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse 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.