ODBC JDBC Bridge Driver

ODBC JDBC Bridge Driver – Use JDBC in Non-JAVA apps

JDBC Bridge driver can be used to consume data from  any JDBC Driver in non JAVA apps (i.e. Excel, Power BI, C#). Many apps written in C++ or .net (e.g. Excel, Power BI, Informatica) which don’t have direct support for using JAVA based JDBC driver technology. If your data source offers only JDBC driver but you like to consume in non-JAVA apps with ODBC connectivity option then you can use this driver. You can Read/write data using familiar SQL language in your favorite apps / programming languages.

Feature Summary

  • 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)

See also
ODBC JSON File / REST API Driver JSON File / REST API Driver
ODBC XML File / SOAP API Driver XML File / SOAP API Driver
ODBC CSV File / REST API Driver CSV File / REST API Driver
ODBC Data Gateway Service Data Gateway
Download Help File Buy
View All Drivers

Featured Articles

Integration Scenarios (Reporting / ETL / BI / Programming)

ZappySys ODBC Drivers built using ODBC standard which is widely adopted by industry for a long time. Which mean the majority of BI Tools / Database Engines / ETL Tools already there will support native / 3rd party ODBC Drivers. Below is the small list of most popular tools / programming languages our Drivers support. If your tool / programming language doesn’t appear in the below list, which means we have not documented use case but as long as your tool supports ODBC Standard, our drivers should work fine.

ZappySys ODBC Drivers for REST API, JSON, XML - Integrate with Power BI, Tableau, QlikView, QlikSense, Informatica PowerCenter, Excel, SQL Server, SSIS, SSAS, SSRS, Visual Studio / WinForm / WCF, Python, C#, VB.net, PHP. PowerShell

ZappySys Drivers for REST API, JSON, XML – Integrate with Power BI, Tableau, QlikView, QlikSense, Informatica PowerCenter, Talend, SQL Server, SSIS, SSAS, SSRS, Visual Studio / WinForm / WCF, Python, C#, JAVA, VB.net, PHP. PowerShell

Choose your App / Scenario for which you like to integrate JDBC-ODBC Bridge

ODBC Integration Screenshots in various tools

  • Tableau Integration - ODBC Driver connection for REST API / XML / JSON / SOAP / OData
    Tableau Integration - ODBC Driver connection for REST API / XML / JSON / SOAP / OData

SQL Query Examples – JDBC Bridge Driver


/*--------- DML - SELECT Example ---------*/ 
SELECT
  *
FROM
  MyTable


/*--------- DML - UPDATE Example ---------*/
UPDATE
  account
SET
  name = 'New Company Name',
  BillingState = 'GA'
WHERE
  id IN ('0014N00001hTNEEQA4')


/*--------- DML - INSERT Example ---------*/
INSERT INTO
  Account(Name, BillingCity, PK__c)
VALUES
  ('mycompany name', 'New York', 'K100')


/*--------- DML - DELETE Example ---------*/
DELETE FROM
  account
WHERE
  id IN ('0014N00001hTNEEQA4')

Configure JDBC Bridge Driver

Lets look at how easy it is to configure ODBC data source to consume data from java based jdbc driver.

Install JRE (many times its already installed on OS)

Before we started, Install JRE if not installed otherwise skip this step

Open ODBC Data sources – Search in start menu or find in control panel 

Create a new ODBC DSN

ZappySys ODBC Driver - Open UI

Choose JDBC Bridge Driver Type 

ZappySys ODBC Driver - Create JDBC Bridge Driver

Enter Full Path for *.jar file (i.e. JDBC driver file)  – Example of PostgreSql JDBC File 

Example Connection String: jdbc:postgresql://my-host-name:5432/my-db-name

ODBC JDBC Bridge Driver - Create Connection

ZappySys JDBC Bridge ODBC Driver - Select Table and Preview Data

 

Consume Data in your ODBC Compliant App

Here is an example of loading API data in ODBC Compliant app like Excel. Similar options are available in Informatica, Power BI etc.

ZappySys ODBC Driver : Load Data Into MS-Excel - Select ODBC Source

ZappySys ODBC Driver - Create Credentials

 

ZappySys ODBC Driver : Load Data Into MS-Excel - Success

 

Integration Scenarios (Reporting / ETL / BI / Programming)

ZappySys ODBC Drivers built using ODBC standard which is widely adopted by industry for a long time. Which mean the majority of BI Tools / Database Engines / ETL Tools already there will support native / 3rd party ODBC Drivers. Below is the small list of most popular tools / programming languages our Drivers support. If your tool / programming language doesn’t appear in the below list, which means we have not documented use case but as long as your tool supports ODBC Standard, our drivers should work fine.

ZappySys ODBC Drivers for REST API, JSON, XML - Integrate with Power BI, Tableau, QlikView, QlikSense, Informatica PowerCenter, Excel, SQL Server, SSIS, SSAS, SSRS, Visual Studio / WinForm / WCF, Python, C#, VB.net, PHP. PowerShell

ZappySys Drivers for REST API, JSON, XML – Integrate with Power BI, Tableau, QlikView, QlikSense, Informatica PowerCenter, Talend, SQL Server, SSIS, SSAS, SSRS, Visual Studio / WinForm / WCF, Python, C#, JAVA, VB.net, PHP. PowerShell

BI / Reporting Tools
Integration

ETL Tools
Integration

Programming Languages
Integration

ODBC Integration Screenshots in various tools

  • Tableau Integration - ODBC Driver connection for REST API / XML / JSON / SOAP / OData
    Tableau Integration - ODBC Driver connection for REST API / XML / JSON / SOAP / OData

Articles


Click here to see all articles for [JSON File / REST API Driver] category


Read data from QuickBooks Online into SQL Server via ODBC Driver

Read data from QuickBooks Online into SQL Server via JSON Driver

Introduction QuickBooks 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 any other RDBMS (e.g. Oracle, MySQL, Postgresql) using ODBC in few clicks. We will use ODBC JSON / REST API Driver to read data from QuickBooks Online and Load into SQL Server / other targets (Using OAuth […]

 


Read / Write REST API data in Talend (JSON / XML / SOAP)

Read / Write REST API data in Talend (JSON / XML / SOAP)

Introduction 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 API / JSON Files and load into Target (e.g. File / DB). Techniques listed in this article can be also used to read […]

 


Insert, Update and Delete JIRA Issue in SQL Server

Insert, Update and Delete JIRA Issue in SQL Server

Introduction In 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. We will also read data from SQL Server data table in stored-procedure and insert JIRA issues in bulk, along with few other […]

 


Read JIRA data in SSRS Reports (SQL Server Reporting Services)

Read JIRA data in SSRS Reports (SQL Server Reporting Services)

Introduction 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 to read JIRA data in SSRS Reports (SQL Server Reporting Services), along with few other topics such as how to generate an […]

 


How to Import JIRA data in Power BI

How to Import JIRA data in Power BI using JSON Driver 

Introduction In 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 in Power BI. For that, we will create a successful HTML Connection then request for reading JIRA data and loading into Power […]

 


Get Office 365 data in Power BI using Microsoft Graph API and ODBC

Get Office 365 data in Power BI using Microsoft Graph API and ODBC

Introduction In 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 a Calendar and finally, a list in a note in OneNote and then load that data into a Power BI report. We will achieve […]

 


Push data into a Power BI dataset from SQL Server

Push data into a Power BI dataset from SQL Server using JSON Driver

Introduction In 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 source and display it nicely in a report or a dashboard. Among its dataset types, it has a streaming dataset into which […]

 


Load JIRA data into SQL Server with ODBC – Call REST API

Load JIRA data into SQL Server with REST API Driver

Introduction In this blog, we will learn How to Load JIRA data in ODBC and load JIRA data into SQL Server Table, along with few other topics such as how to generate an API Token using Atlassian Account for JIRA REST API Call, how to read all Issues data from JIRA with ODBC. We will go through […]

 


Import REST API in Tableau – Read JSON, SOAP XML, CSV

Import REST API in Tableau – Read JSON, SOAP XML, CSV

Introduction Tableau 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 data sources but still it seriously lakes capability to consume data from millions of other REST / SOAP data sources out there for which […]

 


How to call REST API in MicroStrategy (JSON / XML SOAP)

How to call REST API in MicroStrategy using JSON Driver / XML Driver (SOAP)

 Introduction In this new article, we will show how to call REST API in MicroStrategy. MicroStrategy is a Business Intelligence company that provides powerful software to create nice charts, reports to take decisions. It started in 1993 and now it is one of the most popular Business Intelligence tools in the world because it is simple, intuitive and friendly. […]