Sharepoint Online using CData ODBC Driver for SharePoint 2015
Connection string
This CData ODBC Driver for SharePoint 2015 connection string can be used for connections to SharePoint.
Driver={CData ODBC Driver for SharePoint 2015};
SharePointEdition=SharePoint Online;URL=http://mySharepointOnlineUrl.com;
User=mySharepointUser;Password=mySharepointPassword;