We performed a comparison between HiT Software DBMoto and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Replication solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."DBMoto was very simple to set up and move our tables to the Oracle DB."
"The most valuable features are that is easy to install and it is user-friendly."
"The solution is easy to use and developer friendly."
"The performance is good."
"We can connect with multiple data sources easily using an external connector in SSIS."
"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."
"It's already very user-friendly and has a good dashboard."
"SSIS' most valuable feature is its reporting services."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"This product would be improved with additional built-in functions for simpler date conversion, as well as for data type transformations."
"Pricing is an area that needs improvement."
"It hangs a lot of the time."
"This solution needs full support for real-time processing."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"The solution could improve on integrating with other types of data sources."
"We have issues with SSIS connectors while extracting data from Excel sources."
"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."
"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."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
Earn 20 points
HiT Software DBMoto is ranked 17th in Data Replication while SSIS is ranked 2nd in Data Integration with 69 reviews. HiT Software DBMoto is rated 9.0, while SSIS is rated 7.6. The top reviewer of HiT Software DBMoto writes "Replication monitor feature is helpful in that it allows a quick view of the status, errors, and results of the last replication". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". HiT Software DBMoto is most compared with Informatica PowerCenter, E2E Bridge and Syniti Data Replication, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our HiT Software DBMoto vs. SSIS report.
We monitor all Data Replication 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.