Infogix Data360 Analyze [EOL] vs SSIS comparison

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

"The setup is straightforward. It's very easy to install."

"SSIS integrates well with SQL servers and Microsoft products."

"The simplicity of the solution is great. The solution also offers excellent integration."

"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

"The interface is very user-friendly."

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

"The UI is very user-friendly."

"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."

"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 have issues with SSIS connectors while extracting data from Excel sources."

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."

"SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly."

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

"Future releases should improve the data lineage, as it currently is not good."

"I would like to see more features in terms of the integration with Azure Data Factory."

"It hangs a lot of the time."

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

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

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

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

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

"We have an enterprise license for this solution."

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