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?
BI360 Cloud Data Integration
Re: BI360 Cloud Data Integration
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.