cancel
Showing results for 
Search instead for 
Did you mean: 

Reading content from an excel file stored in Onedrive

Telesur
7 - Data Storage
7 - Data Storage

Hello. Using the jdbc connector I've tried to connect Sisense to Onedrive. Meaning I added Onedrive as a datasource in Sisense. But this results in only reading the meta data(column names, file names) of how Onedrive stores its files. I am interested in connecting onedrive in a way to Sisense, so that I can choose an Excel file for example and read the contents of that file in. Does anyone know how I can do this?

3 REPLIES 3

acidic_ph
8 - Cloud Apps
8 - Cloud Apps

That is of interest of mine as well - Currently, I am manually updating the files which is not ideal!

HamzaJ
12 - Data Integration
12 - Data Integration

I am not familiar with Onedrive, however might this not be what you are looking for:

CData JDBC Driver for Microsoft Excel Online: https://cdn.cdata.com/help/FXJ/jdbc/

Telesur
7 - Data Storage
7 - Data Storage

Yess, I've tried this but this involves in me uploading the excel file to Sisense. Which isn't really what I'm looking for. But thanks.