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

"The data flow, which controls the data, including where to store it, is an excellent feature and is one of the most interesting points about SQL Integration Services."

"Compatibility with the rest of Microsoft BI stack"

"The main value of any Microsoft product is the ease of use."

"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"It has good data integration and good processes."

"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

"Microsoft SQL Server Integration Services is one of the most effective ETL tools available in the market."

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

"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 logging capabilities could be improved, particularly for error logging."

"The solution should offer more information online for users of SSIS."

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

"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."

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

"At one point, we did have to purchase an add-on."

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

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

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

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

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

"SSIS is a cheaper option compared to the cost of other ETL tools."

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

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