community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Ideas

Share your Server product ideas - we're listening!

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

 

17 Comments
I appreciate support for PostgreSQL as it allows cloud installations much easier but again MxSQL is really the sweet spot for non cloud installations.
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

 

Alteryx Certified Partner
Alteryx Certified Partner

+1

Alteryx Certified Partner
Alteryx Certified Partner
+1 was for MS SQL
Meteoroid

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

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.
Community Operations Manager
Community Operations Manager

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.