Azure Data Factory vs SSIS comparison

"The data copy template is a valuable feature."

"The overall performance is quite good."

"It's extremely consistent."

"What I like best about Azure Data Factory is that it allows you to create pipelines, specifically ETL pipelines. I also like that Azure Data Factory has connectors and solves most of my company's problems."

"The trigger scheduling options are decently robust."

"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."

"I like the basic features like the data-based pipelines."

"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."

"SSIS is easy to use."

"The product's deployment phase is easy."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."

"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."

"The solution is stable."

"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"It would be better if it had machine learning capabilities."

"Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue."

"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."

"Occasionally, there are problems within Microsoft itself that impacts the Data Factory and causes it to fail."

"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 main challenge with implementing Azure Data Factory is that it processes data in batches, not near real-time. To achieve near real-time processing, we need to schedule updates more frequently, which can be an issue. Its interface needs to be lighter."

"The performance could be better. It would be better if Azure Data Factory could handle a higher load. I have heard that it can get overloaded, and it can't handle it."

"Azure Data Factory uses many resources and has issues with parallel workflows."

"Improving the login procedure would make our reporting easier on monitoring our ETL processes."

"Video training would be a helpful addition."

"At one point, we did have to purchase an add-on."

"It hangs a lot of the time."

"The creation of the measure in the DAC's model could be improved."

"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."

"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."

"The performance of this solution is not as good as other tools in the market."

"Azure Data Factory gives better value for the price than other solutions such as Informatica."

"The cost is based on the amount of data sets that we are ingesting."

"The price you pay is determined by how much you use it."

"There's no licensing for Azure Data Factory, they have a consumption payment model. How often you are running the service and how long that service takes to run. The price can be approximately $500 to $1,000 per month but depends on the scaling."

"Product is priced at the market standard."

"Pricing is comparable, it's somewhere in the middle."

"It's not particularly expensive."

"It seems very low initially, but as the data grows, the solution’s bills grow exponentially."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"The solution comes free of cost."

"Our license with SSIS is annual."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"SSIS' licensing is a little high, but it gives good value for money."

"SSIS is fairly well-priced - I would rate it at four out of five."

"The solution is available at a lesser price than that of Informatica."