Use the CData ODBC Driver for Sage 200 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sage 200 to connect to Sage 200 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage 200 in Excel.