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

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

JSON Driver / REST API Driver for ODBC / SSRS
=========================================
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 SSRS / 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 SSRS

01:00 Open ODBC Data Source (64/32-bit)
02:00 Configure JSON Driver
12:28 Load JSON API Data into the SSRS

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:
===========================================
SSRS JSON API Connector
SSRS JSON Connector
Make API call using JSON Driver in SSRS
Read JSON file using ODBC JSON driver in SSRS
How to read/write data from API in SSRS