Infogix Data360 Analyze [EOL] vs SSIS comparison

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

"The initial setup of this solution is very straightforward."

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

"The main benefits SSIS provides for my company is to streamline processes, and the reporting process is the most useful for me, as most of our data is captured into SQL, making it easier to pull the differences in reports for the year."

"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."

"The most valuable features of this solution are the fast insert and fuzzy logic matching."

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

"The data reader is the most valuable feature."

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

"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 In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."

"The solution could improve by having quicker release updates."

"The creation of the measure in the DAC's model could be improved."

"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."

"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."

"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."

"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

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

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

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

"The solution comes free of cost."

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

"All of my clients have this product included as part of their Microsoft license."

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

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

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

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