We performed a comparison between ETL Solutions Transformation Manager 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 is among the best, even if not widely known."
"Back in the day, we could only get reports and analyze what happened after the fact, but today now we can generate real-time insights. Transformation Manager feeds your data science projects. We generate models and then give them to the clients, so they can come up with real-time predictions and recommendations in addition to reporting."
"It is a reliable solution."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The setup was easy. All Microsoft products are easy to set up."
"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."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"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 solution is stable."
"There is room for improvement in the solution's visualization tool."
"They should build a functional architecture based on queuing."
"Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"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."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"The performance of SSIS could improve when comparing it to Oracle Database."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"It's a legacy tool, that is nearing the end of its useful life."
More ETL Solutions Transformation Manager Pricing and Cost Advice →
ETL Solutions Transformation Manager is ranked 32nd in Data Integration with 3 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. ETL Solutions Transformation Manager is rated 9.0, while SSIS is rated 7.6. The top reviewer of ETL Solutions Transformation Manager writes "It lets us create models so we can generate real-time predictions and insights for a our clients". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". ETL Solutions Transformation Manager is most compared with webMethods Integration Server, Axway AMPLIFY Application Integration, TIBCO Spotfire, Altair Monarch and Denodo, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our ETL Solutions Transformation Manager 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.