Oracle Big Data SQL vs SSIS comparison

"The user interface is really user-friendly and intuitive."

"This solution can maintain a large volume of data and is flexible to what data it can handle. The performance is very good."

"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."

"SSIS' best feature is SFTP connectivity."

"It has good data integration and good processes."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."

"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."

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

"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."

"The solution could improve by adding more advanced features."

"There is room for improvement in the pricing."

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

"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."

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

"SSIS is stable, but extensive ETL data processing can have some performance issues."

"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."

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

"SSIS is not stable."

"Options for scaling could be improved."

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

"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 is included with the MSSQL server package."

"We have an enterprise license for this solution."

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

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

"Our license with SSIS is annual."