I have a list on SharePoint 2010 which has a number of columns with some basic data types (Text, Yes/No, Number). I m using a third party BI tool which consumes SharePoint list data using ODBC interface. Currently I have been using plain text file, Excel or Access to feed SharePoint list data to the BI tool as they have the facility to use the list as a datasource. I am wondering if there is a more generic way to use the list as a datasource for any ODBC consuming application. Any thoughts?

This is a SharePoint 2010 question and should be posted in the appropriate forum. Ill have a go at answering this when I see it in the right place.Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

Thanks Steven. I have re-posted my question to the link below. Looks ok now? http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/b9b32292-b4f6-4bb2-ae54-eac93990577e/#b9b32292-b4f6-4bb2-ae54-eac93990577e Thanks.

Hi Please Check this link http://office.microsoft.com/en-us/sharepoint-designer-help/add-a-database-as-a-data-source-HA010355745.aspx