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."
"We can connect with multiple data sources easily using an external connector in SSIS."
"It's saved time using visualization descriptions."
"The scalability of SSIS is good."
"It's already very user-friendly and has a good dashboard."
"It is easy to set up. The deployment is also very quick."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The initial setup of this solution is very straightforward."
"There is room for improvement in the solution's visualization tool."
"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."
"They should build a functional architecture based on queuing."
"We'd like more integration capabilities."
"Options for scaling could be improved."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"The performance of this solution is not as good as other tools in the market."
"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."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"This solution needs full support for real-time processing."
More ETL Solutions Transformation Manager Pricing and Cost Advice →
ETL Solutions Transformation Manager is ranked 34th 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, Denodo and Altair Monarch, 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.