MySQL vs. SQL Server Integration Services

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
MySQL
Score 7.8 out of 10
N/A
MySQL is a popular open-source relational and embedded database, now owned by Oracle.N/A
SSIS
Score 7.9 out of 10
N/A
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.N/A
Pricing
MySQLSQL Server Integration Services
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
MySQLSSIS
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
MySQLSQL Server Integration Services
Considered Both Products
MySQL
Chose MySQL
MySQL is open source, readily available, with no licencing issues. Adding a new web product to my existing setup is relatively straight forward. In order to set up a SQL Server site, significant IT and licencing costs are involved. We are implementing some SQL Server back ends …
SSIS
Chose SQL Server Integration Services
SSIS works great with the above tools. We are a Microsoft shop so anything that fosters better integration among the various tools and platforms we use is very welcomed.
Chose SQL Server Integration Services
We utilize a Microsoft SQL Server backend, because of SSIS's integration with MSSQL, it was a no brainer for us!
Features
MySQLSQL Server Integration Services
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
MySQL
-
Ratings
SQL Server Integration Services
7.5
53 Ratings
11% below category average
Connect to traditional data sources00 Ratings8.853 Ratings
Connecto to Big Data and NoSQL00 Ratings6.240 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
MySQL
-
Ratings
SQL Server Integration Services
8.1
53 Ratings
1% below category average
Simple transformations00 Ratings8.553 Ratings
Complex transformations00 Ratings7.752 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
MySQL
-
Ratings
SQL Server Integration Services
7.4
51 Ratings
7% below category average
Data model creation00 Ratings8.627 Ratings
Metadata management00 Ratings7.133 Ratings
Business rules and workflow00 Ratings8.242 Ratings
Collaboration00 Ratings7.338 Ratings
Testing and debugging00 Ratings6.148 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
MySQL
-
Ratings
SQL Server Integration Services
6.9
41 Ratings
17% below category average
Integration with data quality tools00 Ratings7.436 Ratings
Integration with MDM tools00 Ratings6.436 Ratings
Best Alternatives
MySQLSQL Server Integration Services
Small Businesses
InfluxDB
InfluxDB
Score 8.8 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
SQLite
SQLite
Score 8.6 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
SQLite
SQLite
Score 8.6 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
MySQLSQL Server Integration Services
Likelihood to Recommend
8.1
(140 ratings)
8.0
(53 ratings)
Likelihood to Renew
9.0
(5 ratings)
10.0
(3 ratings)
Usability
8.0
(12 ratings)
9.3
(8 ratings)
Performance
-
(0 ratings)
8.8
(6 ratings)
Support Rating
9.0
(3 ratings)
8.2
(7 ratings)
Implementation Rating
8.0
(1 ratings)
10.0
(1 ratings)
User Testimonials
MySQLSQL Server Integration Services
Likelihood to Recommend
Oracle
MySQL is best suited for applications on platform like high-traffic content-driven websites, small-scale web apps, data warehouses which regards light analytical workloads. However its less suited for areas like enterprise data warehouse, OLAP cubes, large-scale reporting, applications requiring flexible or semi-structured data like event logging systems, product configurations, dynamic forms.
Read full review
Microsoft
Ideal for daily standard ETL use cases whether the data is sourced from / transferred to the native connectors (like SQL Server) or FTP. Best if the company uses MS suite of tools. There are better options in the market for chaining tasks where you want a custom flow of executions depending on the outcome of each process or if you want advanced functionality like API connections, etc.
Read full review
Pros
Oracle
  • Stable - it just runs, with minimal downtime or errors
  • Fast - well-structured data is quickly written and read
  • Secure - MySQL is easy to keep data secure from people and applications that shouldn't see it
  • Easy to use - SQL is industry standard so no problems with adding, editing and reading data stored in MySQL
Read full review
Microsoft
  • Ease of use - can be used with no prior experience in a relatively short amount of time.
  • Flexibility - provides multiple means of accomplishing tasks to be able to support virtually any scenario.
  • Performance - performs well with default configurations but allows the user to choose a multitude of options that can enhance performance.
  • Resilient - supports the configuration of error handling to prevent and identify breakages.
  • Complete suite of configurable tools.
Read full review
Cons
Oracle
  • Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
  • Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.
Read full review
Microsoft
  • SSIS has been a bit neglected by Microsoft and new features are slow in coming.
  • When importing data from flat files and Excel workbooks, changes in the data structure will cause the extracts to fail. Workarounds do exist but are not easily implemented. If your source data structure does not change or rarely changes, this negative is relatively insignificant.
  • While add-on third-party SSIS tools exist, there are only a small number of vendors actively supporting SSIS and license fees for production server use can be significant especially in highly-scaled environments.
Read full review
Likelihood to Renew
Oracle
For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.
Read full review
Microsoft
Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
Read full review
Usability
Oracle
I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
Read full review
Microsoft
SQL Server Integration Services is a relatively nice tool but is simply not the ETL for a global, large-scale organization. With developing requirements such as NoSQL data, cloud-based tools, and extraordinarily large databases, SSIS is no longer our tool of choice.
Read full review
Performance
Oracle
No answers on this topic
Microsoft
Raw performance is great. At times, depending on the machine you are using for development, the IDE can have issues. Deploying projects is very easy and the tool set they give you to monitor jobs out of the box is decent. If you do very much with it you will have to write into your projects performance tracking though.
Read full review
Support Rating
Oracle
We have never contacted MySQL enterprise support team for any issues related to MySQL. This is because we have been using primarily the MySQL Server community edition and have been using the MySQL support forums for any questions and practical guidance that we needed before and during the technical implementations. Overall, the support community has been very helpful and allowed us to make the most out of the community edition.
Read full review
Microsoft
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
Read full review
Implementation Rating
Oracle
1. Estimate your data size. 2. Test, test, and test.
Read full review
Microsoft
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
Read full review
Alternatives Considered
Oracle
MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.
Read full review
Microsoft
I had nothing to do with the choice or install. I assume it was made because it's easy to integrate with our SQL Server environment and free. I'm not sure of any other enterprise level solution that would solve this problem, but I would likely have approached it with traditional scripting. Comparably free, but my own familiarity with trad scripts would be my final deciding factor. Perhaps with some further training on SSIS I would have a different answer.
Read full review
Return on Investment
Oracle
  • As it is an open source solution through community solution, we can use it in a multitude of projects without cost license
  • The acquisition by Oracle makes you need to contract support for the enterprise version
  • If you have knowledge about oracle databases, you can get more out of the enterprise version
Read full review
Microsoft
  • Data integrity across various products allows unify certain processes inside the organization and save funds by reducing human labour factor.
  • Automated data unification allows us plan our inputs better and reduce over-warehousing by overbuying
  • The employee number, responsible for data management was reduced from 4 to 1 person
Read full review
ScreenShots