Qlik connector to OneDrive and security

[Yves_Jezequel]

Hello,

We are users of both Qlik Sense Enterprise on Windows and OneDrive.

Currently when creating a OneDrive connection we can't get OneDrive to send the code back - admin approval needed.

Have you got more detailed information about the way the connector stores the credentials (encryption, etc..) for presenting to the Microsoft administration team and wave security concerns? The official documentation does not go in details further than the need to setup the encryption key.

Is the connector well using the REST API as documented here : https://learn.microsoft.com/en-us/onedrive/developer/rest-api/?view=odsp-graph-online ?

Our current understanding is that each professional user has to create his own connection, that will be saved with his encrypted credentials allowing the app to be refreshed by the service account when the data load happens on a schedule and with a service account.

Thank you.

[mpc · Accepted solution]

Hi, 

Credentials for this kind of connector are encrypted by a encryption key generated by you, following this process: 
Setting an encryption key | Qlik Connectors Help
ENCRYPTION_KEY_MISSING - you must manually set an encryption key before creating new connections. (q...

This key then can be based on a TLS certificate of your choice. 

Kind regards

[Yves_Jezequel]

Hi thank you for the feedback. Yes I thought so... Probably the answers to the security concern is more on the OneDrive REST API documentation that are referred in the connector documentation.

[Raju_6952]

Hi @Yves_Jezequel,

for web connection like one drive and google drive you need to setup secret key on the server which makes its working fine for you.

please check this article which helps on resolving your issue.

Setting an encryption key | Qlik Connectors HelpSetting an encryption key | Qlik Connectors Help

Regards,

Raju