We performed a comparison between SQL Server and Tableau based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale. PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades. Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching."
"The performance is good."
"It helps with moving the design of the database into reality."
"The product’s most valuable features are flexibility and scalability."
"SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational."
"Most valuable features include: high availability, clustering, save backup and recovery."
"The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful."
"The scalability is very good."
"The most valuable features of the solution are the permission management and the user management."
"From my perspective, it enables clients to better understand our data and make better decisions based on that information."
"The initial setup is quick and easy and you don't need special outside assistance to set everything up."
"The stability seems to be very reliable."
"The dashboards are amazing, with different report types and stunning visuals. Most importantly, Tableau's AI with machine learning automatically predicts features and reports based on historical data. These are the three most valuable features for me."
"It is very easy to implement and to use."
"One of the most valuable features of Tableau is that it's a visual analytics solution, not just a dashboarding solution. Compared to Power BI, which is a dashboarding solution, there are no limitations with Tableau. For example, when you add a chart or a map to Power BI, it has a 3,000-point limitation. When you try to track your whole vehicle on the map, you only see the first 3,000 rows on the map, and Power BI doesn't tell you which part of the data is shown on the map. But Tableau doesn't have any limitations, which means that you can see five million data points on a map. It starts the project by creating the visuals that directly converts to SQLs. In that way, all the components have no limitations. When we compared Tableau to Power BI, we also found Tableau to be more fancy. Fancy means you can create more visual graphics and more visual dashboards. With Power BI, this isn't so—it's just some tables and some simple charts together. Tableau is more for business users who want to analyze data. Tableau can directly connect the analytics systems, like R or Titan, and get the results in screen, so it's a good solution for analytics scientists. It has some predefined capabilities to understand the data."
"Tableau is very good in the front-end visualization compared to Power BI."
"I would like to see SQL Server add the ability to write to multiple sites or support replication between multiple sites at the transaction level."
"Running multiple instances on the same box would be beneficial."
"SQL Server backups could be better."
"The solution needs to be more secure. It's lacking, compared to, for example, Oracle."
"There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets."
"If this solution could provide an automatic indexing feature it would be very useful."
"Security is an area that can be improved."
"While this is a reliable product, it has room for improvement."
"Provide additional enhancements in any business process: Operations, Marketing and Sales, Finance, Human Resources, Logistics, etc."
"It is not so great when it comes to data exchange/integration, data mining, etc."
"With Tableau, when you're dealing with very large datasets, it can be slow so the performance is an area that can be improved."
"Tableau support could be improved."
"The Hyper Extract functionality is not as strong as that provided by Microsoft SQL."
"The pricing is a bit higher than the competition. They'll need to lower it to stay competitive."
"When you're working on a dashboard, you can't select multiple components at a time and align them, so you have to go one by one. This is very cumbersome."
"From the developer perspective, the data connection handling the target data set is what most needs to be improved."
SQL Server is ranked 1st in Relational Databases Tools with 260 reviews while Tableau is ranked 2nd in BI (Business Intelligence) Tools with 293 reviews. SQL Server is rated 8.4, while Tableau is rated 8.4. The top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". On the other hand, the top reviewer of Tableau writes "Provides fast data access with in-memory extracts, makes it easy to create visualizations, and saves time". SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and SAP SQL Anywhere, whereas Tableau is most compared with Microsoft Power BI, Amazon QuickSight, Domo, SAS Visual Analytics and Databricks.
We monitor all Relational Databases Tools 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.