How to create a data provider for use with Excel
Excel (2010) has functionality to create pivot tables from an external data source like from Access, From Web and other data sources like SQL server and ODBC. Suppose I have created a new database system called X and I want to create the functionality that Excel can connect to this X using a data provider (not an Excel Add-in). What do I develop and where do I start? 
How to create a data provider for use with Excel
===

Excel (2010) has functionality to create pivot tables from an external data source like from Access, From Web and other data sources like SQL server and ODBC. Suppose I have created a new database system called X and I want to create the functionality that Excel can connect to this X using a data provider (not an Excel Add-in). What do I develop and where do I start? 