Infogix Data360 Analyze [EOL] vs SSIS comparison

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

"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."

"The script component is very powerful, things that you cannot normally do, is feasible through C#."

"The setup was easy. All Microsoft products are easy to set up."

"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."

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

"Overall, it's a good 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 memory processing needs to be improved because when you deal with a large amount of data, the interface tends to hang a little bit."

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

"SSIS is not stable."

"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."

"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."

"We'd like more integration capabilities."

"The solution could improve on integrating with other types of data sources."

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

"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 open-source version is free to use, although it has a limitation of two-million records."

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

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

"This solution is included with the MSSQL server package."

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

"SSIS is fairly well-priced - I would rate it at four out of five."

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

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

"The solution comes free of cost."