Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Server Ideas

Share your Server product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Server: Allow server to use large-scale SQL backend (with enterprise options)

So - one of the biggest challenges that we have with the MongoDB used by Alteryx Server is that we continually have issues with locking (where our admins have to go in and undo locks)

Additionally - the current implementation of MongoDB connectivity does not support full Kerberos authentication which means that we're on a non-compliant install (which in a large enterprise is an uncomfortable place).

 

Given that a very large amount of what the server does is transactional - it would make sense to have an option to use a large-scale SQL server instead of using Mongo.   For large enterprise customers, there must be flexibility to allow the databases that they have large supported instances of (my strong preference would be MS SQL 2016).

 

MS SQL natively supports XML so all the canvasses can be stored in native format.   Additionally, MS SQL allows very fast query across XML, and given the clustering and reporting capabilities in MS SQL, this would dramatically increase our ability to self-manage our infra.

 

Given that Alteryx is looking more and more at large Enterprise customers - a move to a large-scale clustered SQL env as the back-end would be a very positive move.

 

NOTE: as we consider DB options for a SQL backend - please consider your large-scale enterprise customers.   For example - MS SQL or Oracle or DB2 are all much more prevalent in enterprises than databases like Postgres - so it's important to focus on the enterprise support for the DB that you choose.

 

@Deeksha @avinashbonu @revathi @BenBu

 

20 Comments
brandonculver
5 - Atom
I appreciate support for PostgreSQL as it allows cloud installations much easier but again MxSQL is really the sweet spot for non cloud installations.
Deeksha
7 - Meteor

@MattB   We have a fairly large Alteryx deployment and user base   we continue to anticipate a further  potential  growth in near future.

Currently   for our  Alteryx Platform Management  team    Postgres  knowledge is  very limited , we are trying hard to upskill our team with Mongo DB  management    (still a challenge) - if the backend DB strategy is being  reconsidered I would like to vote for MS SQL as the   preference. 

 

This would also empower us to use the   metadata   of canvas runs and properties  very efficiently to drive transparency and   efficiency  for our BI user community and senior stakeholders as the expertise on  working with SQL  backends is   common by far when compared to others.

 

CC:    @RajK@ydmuley@revathi@avinashbonu@SeanAdams

 

adrianloong
11 - Bolide

+1

adrianloong
11 - Bolide
+1 was for MS SQL
sd83893
6 - Meteoroid

@MattB- are there updates for PostgresSQL DB as backend?

afox1
6 - Meteoroid
My Fortune 25 company would like to see SQL or DB2. Oracle would be the last option, but that's really due to our usage of GCP to run the servers and GCP doesn't support Oracle currently. The main pain point is the lack of a "hot" backup option, and the lack of internal knowledge to manage our own MongoDB. If Alteryx would move to one of the "enterprise" DB platforms, it would help us continue to offer this with up time a global company needs.
DanM
Alteryx Community Team
Alteryx Community Team

We are still working on this idea. Please understand that this particular feature is quite the task to undertake. As soon as we get closer to completing the Idea of something close to it, we will update the status. Thanks for your patience and ideas.

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Revisit

Hi All! Thank you for your feedback, due to changes in our roadmap, development restrictions and changes in product team, this idea is no longer currently on the near future roadmap. Due to this we're updating the status to revisit, we'll update this idea again when or if we are able to add this feature to the product roadmap.

 

Thank you for your patience and understanding.

mbaerend
Alteryx
Alteryx
Status changed to: Coming Soon
 
SeanAdams
17 - Castor
17 - Castor

that is outstanding news @mbaerend