Infogix Data360 Analyze [EOL] vs SSIS comparison

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

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

"SSIS' most valuable feature is its reporting services."

"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."

"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."

"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

"The return on investment has been very high; the tool has made us tremendously more efficient and saved us a significant amount of money, though I cannot put an exact figure on it."

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

"The UI is very user-friendly."

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

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

"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

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

"There's no support for it at all. If you haven't undergone the qualifications, you wouldn't even know you should phone someone."

"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

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

"Improvement as per customer requirements."

"This solution needs full support for real-time processing."

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

"All of my clients have this product included as part of their Microsoft license."

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

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

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

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

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

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

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