We performed a comparison between Infogix Data360 Analyze [EOL] 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."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The performance is good."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The technical support is very good."
"It's a competent product."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"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."
"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."
"Future releases should improve the data lineage, as it currently is not good."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Options for scaling could be improved."
"The performance of SSIS could improve when comparing it to Oracle Database."
"We have issues with SSIS connectors while extracting data from Excel sources."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
More Infogix Data360 Analyze [EOL] Pricing and Cost Advice →
Earn 20 points
Infogix Data360 Analyze [EOL] is ranked 52nd in Data Integration while SSIS is ranked 2nd in Data Integration with 69 reviews. Infogix Data360 Analyze [EOL] is rated 7.0, while SSIS is rated 7.6. The top reviewer of Infogix Data360 Analyze [EOL] 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 [EOL] 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.