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.

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]