Learn how to read data from REST API, JSON Files or XML Files inside SSRS (Microsoft SQL Server Reporting Services). ZappySys ODBC Driver supports many advanced settings such as API Pagination to call virtually any API. For more information visit https://zappysys.com/products/odbc-powerpack/
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 favorite 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)
SSRS REST API, Read from REST API in SSRS, How to load JSON file in SSRS, How to import JSON to SSRS, Access JSON in SSRS, Access REST API in SSRS, JSON to SSRS, XML to SSRS, Import JSON API into SSRS. Import JSON File into SSRS. Import REST API into SSRS.