We performed a comparison between FME and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It has a very friendly user interface. You don't need to use a lot of code. For us that's the most important aspect about it. Also, it has a lot of connectors and few forms. It has a strong facial aspect. It can do a lot of facial analysis."
"The most valuable feature of FME is the graphical user interface. There is nothing better. It is very easy to debug because you can see all steps where there are failures. Overall the software is easy to optimize a process."
"All spatial features are unrivaled, and the possibility to execute them based on a scheduled trigger, manual, e-mail, Websocket, tweet, file/directory change or virtually any trigger is most valuable."
"It has standard plug-ins available for different data sources."
"We make minor subtle changes to the workbenches to improve it. We can share the workbenches. We don't have to use GitHub or anything else."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The scalability of SSIS is good."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"It is easy to set up the product."
"Improvements could be made to mapping presentations."
"FME can improve the geographical transformation. I've had some problems with the geographical transformations, but it's probably mostly because I'm not the most skilled geographer in-house. The solution requires some in-depth knowledge to perform some functions."
"The one thing that always appears in the community is the ability to make really easy loops to loop through data efficiently. That needs to be added at some point."
"FME's price needs improvement for the African market."
"To get a higher rating, it would have to improve the price and the associated scalability. These are the main issues."
"Improvement as per customer requirements."
"This solution needs full support for real-time processing."
"The performance of this solution is not as good as other tools in the market."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"We'd like more integration capabilities."
"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."
"Tuning using this solution requires extensive expertise to improve performance."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
FME is ranked 24th in Data Integration with 5 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. FME is rated 8.6, while SSIS is rated 7.6. The top reviewer of FME writes "Great for handling large volumes of data, but it is priced a bit high". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". FME is most compared with Alteryx Designer, Azure Data Factory, Talend Open Studio, Informatica PowerCenter and SAP Data Services, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and Qlik Replicate. See our FME vs. SSIS report.
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.