CData TDV Adapter for JSON
JSON Version Support
The adapter models local and remote JSON data sources as bidirectional tables. These can be local JSON files or remote JSON streams: RESTful APIs or file stores hosted on FTP servers or popular cloud storage providers. The adapter abstracts processing JSON data and connecting to the remote data: HTTP/FTP, SSL/TLS, and authentication: The major authentication schemes are supported, including HTTP Basic, Digest, FTP, NTLM, and OAuth.
The SQL Compliance
section shows the SQL syntax supported by the adapter and points out any limitations.