TLS/SSL support with Alteryx Database Connectors

[mschock]

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

[adattoli]

Need this for the SharePoint connector!

[ethunter90]

Sharepoint, I beg you. 

[MichaelLehto]

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]

Removed Duplicate

[jasonchester]

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]

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

[saaraswath]

Need SSL support for Mongo DB cloud

[Bjorn]

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

[DebbieC]

Another vote and star for Mongo DB SSL connection

[Tim_A]

another vote for Mongo DB SSL connection