Infogix Data360 Analyze [EOL] vs SSIS comparison

"This solution allows you to include your own functions that are coded in Python."

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

"The scalability of SSIS is good."

"SSIS integrates well with SQL servers and Microsoft products."

"Overall, I think for what this solution does, it's pretty much all there."

"Like most Microsoft products, SSIS is user-friendly and easy to use."

"The technical support is very good."

"With virtualization enabled we are able to scale horizontally."

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

"The product's deployment phase is easy."

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

"I would like to see more features in terms of the integration with Azure Data Factory."

"This may be done, but upgrades to new versions required re-implementing each package."

"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."

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

"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."

"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."

"I'm not a fan of SSIS itself."

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

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

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."

"This solution is included with the MSSQL server package."

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

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."

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

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

"The solution comes free of cost."