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."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."
"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 product's deployment phase is easy."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"It's a competent product."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"Improvements could be made to mapping presentations."
"FME's price needs improvement for the African market."
"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."
"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."
"Options for scaling could be improved."
"I would like to see better technical documentation because many times information is missing."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"We have issues with SSIS connectors while extracting data from Excel sources."
"Performance could be better."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"We'd like them to develop data exploration more."
"Video training would be a helpful addition."
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 Matillion ETL, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and Oracle GoldenGate. 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.