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

HiT Software DBMoto vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

HiT Software DBMoto
Average Rating
9.0
Number of Reviews
2
Ranking in other categories
Data Replication (18th)
SSIS
Average Rating
7.8
Number of Reviews
71
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 0.8%, down 1.6% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 8.6% mindshare, down 9.6% since last year.
Data Replication
Data Integration
 

Featured Reviews

reviewer1077405 - PeerSpot reviewer
Apr 25, 2019
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.
Sakiru Dosumu - PeerSpot reviewer
Mar 1, 2024
Its ability to transform and transport data is extremely valuable
We use SSIS for data extraction, transformation, and loading processes. This includes extracting data from various sources like Oracle and SQL Server, and then transforming it for use in reporting tools like Power BI dashboards. While we haven't directly migrated data between databases using SSIS…

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."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The product's deployment phase is easy."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The initial setup of this solution is very straightforward."
"It is easy to set up the solution."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"It has good data integration and good processes."
"The setup is straightforward. It's very easy to install."
 

Cons

"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."
"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."
"The performance of SSIS could improve when comparing it to Oracle Database."
"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"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."
"I would like to see better integration with Power BI."
"It's a legacy tool, that is nearing the end of its useful life."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
 

Pricing and Cost Advice

"I found the price to be quite reasonable."
"Customers pay a license fee yearly."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"SSIS is fairly well-priced - I would rate it at four out of five."
"We purchased the standard edition of SQL Server and SSIS came with it free of charge."
"We have an enterprise license for this solution."
"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."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."
"This solution is included with the MSSQL server package."
report
Use our free recommendation engine to learn which Data Replication solutions are best for your needs.
814,649 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
17%
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.
 

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: October 2024.
814,649 professionals have used our research since 2012.