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

"SSIS is an easy way to do data integration from various data sources; it doesn't matter whether it's a database, flat files, XML, or Web API, it can talk to them and join them all together."

"The initial setup was easy, and we also used some YouTube videos for guidance."

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

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

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

"Its easy to use, fast to develop."

"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."

"The technical support is very good."

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

"This solution needs full support for real-time processing."

"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."

"I would like to see better technical documentation because many times information is missing."

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

"I would like to see better integration with Power BI."

"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."

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

"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases."

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

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

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

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

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

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

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