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 Designer Desktop Ideas

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

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

Submission Guidelines

TLS/SSL support with Alteryx Database Connectors

Hello,

 

I had a business case requiring a cost effective and quick storage solution for real time online sourced survey data from customers.  A MongoDB instance would fit the need, so I quickly spun up a cluster on Mongo Atlas.  Atlas was launched by MongoDB in 2016 as a database-as-a-service deployed on AWS.  All instances for Atlas require TLS/SSL to connect.  Currently, the Alteryx MongoDB connector does not support TLS/SSL connections and doesn't work against Atlas.  So, I was left with a breakdown in my plan that would require manual intervention before ingesting data to Alteryx (not ideal).

 

Please consider expanding this functionality on all connectors.  I am building Alteryx out in my agency as a data platform that handles sensitive customer information (name, address, email, etc.).  Most tools I use to connect to secure servers today support this type of connection and should be a priority for Alteryx to resolve. 

 

Thanks,

Mike Schock

 

 

 

 

28 Comments
adattoli
5 - Atom

Need this for the SharePoint connector!

ethunter90
5 - Atom

Sharepoint, I beg you. 

MichaelLehto
5 - Atom

This seems like something that should be essentially core capability. Can you provide an update on when this will be coming into your roadmap? 

jasonchester
5 - Atom

Removed Duplicate

jasonchester
5 - Atom

 

As there has not been much progress from Alteryx on SSL support for database connectors, I thought I would share a work around we are planning to use for connecting Alteryx with Azure Cosmos db Mongo api.

 

1. Install stunnel - https://www.stunnel.org/

 

2. Add the following service config to stunnel

C:\Program Files (x86)\stunnel\conf\)

[dev01]
client = yes
accept = 127.0.0.1:44317
connect = dev01.documents.azure.com:10255
verifyChain = yes
CAfile = ca-certs.pem
checkHost = dev01.documents.azure.com
OCSPaia = yes

 

3. Configure to run  as a windows service.

 C:\Program Files (x86)\stunnel\bin\stunnel.exe -install

 

With this solution in place, Alteryx can connect to mongo on localhost:44317 on an unencrypted connection.

 

neilmcg
7 - Meteor

We really need TLS 1.2 support for Sharepoint connections. We have business needs that require it.

saaraswath
5 - Atom
Need SSL support for Mongo DB cloud
Bjorn
5 - Atom

Please add support for TLS 1.2 for SharePoint connections as soon as possible. Have many business cases that require it.

DebbieC
5 - Atom

Another vote and star for Mongo DB SSL connection

Tim_A
5 - Atom

another vote for Mongo DB SSL connection