BI360 Cloud Data Integration

[rodman]

I couldn't find a separate forum for BI360 Cloud so I'm posting here. Hopefully this is the right place.

When I go to Data -> Integrations within Data Warehouse, I see this:
https://i.imgur.com/18snNAJ.png

What I really want to do is use Spreadsheets for my data sources. Ideally I would just have everyone save their spreadsheets to a common OneDrive or SharePoint folder, then BI360 would pick them up from there.

I don't see a connector in BI360 Cloud for spreadsheets. I could use CSV, but it looks like you have to upload the CSV file through the web portal. It can't read whatever is currently sitting in a OneDrive or SharePoint folder. Or maybe I am missing something?

I could probably use SSIS for this, but I'm not sure if SSIS works with BI360 Cloud. Can SSIS pipe data into the BI360 Cloud Data Warehouse?

[jhummer]

Currently you can only use csv files not Excel sheets. In the future a Gateway product will serve that function. You can email support@solverglobal.com for more information.