Hey John, did you get around to writing that blog?  ;)

We are working with a client that has an extensive powerpivot dashboard system that pulls data predominantly from a LOB on prem SQL database (syspro).  The goal would be that we can connect to the same SQL database (through means that you describe in place of the current odbc connections in the power pivot data model) and refresh on schedule so outside sales team can be viewing dashboards in sharepoint with daily current data.  Looking forward to your response!

 

Thanks! Matt@scouttg.com

www.000webhost.com