SQL Server JSON API Connector - Read/Write JSON Web API or Local JSON files data in SQL Server

SQL Server JSON API Connector - Read/Write JSON Web API or Local JSON files data in SQL Server

JSON Driver / REST API Driver for ODBC / SQL Server
=========================================
ODBC JSON Driver / REST API Driver can be used to read / write data from Web API / Cloud Data sources or Local JSON files. Easily integrate virtually any Web API inside your Power BI / ETL / Reporting / Tools or Programming Languages. Write familiar SQL queries to read /write data. This driver supports latest API security standards (i.e. OAuth 2.0, JWT, X509), and optimized for large data files. Using JSON API Connector you will be able to connect, read and write data from within SQL Server

01:00 Open ZappySys Data Gateway
02:00 Configure JSON Driver
12:28 Load JSON API Data into the SQL Server

JSON Driver Features
==========================================
* Read /write data from Web API / REST API or local JSON files using familiar SQL Query language
* De-normalize nested JSON into a flat document just like a regular database table
* Integrate insight any ODBC Compliant Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, SSRS, Informatica, Excel, SSIS)
* Support for programming languages such as JAVA, C#, Python, PowerShell and more…
* Tight integration with Microsoft SQL Server (With support for Gateway Option – No need to install Driver on Server)
* Familiar SQL Query language support including WHERE, ORDER BY, GROUP BY constructs
* Support for custom math/ string / datetime / JSON functions in SQL query Language
* The unparalleled performance with large file support (See how we processed 3 million rows in 3 mins)
* POST data to API server, Upload File to server (Support MultiPart File Upload).
* Latest security standards such as OData, OAuth and JWT (RFC 7519) (Call services like Google API, Facebook …)
* Call API using Dynamic Token Authenticate or Basic authorization (i.e. UserID / Password)
* Reading from multiple files using wildcard pattern (e.g. Year??_data*.json)
* Support for Array Flattening (Child Array Items as Columns)
* HTTP Request with Custom Headers / Body / URL Parameters.
* REST API Pagination Support to consume multiple requests / loop (many options explained here and here)
* Support for 2D arrays and Complex Transformation (See this article and this for Google BigQuery)
* Option for Pivoting nested data (Convert Columns to Rows)
* Ability to read raw JSON / indent output from inner array
* HTTPS / SSL / TLS 1.2 Support for more secure communication
* Support for passing cookies
* Support for Proxy Server

Related Searches:
===========================================
SQL Server JSON API Connector
SQL Server JSON Connector
Make API call using JSON Driver in SQL Server
Read JSON file using ODBC JSON driver in SQL Server
How to read/write data from API in SQL Server