Infogix Data360 Analyze [EOL] vs SSIS comparison

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

"The most valuable feature of SSIS is that it can handle real complex transformations."

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."

"SSIS is easy to use."

"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."

"The setup is straightforward. It's very easy to install."

"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 most valuable features of SSIS are that it works with the query language and it can import data from different sources."

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

"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."

"The logging capabilities could be improved, particularly for error logging."

"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."

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

"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."

"Future releases should improve the data lineage, as it currently is not good."

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

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

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

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"The solution comes free of cost."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

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

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

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

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