Forum Discussion

xli629b's avatar
xli629b
Helper II
4 years ago

Updating credentials for a cloud data source as a service principal

I'm trying to update credentials for a cloud data source that uses OAuth2 as a service principal. The purpose is to be able to refresh the dataset. We would prefer not to use an on-premises gateway f...
Need Help
Andrew-T2's avatar
Andrew-T2
Frequent Visitor
3 years ago

Has anyone resolved this? I too find that cloud datasources credential updates don't seem to work (400 DM_GWPipeline_Gateway_DataSourceAccessError), and are mostly forgotten in the on-prem gateway oreinted documentation.

Trying to add a cloud datasource to the on-prem gateway doesn't help either.
Get Datasource Status didn't work for me either.

  • xli629b's avatar
    xli629b
    Helper II
    3 years ago

    We were eventually able to get this to work by calling Update Datasource with the cloud datasource gateway ID returned by Get Datasources. However, the following conditions also had to be true:

    1)  Used plain credentials, not encrypted ones:

    {
    credentialDetails: {
      credentialType: "OAuth2",
      credentials: "{\"credentialData\":[{\"name\":\"accessToken\",\"value\":\"eyJh[...]\"}]}",
      encryptedConnection: "Encrypted",
      encryptionAlgorithm: "None",
      privacyLevel: "None",
      useEndUserOAuth2Credentials: "False"
    }
}


    2) Used a service principal profile to upload the report/dataset and for all operations.