This week we will talk about how can Jedox connect to OneDrive. OneDrive is a cloud storage service developed by Microsoft, allowing users to store files and photos securely online, accessible from any device with an internet connection. It integrates with Microsoft Office applications and offers collaboration features for sharing and editing documents in real time.
We will showcase two ways of doing it, with a username and password and with a token connection.
Connecting with Username and Password
This method is less secure but allows users to simply access the files. Upload the file you would like to access from Jedox and specify the path:
It is important to know your Azure application ID. you can request it from your IT department or in case you have access to your application Azure find it here:
Now, if you test your connection to file it should be successful.
Connecting via Token Connection
As for the first case, you will need to have existing credentials to access the registered application in Azure. There we will need information like client ID, client secret and to allow certain API permission. Other things from oAuth connection can be copied from here:
- Token endpoint: https://login.windows.net/common/oauth2/token
- Access token scope: openid
- Request parameter name: resource
- Request parameter value: https://graph.microsoft.com
and we will use oauth2PasswordCredential authentication method. More about this you can find here.
Client secret can be found here:
API permission needs to be set here:
- User.Read
- Files.ReadWrite.All
and finally, oAuthToken connection should look something like this:
Conclusion
In a data-driven world where agility and insights are paramount, the integration between Jedox and OneDrive represents a significant step forward in enhancing data connectivity and accessibility.