This Connector is based on the Sharepoint ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RSG/ado/
You might see this error if not connected appropriately - " Could not execute the specified command: unrecognized response when getting SharePoint online security cookies, please check your credentials."
Add "UseSSO=true" to the Starfish Sharepoint Connector configuration.
SSO configuration options:
Use SSO=true Auth Cookie=”” SSO Domain=”” - SSODomain may be required to be set if the domain configured on the SSO domain is different than the domain of the User.
Check SharePoint user configuration as well too:
User name needs to match the format of firstname.lastname@example.org. After logging in to http://yourdomain.sharepoint.com/TeamSite, the "keep me signed in" setting must be checked in order for the connection to be established