Infogix Data360 Analyze [EOL] vs SSIS comparison

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

"It has good data integration and good processes."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

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

"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."

"The most important features are it works well and provides self-service BI."

"It's a competent product."

"The scalability of SSIS is good."

"The solution is easy to use and developer 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."

"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."

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

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

"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."

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

"Improvement as per customer requirements."

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

"Tuning using this solution requires extensive expertise to improve performance."

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

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

"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 would be beneficial if the solution had a less costly cloud offering."

"We have an enterprise license for this solution."

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

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

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

"Our license with SSIS is annual."