Learn how to Read data from REST API, JSON Files or XML Files inside Power BI. 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.
==================================
Main Features
==================================
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
==================================
What's included
==================================
- 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.
Tableau
Microsoft Power BI
Informatica PowerCenter (Windows Edition)
QlikView
MS Excel
SSIS (SQL Server Integration Services)
SSRS (SQL Server Reporting Services)
T-SQL (SQL Server Query Language)
Visual Studio
Oracle OBIEE
==================================
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.
C#
C++
JAVA (using JDBC-ODBC Bridge or using ZappySys Data Gateway via SQL Server JDBC)
Python
PHP
PowerShell
T-SQL (Using Linked Server)
==================================
Keywords:
==================================
Power BI REST API, Read from REST API in Power BI, How to load JSON file in Power BI, How to import JSON to Power BI, JSON to XLSX, JSON to PowerBI, XML to Power BI, XML to XLSX. Import JSON API into PowerBI. Import JSON File into Power BI. Import REST API into PowerBI.