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