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 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."
"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."
"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."
"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 UI is very user-friendly."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"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 workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The solution is stable."
"To get a higher rating, it would have to improve the price and the associated scalability. These are the main issues."
"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 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."
"Improvements could be made to mapping presentations."
"FME's price needs improvement for the African market."
"It needs more integration tools, so you can connect to different sources."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"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."
"This solution needs full support for real-time processing."
"The solution could improve on integrating with other types of data sources."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"The high prices attached to the product can be an area of concern where improvements are required."
"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."
FME is ranked 25th 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 Azure Data Factory, Alteryx Designer, 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 Informatica Cloud Data Integration. 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.
