Cameo and SharePoint?

Sharepoint is becoming increasingly in use at my work and I've never found a good way to get Cameo and SharePoint to play well together. If anyone knows of documentation or general guides, let me know!

Specific example (Cameo 2024x R1). I have a spreadsheet in a SharePoint 365 Document Library. I have a Generic table in my model. I'd like to sync the model and spreadsheet.

Problem 1: I cannot for the life of me figure out how to directly navigate to SharePoint and link the model to the file where it lives.

Problem 2: Work-around 1. I synced the SharePoint to my computer, so now I can find it via a path on my C: drive. I can select the file from the Generic Table in Cameo. But Cameo does not read the file and allow me to select the right Sheet, therefore it does not let me associate Excel table columns to Generic table columns.

So that leaves me basically stuck. I've not tried anything with DataHub since I'm less familiar with it.

Anyone figure this out?

Jeff Janos, CSEP, OCSMP