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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Sharepoint List Input/Output - Windows Authentication

I would like to request the ability to connect to a SharePoint List to bring data from and write data to via Windows Authentication.  Currently, the only way to connect to a SharePoint List is via username/password which does not work for our current environment.  

17 Comments
Atom

As has been mentioned by several other users (https://community.alteryx.com/t5/Data-Sources/Sharepoint-List-Credendials/m-p/20949), it would be great if there was the possibility to have Windows Authentication built into the SharePoint List tools.

Alteryx
Alteryx
Status changed to: New Idea

Thanks for the Idea, @NicolaQ! Will you please expand on your use case a bit- is it similar to the use case mentioned in the referenced link?

 

Best,

Alex

Atom

I would like to not have to hard code the SharePoint user credentials.  In the same way I connect to an SQL database through single sign on.

The use case is similar if not the same as the use case in the link.  I created the idea as I don't believe it was created.

Hi Alex,

 

My need is similar to NicolaQ.  Our current environment does not support SharePoint authentication via username/password, it requires Windows authentication.  I would like to know if you are planning on including the ability to connect to a SharePoint List using Windows authentication (not just username/password)?  It would go a long way for us and would definitely help Alteryx get more traction (additional licenses, usage) within our environment and our partner government agencies.  SharePoint is still heavily being used for many workflows (i.e. infopath forms) and retention of data (i.e. SharePoint Lists), and if Alteryx Designer could connect to SharePoint via Windows authentication then we could access that data with Alteryx and show people all that Alteryx can do 🙂

 

V/R,

Justin

Meteor

Yes please! Our company uses SharePoint as one of the avenues for report delivery and it would be really helpful to have this feature.

Atom

I second this. We use SharePoint but we won't be hardcoding network passwords into our Alteryx jobs. I was very surprised the SharePoint connector doesn't support Windows Authentication.

Meteoroid

Must have. Password authentication is not sufficient from a security perspective.

Yes, this is critical in the environment I work in.  

Alteryx
Alteryx
Status changed to: Comments Requested

Hi All,

 

Thanks for the feedback.

 

However, your windows credentials should work with our SharePoint connector. When you enter the credentials, make sure you're putting in your domain in addition to your windows username. Ex:"xxx\username".

 

Best,

Alex

Asteroid

I think it should have checkbox to use windows authentication, (like it does for other database connections). We don't want to hardcode usernames and passwords in the workflow.

Even though the password is encrypted, its simple encryption which can be rolled back.