Try our new research platform with insights from 80,000+ expert users

HiT Software DBMoto vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

HiT Software DBMoto
Average Rating
9.0
Reviews Sentiment
7.6
Number of Reviews
2
Ranking in other categories
Data Replication (22nd)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
Data Integration (4th)
 

Mindshare comparison

HiT Software DBMoto and SSIS aren’t in the same category and serve different purposes. HiT Software DBMoto is designed for Data Replication and holds a mindshare of 1.0%, up 0.9% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 7.9% mindshare, up 7.9% since last year.
Data Replication
Data Integration
 

Featured Reviews

reviewer1077405 - PeerSpot reviewer
Replication monitor feature is helpful in that it allows a quick view of the status, errors, and results of the last replication
We appreciate the ease of use in this solution. It looks like File Explorer, where you set up your source and targets. Replications are created simply by using the replication wizard. It also has functionality for scheduling, verification, and alerts. The ability to write code for transformations is very useful. Once the replications are set up it is simple to maintain. The Replication monitor is helpful in that it allows a quick view of the status, errors, and results of the last replication. Replication logs and history files are very useful for determining problematic data issues. The transaction latency tool is also helpful for determining how many connections are required for larger files. The replication types that are available are: Refresh Only, Continuous, and Synchronization. We currently use Refresh Only (scheduled refreshes), and Continuous. The source and target table verification is very helpful for running checks. The Replication Monitor is also a great plus, which shows a quick view of the replication status.
BobAmy - PeerSpot reviewer
Robust and does a good job of handling overload conditions
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. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable features are that is easy to install and it is user-friendly."
"DBMoto was very simple to set up and move our tables to the Oracle DB."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The technical support is very good."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"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."
"SSIS integrates well with SQL servers and Microsoft products."
 

Cons

"Pricing is an area that needs improvement."
"This product would be improved with additional built-in functions for simpler date conversion, as well as for data type transformations."
"The solution could improve on integrating with other types of data sources."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"The security could be improved, as it is more important in our context."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"The high prices attached to the product can be an area of concern where improvements are required."
"It would be nice if you could run SSIS on other environments besides Windows."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
 

Pricing and Cost Advice

"I found the price to be quite reasonable."
"Customers pay a license fee yearly."
"People have to opt for a perpetual-based licensing model."
"All of my clients have this product included as part of their Microsoft license."
"It would be beneficial if the solution had a less costly cloud offering."
"This solution is included with the MSSQL server package."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."
report
Use our free recommendation engine to learn which Data Replication solutions are best for your needs.
850,043 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

Ask a question
Earn 20 points
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
 

Also Known As

DBMoto
SQL Server Integration Services
 

Overview

 

Sample Customers

JAS Forwarding Worldwide, Animal, Financiera Pagos Internacionales C.F., Bur de Credito, Qualitas-IT, EFCO Corporation, Andrews Consulting, ASL Modena, BancAssurance Popolari S.p.A., Banco BICSA, Cheshire County Council, Epson Precision, Ferrari North America
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about HiT Software DBMoto vs. SSIS and other solutions. Updated: April 2025.
850,043 professionals have used our research since 2012.