The major authentication schemes are supported, including HTTP Basic, Digest, NTLM, OAuth, and FTP. See the Getting Started chapter in the data provider documentation to authenticate to your data source: The data provider models JSON APIs as bidirectional database tables and JSON files as read-only views (local files, files stored on popular cloud services, and FTP servers). You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.
This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name). Follow the steps below to use Microsoft Query to import JSON services into a spreadsheet and provide values to a parameterized query from cells in a spreadsheet. The CData ODBC driver for JSON uses the standard ODBC interface to link JSON services with applications like Microsoft Access and Excel.