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."
"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."
"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."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"It is easy to set up the product."
"The interface is very user-friendly."
"The scalability of SSIS is good."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"It's a competent product."
"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."
"FME's price needs improvement for the African market."
"Improvements could be made to mapping presentations."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"This solution needs full support for real-time processing."
"We have issues with SSIS connectors while extracting data from Excel sources."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The performance of this solution is not as good as other tools in the market."
"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."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"Generic processes should be used instead of custom code for each table."
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.