Included in ODBC PowerPack

ODBC JDBC Bridge Driver

Bridge JDBC data sources into ODBC-compatible tools and applications.

Use any JDBC driver from apps that only speak ODBC, such as Excel, Power BI, C# and Informatica. Add the driver .jar, connect with a JDBC URL, and run SELECT, INSERT, UPDATE and DELETE against the source.

Included in the Enterprise edition and above

JDBC Bridge Driver: Create the DSN
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 JDBC Bridge Driver can do

Bridge JDBC data sources into ODBC-compatible tools and applications.

JDBC to ODBC

Load any JDBC driver (a .jar), connect with a JDBC URL and use the database from ODBC tools.

  • Any JDBC-compliant database
  • JDBC URL and driver class
  • Connection properties

See the SQL example

Read and write

SELECT, INSERT, UPDATE and DELETE are passed to the JDBC data source.

  • DML statements
  • Virtual tables
  • Stored procedures where the source supports them

See the SQL example

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

Use it from code

Connect from Java, C#, Python, PowerShell and more with an ODBC connection string that names the DSN.

  • Standard ODBC connection strings
  • Parameterized queries
  • Same SQL as in the UI

Python example

SQL Server via Data Gateway

Query the driver from SQL Server (linked server / OPENQUERY) without installing it on the SQL Server machine, through the Data Gateway.

  • No driver install on the server
  • Works with SQL Server 2012 through 2025 (32/64 bit)
  • Same DSN, same SQL

About Data Gateway

See all features
  • In few clicks read /write data from any JDBC Driver in non JAVA apps (i.e. Excel, Power BI, C#).
  • Support for Query Preview UI
  • Support for Data Gateway to integrate JDBC driver in SQL Server Code (T-SQL)
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.

Add a JDBC driver and connect.

Choose the driver jar, enter the JDBC URL and connection properties.

  • Any JDBC database
  • JDBC URL
  • Test connection
JDBC Bridge Driver: Configure the driver

Inside the UI

The driver UI, step by step.

Real screens from the ZappySys ODBC driver configuration.

Create the DSN

Add a user or system DSN and pick the JDBC Bridge Driver.

SQL example

Use any JDBC driver from ODBC.

The bridge loads a JDBC driver (a .jar), connects with a JDBC URL and exposes the database to ODBC tools. DML statements are passed through.

  1. JDBC connection

    A JDBC URL and the driver jar, for example for PostgreSQL.

    Connection settings

    Driver class : org.postgresql.Driver
    URL          : jdbc:postgresql://my-host-name:5432/my-db-name
  2. Run the SQL query

    SQL QuerySELECT * FROM MyTable

    SELECT, INSERT, UPDATE and DELETE are passed to the JDBC data source.

    Data Gateway lets SQL Server use the driver without installing it on the server.

  3. Rows returned to your tool

    Result shape
    Result
    Rows of MyTable, as returned by the JDBC source

    Any ODBC-compliant tool can read the result.

Statements taken from the driver help.

SQL query examples

Copy a query, change the source, run it.

7 of the 7 examples from the JDBC Bridge Driver help. Open one to see the SQL.

Read files, API responses and objects as rows.

DML – SELECT Example

This example shows how to write select query.

SELECT * FROM MyTable

Open this example in the help

Output-On Flag

This example shows how to invoke statements which has multiple statements and produces result. If you are calling multiple statements then for some JDBC drivers you have to set this else it will not produce output or might throw error.

#Output-On CREATE TABLE MyTable(Id int); INSERT INTO MyTable(Id) Values(1); SELECT * From MyTable;

Open this example in the help

Output-Off Flag

.

#Output-Off CREATE TABLE MyTable(Id int)

Open this example in the help

Using Java settings file (e.g. set HTTP Proxy, use java runtime path, enable log)

This example shows how to create java settings file in ZappySys to use additional options for Java runtime. This file affects all JDBC connection you invoke using ZappySys driver.

This example shows how to create java settings file in ZappySys to use additional options for Java runtime. This file affects all JDBC connection you invoke using ZappySys driver.

For example use this file if you have multiple java runtimes and you like to use specific java version.
--or-- you like to enable log file for additional logging
--or-- you like to pass runtime arguments to java.exe using java.arg options (e.g. enable HTTP Proxy or change memory settings).

Check this link to see all possible options you can pass in java.args setting below
https://docs.oracle.com/en/java/javase/17/docs/specs/man/java.html

To Use ZappySys Java Settings file use below steps.

1. Create a custom file called "JdbcBridge.properties" in the following location (assuming you installed at default location) C:\Program Files (x86)\ZappySys\ZappySys ODBC PowerPack\
2. You can paste following example lines to start with (use # to comment and remove it to uncomment option you need). Basically you can use app.logfile, java.path and java.args

#------------Start of file---------------------

######################################################
##Sample settings file for ZappySys JDBC Bridge
######################################################
####Enable Additional log from java side like below
#app.logfile=c:/temp/JdbcBridge_log.txt

####Set custom Java runtime path rather than using default path like below (uncomment / change as per your need)
#java.path=c:\JAVA\JDK8\bin\
#java.path=c:\Program Files\Amazon Corretto\jdk1.8.0_382\bin

####Enable HTTP/HTTPS Proxy like below (e.g. Use Fiddler Proxy or other Web Proxy)
#java.args= -Djava.net.useSystemProxies=true
#--OR--
#java.args= -Dhttps.proxyHost=127.0.0.1 -Dhttps.proxyPort=8888 -Dhttp.proxyHost=127.0.0.1 -Dhttp.proxyPort=8888
#--OR--
#Tools like Fiddler (web proxy tool) will need some extra settings to trust self-signed certificate
#https://azureossd.github.io/2017/04/26/capture-java-vm-traffic-using-fiddler/
#java.args= -Dhttps.proxyHost=127.0.0.1 -Dhttps.proxyPort=8888 -Dhttp.proxyHost=127.0.0.1 -Dhttp.proxyPort=8888 -Djavax.net.ssl.trustStore="c:\Program Files\Amazon Corretto\jdk1.8.0_382\bin\FiddlerKeystore" -Djavax.net.ssl.trustStorePassword=test123

#------------End of file---------------------

Open this example in the help

See all 7 SQL examples in the help

Articles

Guides and tutorials for the JDBC Bridge Driver

GuideRead data from QuickBooks Online into SQL Server via JSON DriverQuickBooks Online is a well-known Cloud-based Accounting Software. In this post, you will learn how to implement QuickBooks Online API Integration with SQL Server or…zappysys.com blogRead articleGuideRead / 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 articleGuideRead JIRA data in SSRS Reports (SQL Server Reporting Services)In our previous blog we saw how to read rest api in SSRS reports. We recommend you go through that article first. In this post we will look at specific example on How…zappysys.com blogRead articleGuideHow to Import JIRA data in Power BI using JSON DriverIn our previous blog we saw how to import rest api in Power BI. We recommend you go through that article first. In this article, we will learn how to Import JIRA data…zappysys.com blogRead articleGuideGet Office 365 data in Power BI using Microsoft Graph API and ODBCIn this article, we will get Office 365 data in Power BI using Microsoft Graph API and ODBC drivers. Specifically, we will get Excel file data in OneDrive, events from…zappysys.com blogRead articleCollectionAll JDBC Bridge Driver 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 JDBC Bridge Driver

Which tools and languages can use this driver?

Any ODBC-compliant tool, such as Power BI, Tableau, Qlik, SSRS, Informatica, Excel and SSIS. You can also connect from Java, C#, Python, PowerShell and other languages with an ODBC connection string.

Do I need to install the driver on SQL Server?

No. With the Data Gateway option the driver runs on the gateway machine and SQL Server connects to it through a linked server.

Which edition includes the JDBC Bridge Driver?

The JDBC Bridge Driver is included in the Enterprise edition of ODBC PowerPack. See the edition comparison for the full list.

Which databases can I reach?

Any data source that has a JDBC driver (for example PostgreSQL with a jdbc:postgresql:// URL).

Do I need Java installed?

Yes. Install a Java runtime (JRE or JDK, version 8 or higher). The help recommends JRE 8, and the driver needs the .jar file of your JDBC driver.

How do I troubleshoot a JDBC connection?

Turn on logging for the ODBC layer and for Java in the DSN, then read the log files. The help also explains how to read a Java crash error file.

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, create a DSN 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 JDBC Bridge Driver 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 / 5