Alteryx vs. Microsoft SQL Server

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Alteryx
Score 9.1 out of 10
N/A
Alteryx aims to be the launchpad for automation breakthroughs. Be it for personal growth, achieving transformative digital outcomes, or rapid innovation, Alteryx converges analytics, data science and process automation to enable users across organizations to make business-altering breakthroughs. Alteryx Designer can be used to automate every analytics step — from data prep to data science. Access any data source or type, then blend via drag-and-drop interface.…N/A
Microsoft SQL Server
Score 8.6 out of 10
N/A
Microsoft SQL Server is a relational database.
$1,418
Per License
Pricing
AlteryxMicrosoft SQL Server
Editions & Modules
No answers on this topic
Subscription
$1,418.00
Per License
Enterprise
$13,748.00
Per License
Offerings
Pricing Offerings
AlteryxMicrosoft SQL Server
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
AlteryxMicrosoft SQL Server
Considered Both Products
Alteryx
Chose Alteryx
We have not utilized any other tools like Alteryx or found any other tools like Alteryx to evaluate them against.
Chose Alteryx
Alteryx has many connectors that allow it to bring data in from various systems and export it to various formats and systems (SQL Server, Oracle DB, ODBCs, etc.) There are also additional connectors available provided by third parties that can help with connecting to other …
Chose Alteryx
Palantir has a much broader scope and is more difficult to use.
Chose Alteryx
Ease of use, Ease of deployment, completeness of reach, scalability, Total Cost of Ownership, Speed and flexibility
Chose Alteryx
Other comparable tools to Alteryx would be SAS, R, Python and Microsoft Azure Data Science Virtual Machines.
Chose Alteryx
Talend is primarily for data integration and has quite advanced capabilities. But the user has to be more technical. Alteryx makes the process simple and any user can make use of its features.

Tableau was a good choice for data visualization. We needed beautiful charts and ways …
Chose Alteryx
1. RapidMiner - another similar tool with rich set of functionalities, strong hep and support and similar black box algorithms with ease of drag - drop linking of components to achieve the purpose. Text mining is a great functionality here which is missing in Alteryx.
Microsoft SQL Server
Chose Microsoft SQL Server
Alteryx is great for scheduling reports and combing data, but if expert level is reached in SQL code writing, the results can be fairly synonymous.
Top Pros
Top Cons
Best Alternatives
AlteryxMicrosoft SQL Server
Small Businesses
Klipfolio
Klipfolio
Score 8.4 out of 10
SingleStore
SingleStore
Score 9.5 out of 10
Medium-sized Companies
Klipfolio
Klipfolio
Score 8.4 out of 10
SingleStore
SingleStore
Score 9.5 out of 10
Enterprises

No answers on this topic

SingleStore
SingleStore
Score 9.5 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
AlteryxMicrosoft SQL Server
Likelihood to Recommend
9.4
(113 ratings)
9.4
(96 ratings)
Likelihood to Renew
9.1
(15 ratings)
9.0
(6 ratings)
Usability
9.1
(50 ratings)
9.9
(10 ratings)
Availability
9.0
(4 ratings)
10.0
(2 ratings)
Performance
9.2
(22 ratings)
9.0
(2 ratings)
Support Rating
9.4
(52 ratings)
7.9
(49 ratings)
In-Person Training
-
(0 ratings)
9.0
(1 ratings)
Online Training
-
(0 ratings)
9.0
(1 ratings)
Implementation Rating
9.1
(3 ratings)
9.0
(10 ratings)
Configurability
9.1
(2 ratings)
10.0
(1 ratings)
Ease of integration
9.1
(4 ratings)
9.0
(1 ratings)
Product Scalability
8.4
(2 ratings)
9.0
(1 ratings)
Vendor post-sale
9.1
(2 ratings)
9.0
(1 ratings)
Vendor pre-sale
7.3
(2 ratings)
9.0
(1 ratings)
User Testimonials
AlteryxMicrosoft SQL Server
Likelihood to Recommend
Alteryx
The best scenario for Alteryx to make the biggest impact is within small-to medium-sized institutions where there isn't a fully established coding/data team in place. While it will ultimately be helpful wherever it is implemented, Alteryx can help these institutions from day 1 and continue lifting that load as you won't have to go back to the same project or workflow every day/week/month.
Read full review
Microsoft
Microsoft SQL Server is a great RDBMS and meets all of our requirements. If you need a stable DB platform to support your line of a business application you'll be well served. Licensing costs are far cheaper, more portable and a lot more user friendly than Oracle. Product support and security patches from Microsoft are strong.
Read full review
Pros
Alteryx
  • Pulling data from multiple disparate data sources.
  • Allows users to see the data at every step of the workflow to be able to cleanse, analyze, and optimize the data.
  • Provides an analytics platform that is easy for users of all levels to thrive in whether they are just starting out in their analytics journey or they have a master's degree in Data Science.
Read full review
Microsoft
  • Easy to configure and use with Visual Studio and Dot Net
  • Easy integration with MSBI to perform data analysis
  • Data Security
  • Easy to understand and use
  • Very easy to export database and tables in the form of SQL query or a script
Read full review
Cons
Alteryx
  • Steeper Learning Curve: Alteryx can have a steep learning curve for users who are new to the platform or have limited experience with data analytics. Enhancements to the user interface and user onboarding resources could help make the learning process more intuitive and accessible to a wider range of users.
  • Enhanced Data Visualization Capabilities: Alteryx offers basic data visualization capabilities, but there is room for improvement in terms of advanced visualizations and interactive dashboarding features. Adding more sophisticated chart types, interactive widgets, and customization options would enhance the data visualization capabilities within the platform.
  • Improved Error Handling and Debugging: Alteryx provides error handling mechanisms, but enhancing the error reporting and debugging capabilities would be beneficial. Improved error messages, better visibility into data flow, and debugging tools could help users troubleshoot and resolve issues more efficiently.
Read full review
Microsoft
  • The import/export process can be tricky to follow with lots of steps and could be better for importing flat files
  • Obtaining help from Microsoft is cumbersome and often other internet sources are better and quicker
  • The documentation is not great and again it's generally better to obtain help elsewhere if needed
Read full review
Likelihood to Renew
Alteryx
We've developed a working partnership with Alteryx. As an enablement suite, we're continuing to innovate and deliver great products with use of Alteryx in our solutions. Alteryx use expands to our global product development teams and is in use in multiple parts of our organization. Alteryx also delivers Experian demographic content to other clients in their product offering. We're highly likely to renew, but that decision is way above my pay grade.
Read full review
Microsoft
We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.
Read full review
Usability
Alteryx
I've found that while some things might take a little longer to create, the flexibility of Alteryx allows you to perform any function needed. I haven't found a use that was not available in Alteryx yet. APIs and XMLs can be created to perform certain functions. In addition, CMD line commands can be sent using Alteryx to perform certain functions as well.
Read full review
Microsoft
SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.
Read full review
Reliability and Availability
Alteryx
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Read full review
Microsoft
Its does not have outages.
Read full review
Performance
Alteryx
I have not complaints with the system. there are after events that can be added to flows that send emails with a stack trace for visibility into any errors. Stack traces include Tool IDs at the failure point to help debug. Overall the flows run quickly and once I work my own bugs out they are reliable
Read full review
Microsoft
SSAS data cubes may some time slow down your Excel reports.
Read full review
Support Rating
Alteryx
Stellar, bar-none. Some of the best support folks of any vendor. The Alteryx Community is the most responsive and supportive. On the rare occasion of a release issue or bug, we've been able to get quick help to solve the core problem. Alteryx does not play the blame game. They genuinely help the users solve their issues or respond to questions
Read full review
Microsoft
We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.
Read full review
In-Person Training
Alteryx
No answers on this topic
Microsoft
It was good
Read full review
Online Training
Alteryx
No answers on this topic
Microsoft
very hands on and detailed training
Read full review
Implementation Rating
Alteryx
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Read full review
Microsoft
Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.
Read full review
Alternatives Considered
Alteryx
Knime is open source and free. It also positions itself a little on machine learning. But the user experience and the features available are far less powerful than Alteryx. I was a former user of Lavastorm (ancestor of Infogix Data360) and got acquainted with the low-code graphical approach thanks to this tool. RapidMiner is the Alteryx for machine learning, but is not at all as tooled as Alteryx for data prep. I also like to use Orange BioLab which is really for machine learning and offers an excellent low-code/graphical user experience... on top of being free.
Read full review
Microsoft
[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.
Read full review
Scalability
Alteryx
Individual analysts can quickly generate results using their own copy of Alteryx Designer. But using the Server and developing macros for more complex needs can be time consuming.
Read full review
Microsoft
SQL server does handle growing demands of a mid sized company.
Read full review
Return on Investment
Alteryx
  • Error handling - allows controls to be built into workflows easily and allows them to be isolated and spat into control reports that can be easily reviewed and audited, thanks to the ability to create multiple outputs in one go.
  • Time-saving - saved huge amounts of time, especially when moving Excel processes into Alteryx.
  • Product development - allowed my firm to create products that we have been able to market and sell to clients.
Read full review
Microsoft
  • Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
  • Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
  • Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.
Read full review
ScreenShots

Alteryx Screenshots

Screenshot of Alteryx APA - Automating asset inputsScreenshot of Alteryx APA - Automating outcomesScreenshot of Alteryx APA - Data enrichment and insightsScreenshot of Alteryx APA - Data quality and preparationScreenshot of Alteryx APA - Data science and decisions