Infogix Data360 Analyze [EOL] vs SSIS comparison

"The drag-and-drop functionality makes it easy for business users."

"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."

"It's a competent product."

"The product's deployment phase is easy."

"It has good data integration and good processes."

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

"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."

"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."

"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."

"The memory processing needs to be improved because when you deal with a large amount of data, the interface tends to hang a little bit."

"The high prices attached to the product can be an area of concern where improvements are required."

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

"SSIS has a difficult learning curve when dealing with complex transformations."

"Tuning using this solution requires extensive expertise to improve performance."

"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."

"We have a stability problem because when something works, it works one time. The next time, it doesn't work."

"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."

"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."

"The open-source version is free to use, although it has a limitation of two-million records."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

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

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

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

"It would be beneficial if the solution had a less costly cloud offering."

"People have to opt for a perpetual-based licensing model."

"SSIS is a cheaper option compared to the cost of other ETL tools."

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."