Infogix Data360 Analyze [EOL] vs SSIS comparison

"This solution allows you to include your own functions that are coded in Python."

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

"Overall, it's a good product."

"It is easy to set up the solution."

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

"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."

"It is well designed and quite straightforward, with not much of a learning curve involved, and it is a well-documented solution."

"It has good data integration and good processes."

"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."

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

"Connectivity to databases other than Microsoft. This is the Achilles' heel."

"Options for scaling could be improved."

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

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

"Improvement as per customer requirements."

"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."

"SSIS, however, is not that compatible with Informatica."

"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."

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

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

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

"SSIS' licensing is a little high, but it gives good value for money."

"Our license with SSIS is annual."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

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

"We have an enterprise license for this solution."

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