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."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."
"It has standard plug-ins available for different data sources."
"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."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"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."
"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."
"It's saved time using visualization descriptions."
"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 initial setup of this solution is very straightforward."
"The simplicity of the solution is great. The solution also offers excellent integration."
"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."
"FME's price needs improvement for the African market."
"Improvements could be made to mapping presentations."
"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."
"To get a higher rating, it would have to improve the price and the associated scalability. These are the main issues."
"Tuning using this solution requires extensive expertise to improve performance."
"I would like to see more features in terms of the integration with Azure Data Factory."
"The creation of the measure in the DAC's model could be improved."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"The solution could improve on integrating with other types of data sources."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"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."
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.