Infogix Data360 Analyze [EOL] vs SSIS comparison

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

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

"The UI is very user-friendly and I like that the solution has the ability to adapt to multiple data sources."

"The performance is good, it's easy to use, the visibility is great, and we have found the solution to be very straightforward to set up."

"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."

"The most valuable features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."

"The transformation of data is very good in SSIS."

"It is the most valuable for staff processes in order to gain efficiency."

"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."

"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."

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

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

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

"I'm not a fan of SSIS itself."

"Sometimes, there are compatibility issues with some features."

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

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

"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc. Also, handling of the different data types will be a big challenge here; so expecting improvement in these areas."

"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."

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

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

"It would be beneficial if the solution had a less costly cloud offering."

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

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

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

"Our license with SSIS is annual."

"We have an enterprise license for this solution."