We performed a comparison between Infogix Data360 Analyze and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."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."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"We can connect with multiple data sources easily using an external connector in SSIS."
"Overall, it's a good product."
"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 debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"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."
"I would like to see better integration with Power BI."
"It needs more integration tools, so you can connect to different sources."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"The security could be improved, as it is more important in our context."
"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."
Earn 20 points
Infogix Data360 Analyze is ranked 52nd in Data Integration while SSIS is ranked 2nd in Data Integration with 69 reviews. Infogix Data360 Analyze is rated 7.0, while SSIS is rated 7.6. The top reviewer of Infogix Data360 Analyze writes "Easy drag-and-drop interface and supports custom Python functions, but the performance needs to be better". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Infogix Data360 Analyze is most compared with Alteryx Designer, Informatica PowerCenter and Azure Data Factory, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.