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

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

"Compatibility with the rest of Microsoft BI stack"

"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."

"The data reader is the most valuable feature."

"The technical support is very good."

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

"The main value of any Microsoft product is the ease of use."

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

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

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

"If you run SSIS from the local system, it will lag, but it will work properly if you host on the cloud somewhere."

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

"It would be nice if you could run SSIS on other environments besides Windows."

"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."

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

"We have issues with SSIS connectors while extracting data from Excel sources."

"We have faced some problems, mostly from a different provider with different language handling."

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

"Our license with SSIS is annual."

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

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

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

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

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

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

"We have an enterprise license for this solution."