I tried out the Microsoft list connector and it worked well, but one piece of feedback.  It would be great to be able to have one connector and pull data from multiple Sharepoint sites (currently it is single select).  I have relevant data across several sites and don't want to create individual connectors for each. Even more important I don't want this to cause me to create multiple datasets in my destination (one per connector) with just a few tables each.  It is much better for my users to have consolidation for this data source.