CData TDV Adapter for JSON

JSON Adapter

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.

SQL Compliance

The SQL Compliance section shows the SQL syntax supported by the adapter and points out any limitations.