Learn how to Import data from REST API to SQL Server, Read JSON Files or XML Files inside SQL Server using T-SQL code. Learn more https://zappysys.com/products/odbc-powerpack/
ZappySys ODBC Driver supports many advanced settings such as API Pagination to call virtually any API.
About 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 favourite Reporting / ETL tools (i.e. Power BI, Tableau, Qlik, 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.
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)
Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS)
Comes with ZappySys Data Gateway Service which allows to use ZappySys Drivers without installing anything on their machine
- ODBC Driver for JSON Files / REST API
- ODBC Driver for XML Files / SOAP API
- Data Gateway Service
ZappySys Data Gateway Service (ZSDG)
ZappySys has developed a unique proxy service called ZappySys Data Gateway Service (ZSDG) it can run in cloud or you can install locally. Client application can connect to Data Gateway Service using any Microsoft SQL Server compatible driver (i.e. SQL Server ODBC, OLEDB, ADO.net or JDBC Driver or Linked Server in SQL Server). Data Gateway can be installed on central server where you can have many users who can connect to Data Gateway to use ZappySys Drivers without installing anything on their machine. Data Gateway Service understand TDS Protocol and Client App can be running on any machine or operating system (MacOS, Linux, Windows).
App Integration Scenarios (Reporting / ETL / BI / Analytics Tools)
ZappySys ODBC API Drivers built using ODBC standard which is widely adopted by industry since long time. Which mean majority of BI Tools / Database Engines / ETL Tools already comes will ODBC Driver support. Below is the small list which can take advantage of ZappySys ODBC drivers. If your app doesn't appear in the below list, which means we have not tested or documented use case but as long as your tool support ODBC Standard, our drivers should work fine.
Microsoft Power BI
Informatica PowerCenter (Windows Edition)
SSIS (SQL Server Integration Services)
SSRS (SQL Server Reporting Services)
T-SQL (SQL Server Query Language)
Programming Language Support
Most programming languages comes with out of the box support for ODBC. Which means you can use ZappySys ODBC drivers inside your favourite language. Here are few languages which already support ODBC.
JAVA (using JDBC-ODBC Bridge or using ZappySys Data Gateway via SQL Server JDBC)
T-SQL (Using Linked Server)
SQL Server REST API, Read from REST API in SQL Server, How to load JSON file in SQL Server, How to import JSON to SQL Server, Access JSON in SQL Server, Access REST API in SQL Server, JSON to SQL Server, XML to SQL Server, Import JSON API into SQL Server. Import JSON File into SQL Server. Import REST API into SQL Server.
Load JSON file in SQL Server 2008. Import JSON File in SQL Server 2012 / SQL Server 2014.