Using CData ODBC drivers from SharePoint Excel Services
This article demonstrates how to use the CData ODBC drivers to connect to an external data source from Excel spreadsheets in SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards in their Excel spreadsheets using data from sources like Salesforce, QuickBooks, Dynamics CRM and many more.