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

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

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

"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."

"It's saved time using visualization descriptions."

"The setup is easy to use and understand."

"SSIS' best feature is SFTP connectivity."

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

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

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

"There is room for improvement in the pricing."

"Integration and the user interface are areas with certain shortcomings that require some improvements."

"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."

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

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

"The performance of this solution is not as good as other tools in the market."

"Tuning using this solution requires extensive expertise to improve performance."

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

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

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

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

"We have an enterprise license for this solution."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

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

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