ZappySys JDBC-ODBC

To get data into Windows tools like Power BI and Excel we need and additional JDBC to ODBC bridge tools like ZappySys.

Download ZappySys

ODBC PowerPack - Drivers for REST API, JSON, XML, OData | ZappySys

From Windows search for ‘ODBC’

Click ODBC Data Sources (64-bit)

Open

Click Add

Open

Select ZappySys JDBC Bridge Driver

Click Finish

Enter the necessary fields

Data source name ← Any name

Connection string ← jdbc:data-basics:rest:https://api.data-basics.net/apihub/apis;logFile=/path/log.txt;

Driver class ← com.databasics.jdbc.Driver

JDBC driver path ← Browse to jdbc jar

User name ← username

User password ← password

Click Test Connection

Enter a test query and click Preview Data

If all looks good, click OK