We performed a comparison between CloverETL and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."No dependence on native language and ease of use."
"Key features include wealth of pre-defined components; all components are customizable; descriptive logging, especially for error messages."
"Connectivity to various data sources: The ability to extract data from different data sources gives greater flexibility."
"Server features for scheduler: It is very easy to schedule jobs and monitor them. The interface is easy to use."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"The initial setup was easy."
"The solution is stable."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"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."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"Resource management: We typically run out of heap space, and even the allocation of high heap space does not seem to be enough."
"Needs: easier automated failure recovery; more, and more intuitive auto-generated/filled-in code for components; easier/more automated sync between CloverETL Designer and CloverETL Server."
"Its documentation could be improved."
"Options for scaling could be improved."
"The solution could improve by having quicker release updates."
"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."
"The performance of SSIS could improve when comparing it to Oracle Database."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"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 creation of the measure in the DAC's model could be improved."
"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."
Earn 20 points
CloverETL is ranked 60th in Data Integration while SSIS is ranked 2nd in Data Integration with 69 reviews. CloverETL is rated 7.0, while SSIS is rated 7.6. The top reviewer of CloverETL writes "Provides wealth of pre-defined, customizable components, and descriptive logging for errors". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". CloverETL is most compared with iWay Universal Adapter Framework and Talend Open Studio, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.