Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
5 years ago
Solved

Using sharepoint folder as a data source - User account password changes

Hi,   I have just been asked an interesting question. We have a team who directly connects to Excel in a Sharepoint folder and they log in using their own Email address and Password.   Obviou...
  • GilbertQ's avatar
    5 years ago

    Hi DebbieE 

     

    What I have done is to create a service account, where the password never changes. Only very specific people have access to this accounts username and password.


    This same account is then also added to the Sharepoint folder with the same permissions.


    Then once this is setup in the Gateway it is setup once and does not have to be updated.