Calling REST API with OAuth 2.0 Authentication using ZappySys ODBC Driver (Part 2 of 4)

In this part you will learn how to authenticate REST API Requests using ZappySys ODBC Drivers. For more information check this link https://zappysys.com/products/odbc-powerpack/

This demo shows how use ZappySys API drivers to read data from REST API which uses OAuth 2.0 authentication. We will see how to read data from REST API and load into Excel or other ODBC Compliant Apps (e.g. Power BI, Informatica, SQL Server, Crystal Reports / Business Objects, SSRS, SSIS)

What is ODBC PowerPack?
==========================
ODBC PowerPack is a collection of high-performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favorite Data Engine / Reporting / ETL tools (i.e. SQL Server, Power BI, Tableau, Qlik, SSRS, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. Our drivers can be called from your favorite programming languages such as JAVA, C#, Python etc.


Main Features of ODBC PowerPack
================================
ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files.
Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API)
Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp… )
Support very large JSON / XML files
Support for Caching engine to reduce query time
Support for retry options (To handle intermittent failures)
Support for API pagination options (Many ways to paginate large API response)
Tight integration with SQL Server (Call REST API from T-SQL Code)
Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS)
Support for popular programming languages such as JAVA, C#, Python

Keywords:
========================
excel rest api authentication
rest api oauth 2.0
call rest api in power bi
call rest api in excel

• Category

  How-to & Style