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

"For people that are working in a Microsoft environment with the SQL Server database, it's the most recommended tool."

"The performance is good, it's easy to use, the visibility is great, and we have found the solution to be very straightforward to set up."

"We can connect with multiple data sources easily using an external connector in SSIS."

"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."

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

"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."

"The packaging and how it is organized is good for someone that really has never seen ETL before."

"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."

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

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

"Upgrading is usually painful and time consuming despite what MS says"

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

"The solution could improve on integrating with other types of data sources."

"It hangs a lot of the time."

"The solution could improve by having quicker release updates."

"Video training would be a helpful addition, however."

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

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

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

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

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

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

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

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

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