Included in ODBC PowerPack

Data Gateway: ODBC bridge for SQL Server, Java, Linux and Mac

Install once on any server. All client apps connect to it — no ODBC on every machine, credentials stay on the host.

A fast bridge from SQL Server, Java apps and Linux / Mac clients to ZappySys and other ODBC drivers. Connect with any SQL Server driver (ODBC, JDBC, OLEDB or ADO.NET) over the TDS protocol, with no driver install on the client.

Part of ODBC PowerPack

ZappySys Data Gateway: connect to JSON, XML, OData, REST API and SOAP data sources with TDS protocol compatible drivers
Driver UI, SQL query and live preview

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What the Data Gateway can do

Install once on any server. All client apps connect to it — no ODBC on every machine, credentials stay on the host.

A bridge for SQL Server

Query ZappySys drivers from T-SQL through a linked server or OPENQUERY, inside views, functions and stored procedures.

  • REST API, JSON, XML, CSV and Salesforce from T-SQL
  • No ETL step outside SQL Server
  • Works with SQL Server 2012 through 2025 (32/64 bit)

See the T-SQL example

Any SQL Server compatible client

The gateway speaks TDS, like SQL Server. Connect with SQL Server ODBC, OLEDB, ADO.NET or JDBC drivers.

  • Java apps through JDBC
  • Google Sheets
  • Any TDS compatible tool

See the screenshots

Windows, Linux and Mac clients

Apps on any operating system connect to the gateway without installing a driver on the client machine.

  • No ODBC driver on every laptop
  • Clients on Windows, Linux or macOS
  • One install on the gateway host

Read the FAQ

Several data sources

Create multiple data sources on the gateway and bind each to an existing ODBC DSN on the machine.

  • One data source per DSN
  • Mix ZappySys and other ODBC drivers
  • Manage them in one place

Open the help file

Run it where you want

Install the gateway on-premises, or on a cloud VM that is reachable from your clients. Many users can share one central gateway.

  • On-premises or cloud VM
  • One central host, many users
  • You choose the machine

Open the help file

Credentials stay on the gateway host

Client apps use a SQL Server compatible driver. API keys, OAuth tokens and DSNs stay on the gateway host instead of every machine.

  • Keys and tokens stay put
  • No local ZappySys install for analysts
  • Central place to update settings

Read the FAQ

Works with the tools you have

Any ODBC-compliant tool can use the DSN: Power BI, Tableau, Qlik, SSRS, Informatica, Excel and SSIS.

  • Create a DSN once, reuse it everywhere
  • 32-bit and 64-bit ODBC
  • Stored in the standard ODBC Data Source Administrator

Setup guide

See all features
  • Allows to create multiple data sources which can be bound to existing ODBC DSN on the machine
  • Access ZappySys drives from JAVA apps (via JDBC) or from Google Sheet
  • Gateway use TDS Protocol which is widely used by many SQL Server / Sybase compatible drivers
  • Apps from any platform (e.g. Windows, Linux, Mac) can connect to Gateway without actually installing driver on the client machine
  • Read other use cases for Data Gateway
Runs in your environment ·

SQL Server 2012–2025

through the Data Gateway · Read the FAQ

Ways to use it

Pick how you reach your data.

Configure the DSN once, then query it from any ODBC tool or from SQL Server.

Use drivers inside T-SQL.

Create a linked server that points at the gateway, then call OPENQUERY from SSMS, views, functions and stored procedures.

  • Linked server and OPENQUERY
  • REST API, JSON, XML, CSV, Salesforce
  • No driver on SQL Server
SQL Server linked server and OPENQUERY example using the ZappySys Data Gateway

Inside the UI

The driver UI, step by step.

Real screens from the ZappySys ODBC driver configuration.

How the Data Gateway fits

Client apps connect to one gateway service with a SQL Server compatible driver; the ZappySys drivers run on the gateway host.

T-SQL example

Call a ZappySys driver from T-SQL.

Add the Data Gateway as a linked server in SQL Server, then use OPENQUERY to run a driver query inside your own T-SQL, views, functions and stored procedures. The linked server name below is an example.

  1. Data source on the gateway

    A Data Gateway data source bound to an ODBC DSN, such as a ZappySys JSON Driver DSN.

    Data Gateway

    Data source : MyJsonSource
    Bound to    : ZappySys JSON Driver (ODBC DSN)
    SQL Server  : linked server [ZappyGateway] -> Data Gateway
  2. Run the T-SQL query

    T-SQLSELECT * FROM OPENQUERY([ZappyGateway], 'SELECT * FROM value WITH (SRC=''https://services.odata.org/V3/Northwind/Northwind.svc/Invoices?$format=json'')')

    The inner statement is a normal driver query. The outer OPENQUERY sends it through the gateway.

    No driver on SQL Server: the driver is installed only on the gateway machine.

  3. Rows returned to SQL Server

    Result shape
    Result
    One row per record returned by the driver query

    Insert the rows into a table, join them with local tables or return them from a stored procedure.

Illustrative setup. Step-by-step instructions are in the SQL Server tutorial.

Articles

Guides and tutorials for the Data Gateway

GuideRead / Write REST API data in Talend (JSON / XML / SOAP)In this post we will learn how to read / write REST API data in Talend Open Studio. We will create a simple Talend Job using ZappySys JSON Driver to read from REST…zappysys.com blogRead articleGuideInsert, Update and Delete JIRA Issue in SQL ServerIn our previous blog we saw how to read JIRA data in SQL Server. In this blog, we will learn how to Insert, Update and Delete Issue in JIRA using ZappySys JSON Driver.…zappysys.com blogRead articleGuidePush data into a Power BI dataset from SQL ServerIn this article, you will learn how to push data into a Power BI dataset from SQL Server. Power BI is a Microsoft reporting product that can get data from virtually any…zappysys.com blogRead articleGuideImport REST API in Tableau – Read JSON, SOAP XML, CSVTableau is one of the most popular Reporting / Visualization tool for BI / Data analytics. It comes with many out-of the box connectors to pull data from some popular…zappysys.com blogRead articleGuideImport REST API in Google Sheet AppScript – JSON / SOAP XML / CSVIn our previous few articles we saw various use cases of Data Gateway. Now let’s look at one more interesting use case of Data Gateway. We will look at how to Import…zappysys.com blogRead articleGuideHow to read REST API in Pentaho KettleIn this article, we will learn how to read REST API in Pentaho Kettle. Pentaho is a very popular tool in Business Intelligence to integrate data for OLAP services and…zappysys.com blogRead articleCollectionAll Data Gateway articlesMore tutorials and how-to articles on the ZappySys blog.zappysys.com blogBrowse all articles

Compatibility and requirements

Built for Windows, and for your own environment.

  • Windows 11, 10, 8 and 7, and Windows Server 2022, 2019, 2016, 2012 R2 and 2008
  • .NET Framework 4.x. The JDBC Bridge Driver also needs Java 8 or later
  • 32-bit and 64-bit ODBC drivers. SQL Server 2012 through 2025 through the Data Gateway
  • Self-hosted: drivers run in your Windows process, business data does not pass through ZappySys servers, and credentials stay in your DSN
  • Free trial of ODBC PowerPack: test with your own data before you buy

FAQ

Questions about the Data Gateway

Which clients can connect to the Data Gateway?

Any client with a SQL Server compatible driver: SQL Server ODBC, OLEDB, ADO.NET or JDBC drivers, or a linked server in SQL Server. The gateway uses the TDS protocol.

Do I need to install the ZappySys driver on the client?

No. The drivers run on the gateway host. Clients on Windows, Linux or macOS only need a SQL Server compatible driver.

Where can the Data Gateway run?

On-premises, or on a cloud VM that your clients can reach. One central gateway can serve many users.

Can Java apps and Google Sheets use it?

Yes. Java apps connect through JDBC, and Google Sheets can query the gateway as well.

Which SQL Server and Windows versions are supported?

Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014 and 2012 (32/64 bit) through the Data Gateway. See the system requirements.

Can I try it before buying?

Yes. Download ODBC PowerPack, set up a data source on the gateway and test your own data before you buy.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    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 KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install ODBC PowerPack and add a Data Gateway DSN.

Preview your data in the driver UI before you connect your tool.

  • One DSN, many toolsPower BI, Excel, SSIS, Python and SQL Server can all use it.
  • Free trialTest the driver with your own data before you buy.
  • Live supportHelp during your trial and after purchase.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 3