Infogix Data360 Analyze [EOL] vs SSIS comparison

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

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

"It is well designed and quite straightforward, with not much of a learning curve involved, and it is a well-documented solution."

"It's saved time using visualization descriptions."

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

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

"The UI is very user-friendly."

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

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

"The technical support is very good."

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

"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."

"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."

"Technical support is not efficient, and I've had to search on the web to solve the problems."

"We'd like more integration capabilities."

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

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

"Improvement as per customer requirements."

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

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

"The solution is available at a lesser price than that of Informatica."

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

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

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

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

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

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