SQL Server API Connector - Read/Write REST API Data in SQL Server using predefined Connector File

SQL Server API Connector - Read/Write REST API Data in SQL Server using predefined Connector File in the API Driver

API Driver / SQL Server
=========================================

01:00 Open ZappySys Data Gateway
02:00 Configure API Driver
06:14 Load API Data into the SQL Server

API Driver Features
==========================================
* In few clicks read /write data from popular online services using familiar SQL Query language (e.g. Google BigQuery, Sheets, SharePoint, JIRA, Zendesk and more…)
* No need to learn Complex API Configurations / Pagination / Authentication details about REST API
* Intuitive UI for easy step by step configuration without having API knowledge
* Easily modify existing connector file based on your need.
* Allows to create and use your own reusable connector file for custom API (or you can consider using our generic JSON Driver or XML Driver)
* Integrate insight many ODBC Compliant Apps for Reporting / ETL / Database (e.g. Power BI, Informatica, MS Access, Excel, SSRS and more…)
* Support for programming languages (e.g. 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 /XML functions in SQL query Language
* The unparalleled performance with large file support
* Latest security standards such as OData, OAuth and JWT (RFC 7519) (Call services like Google API, Facebook …)
* REST API Pagination Support to consume multiple requests / loop
* HTTPS / SSL / TLS 1.2 Support for more secure communication
* Support for Proxy Server

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

[mattbeller]

Excellent video and product. Can you point me in the right direction of what the next step would be once I have this data in a LINKED SERVER. How do I get the data into a table of an actual SQL DB. I would like to be able to get the incoming data feeding and updating into a regular SQL DB. Is there another video for that scenerio?