ODBC PowerPack - Visual Studio Marketplace

30+ high-performance ODBC drivers — query REST APIs, JSON, XML, CSV, SOAP, and cloud storage using familiar SQL.

ZappySys ODBC PowerPack is a suite of ODBC 3.8 compliant drivers that turn any API or file source into a queryable database. Connect from SQL Server (Linked Server / OPENQUERY), Power BI, Tableau, Qlik, Excel, SSRS, MicroStrategy, Informatica, Talend, Pentaho, SSIS, and programming languages like C#, Java (JDBC Bridge), Python, PHP, and PowerShell.
30-day free trial with full functionality. Centralize access with ZappySys Data Gateway for SQL Server, JDBC, Linux, and Mac clients.

Get started in minutes

Download ODBC PowerPack (Free Trial) →

See all drivers → | Compare editions → | Online help →

Compatibility: Windows 11 / 10 / Server 2012–2025 • 32/64-bit • .NET Framework 4.x • JDBC Bridge (Java 8+) • Data Gateway for Linux / Mac / SQL Server

📦 What's Inside

One installer, 30+ drivers. Every driver uses standard SQL and installs as a Windows ODBC DSN — usable from any ODBC-compatible tool without extra coding.

🔗 REST API & SOAP / Web Services JSON Files / REST API Driver (Generic) XML Files / SOAP API Driver (Generic) CSV Files / REST API Driver (Generic) API Driver with 50+ Pre-Configured Connectors	🔌 Pre-Configured API Connectors Salesforce, SharePoint, Dynamics 365 HubSpot, Jira, Zendesk, Shopify Google Analytics, Google Ads, Facebook Office 365, Amazon MWS, and 50+ more
☁️ Amazon AWS (S3) Amazon S3 Driver for JSON Files Amazon S3 Driver for XML Files Amazon S3 Driver for CSV Files	☁️ Microsoft Azure (Blob) Azure Blob Driver for JSON Files Azure Blob Driver for XML Files Azure Blob Driver for CSV Files
📁 FTP / SFTP FTP / SFTP Driver for JSON Files FTP / SFTP Driver for XML Files FTP / SFTP Driver for CSV Files	📊 Files & Specialty Excel Driver (read/write .xlsx) Salesforce ODBC Driver JDBC Bridge Driver (call JDBC from ODBC) Data Gateway Service (TDS bridge)

🖥️ Works With Your Favorite Tools

BI & Reporting

Power BI • Tableau • Qlik • SSRS • Excel • MS Access • MicroStrategy • Google Sheets

ETL & Databases

SQL Server (T-SQL) • SSIS • Informatica • Talend • Pentaho • Oracle OBIEE

Programming

C# • Java (JDBC) • Python • PowerShell • PHP • VB.NET • Visual Studio

🔗 Seamless SQL Query Integration

Works with REST, OData, files, and databases

/* Query REST API / JSON directly using SQL */
SELECT Country AS Invoice_Country,
       SUM(UnitPrice * Quantity) AS Total
FROM value
WHERE Discount > 0
GROUP BY Country
HAVING SUM(UnitPrice * Quantity) > 1000
ORDER BY Total DESC
WITH (
    SRC='https://services.odata.org/V3/Northwind/Northwind.svc/Invoices?$format=json',
    DataConnectionType='HTTP',
    CredentialType='OAuth',
    ClientId='your-client-id',
    ClientSecret='your-client-secret',
    AccessToken='your-access-token',
    RefreshToken='your-refresh-token',
    PagingMode='ByUrlPath',
    Header='Accept: application/json'
)

✔ Query APIs like a database
✔ No ETL or custom scripts needed
✔ Works inside SQL Server, Power BI, Excel

⚡ Why Choose ODBC PowerPack

SQL Over Any API Familiar SELECT, WHERE, GROUP BY, JOIN, and window functions (ROW_NUMBER, RANK, LEAD/LAG) over REST/JSON/XML/CSV sources — no custom API code.	Built-in Auth & Pagination OAuth 1.0/2.0, Basic, NTLM, Kerberos, JWT, HMAC signatures, dynamic token flows, plus many pagination modes and automatic retry on failure.
Works Everywhere ODBC Works Power BI, Tableau, Qlik, Excel, SSRS, MicroStrategy, SSIS, Informatica, Talend, Pentaho, plus C#, Java, Python, PHP, PowerShell, and T-SQL.	Centralized Data Gateway Install drivers once on a gateway server and let SQL Server (Linked Server / OPENQUERY), JDBC clients, and Linux / Mac apps connect via TDS — no per-client install.

🔐 Authentication Standards Supported

OAuth 1.0 / OAuth 2.0 (Google, Facebook, Salesforce, HubSpot, etc.)
Basic — UserID / Password
NTLM — UserID / Password / Domain
Kerberos — UserID / Password / Domain

Static Token / API Key
Dynamic Token — 2-step login-to-token flows
JWT (RFC 7519)
HMAC Signature — request hashing with key/password
SOAP WSS — UserID/Password in SOAP body

📊 Editions at a Glance

Edition	Drivers	Highlights
Standard	Core	Generic JSON, XML, CSV drivers for files and REST / SOAP APIs.
Professional	Extended	Standard + Salesforce, Excel, FTP/SFTP, Amazon S3, Azure Blob drivers.
Enterprise	All 30+	Professional + API Driver with 50+ Pre-Configured Connectors, JDBC Bridge, and Data Gateway.

View full edition comparison →

💡 Common Use Cases

BI & reporting over REST APIs — Pull JSON/XML/OData/SOAP data into Power BI, Tableau, Qlik, Excel, or SSRS using a single DSN.
SQL Server Linked Servers — Call REST APIs directly from T-SQL stored procedures, views, and functions via OPENQUERY and Data Gateway.
ETL pipelines — Use the same DSN in SSIS, Informatica PowerCenter, Talend, and Pentaho without component-specific coding.
Cross-platform access — Connect Java / Linux / Mac apps to any ZappySys driver through the Data Gateway Service over TDS.
Large file and URL joins — Stream very large compressed JSON/XML files and perform multi-level URL JOIN from parent to child endpoints.
Custom app development — Use native ODBC from C#, Java (JDBC Bridge), Python (pyodbc), PHP, or PowerShell with standard connection strings.

💬 What Customers Say

"Zappysys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework." — Ben Kingery, Oxspring Paul	"The responsiveness of your support staff during the evaluation period really has been excellent — they always answer quickly and provide exactly the detailed technical input required." — Jes Kirkup, KTC
"They have proven themselves to be resourceful and creative in offering multiple solutions to overcome any and all challenges we have faced in our day-to-day operations." — Senthil Sekar, Publicis Groupe	"The super handy ZappySys connectors and great documentation allow us to do this without having to write a lot of code. The system is stable and reliable." — Joel Conner, Synchronous Customers

Trusted by Thousands of Teams Worldwide

One Driver Model, Many Tools: The same DSN works across BI, ETL, SQL Server, and custom code.
Expert Technical Support: Engineers help with connection strings, query tuning, auth flows, and pagination.
30-Day Money Back Guarantee: Evaluate risk-free with full refund if not satisfied.

Read reviews on Capterra →

See Trustpilot reviews →

Ready to Query Any API Like a Database?

Download the full ODBC PowerPack — 30+ drivers for REST APIs, files, and cloud storage. 30-day free trial.

Download ODBC PowerPack (Free Trial)

30-day trial • Windows 11 / 10 / Server 2012–2025 • Data Gateway for Linux / Mac / SQL Server