Standard (on premise) 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};URL=http://mySharepointServer;
User=mySharepointUser;Password=mySharepointPassword;