Alteryx vs. Microsoft SQL Server

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Alteryx
Score 9.0 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.7 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.5 out of 10
SingleStore
SingleStore
Score 9.8 out of 10
Medium-sized Companies
Klipfolio
Klipfolio
Score 8.5 out of 10
SingleStore
SingleStore
Score 9.8 out of 10
Enterprises

No answers on this topic

SingleStore
SingleStore
Score 9.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
AlteryxMicrosoft SQL Server
Likelihood to Recommend
9.3
(126 ratings)
9.6
(96 ratings)
Likelihood to Renew
8.5
(19 ratings)
9.0
(6 ratings)
Usability
9.2
(52 ratings)
9.9
(10 ratings)
Availability
8.0
(4 ratings)
10.0
(1 ratings)
Performance
9.1
(37 ratings)
9.0
(1 ratings)
Support Rating
9.3
(52 ratings)
7.9
(25 ratings)
In-Person Training
7.0
(1 ratings)
9.0
(1 ratings)
Online Training
8.6
(2 ratings)
9.0
(1 ratings)
Implementation Rating
8.2
(5 ratings)
9.0
(5 ratings)
Configurability
7.5
(2 ratings)
10.0
(1 ratings)
Ease of integration
8.3
(3 ratings)
9.0
(1 ratings)
Product Scalability
7.7
(3 ratings)
9.0
(1 ratings)
Vendor post-sale
8.3
(2 ratings)
9.0
(1 ratings)
Vendor pre-sale
7.3
(1 ratings)
9.0
(1 ratings)
User Testimonials
AlteryxMicrosoft SQL Server
Likelihood to Recommend
Alteryx
We're trying right now to get more people using it at our company so we can send management documented cases for how we can expand and purchase Alteryx Server which will extend the capabilities even more and across more departments. It's been well suited for pretty much everything we do on a repeating schedule. It's worth the time to set up the workflows. When Treasury sends me the bank download now - I save it to a folder and run our workflows and send back 2 journal entries in .9 seconds. (yes - in less than a second it's finished running)
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
  • Alteryx is great for processes that is has already "thought through". It's more difficult to get Alteryx to deal with some customization.
  • The data visualizations with Alteryx are generally good, although I don't think the color schemes are the best.
  • I think the data science capabilities are awesome with Alteryx, although not as well used as products built with Python or R.
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
Alteryx is an extremely reliable platform. If there is an error in my workflow, I feel pretty strongly it was probably my fault. The platform also handles large amounts of data very quickly and can join/match, sort, filter, calculate on that data quickly as well. One of my favorite things to build into a workflow are the messages based on data/metadata and error messages based on errors I have come across before.
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
1st level of trainings which I've attended in Paris was easy and I was already knowing %90, that learning could have been an e-learning instead of in-person
Read full review
Microsoft
It was good
Read full review
Online Training
Alteryx
Very good, detailed online trainings which you can take at your own pace, and strong certifications exists, certifications are extremely detailed and hard...
Read full review
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
Alteryx is MUCH more user friendly. both provide the ability to code within them, but Alteryx has much nicer interface. The formula tools have a more simple language that is easier to learn than formulae in SSIS. Alteryx is easy to read with multi colored tools identifying what each one does. It also allows for macros. You can build your own tool to process records of data or batch records together.
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