Infogix Data360 Analyze [EOL] vs SSIS comparison

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

"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."

"The solution is easy to use and developer friendly."

"We can connect with multiple data sources easily using an external connector in SSIS."

"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."

"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."

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

"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."

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

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

"Video training would be a helpful addition."

"The security could be improved, as it is more important in our context."

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

"We've had issues in terms of the amount of data that is transferred when we are scheduling."

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

"Improving the login procedure would make our reporting easier on monitoring our ETL processes."

"The performance of this solution is not as good as other tools in the market."

"We'd like them to develop data exploration more."

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

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

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

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

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

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"The solution comes free of cost."

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