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."
"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."
"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 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."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"It is easy to set up. The deployment is also very quick."
"The setup is straightforward. It's very easy to install."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"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."
"SSIS is easy to use."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"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."
"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."
"To get a higher rating, it would have to improve the price and the associated scalability. These are the main issues."
"Improvements could be made to mapping presentations."
"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."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"I would like to see more features in terms of the integration with Azure Data Factory."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"We'd like them to develop data exploration more."
"We have issues with SSIS connectors while extracting data from Excel sources."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
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 AWS Glue, 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.