BI360 Cloud Data Integration

Most of the discussion action on Solver Operational Data Store (SODS) happens here. Feel free to browse, start, or participate in a discussion.
Post Reply
User avatar
rodman
Posts: 3
Joined: Tue Feb 27, 2018 11:20 am

BI360 Cloud Data Integration

Post by rodman » Thu Mar 01, 2018 10:49 am

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
Posts: 1169
Joined: Wed Mar 17, 2010 2:49 pm

Re: BI360 Cloud Data Integration

Post by jhummer » Wed Mar 07, 2018 7:22 pm

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.

Post Reply