Is it possible to specify SharePoint lists as a data source? If there is no direct method, is there a way to use SOAP calls to extract data since SharePoint web service calls can be made using SOAP calls?
Yes. However due to the need for authentication, and several nasty quirks of the SharePoint / IIS server, it won't work until tonight's build, 2.7 b254.