DATABASICS JDBC Driver

Owned by DATABASICS, Inc.
Last updated: Apr 18, 2023 by Anthony Vallelonga
1 min read

With DATABASICS JDBC Driver you can connect to live DATABASICS data from reporting tools, databases, and custom applications through standards-based JDBC drivers.

Some use-cases:

  • Ability to integrate with PowerBi to retrieve live Time and Expense data.

  • Ability to look up available cash advances by using other reporting tools.

  • Ability to check who is on PTO during a specific period of time.

  • Ability to run missing timesheets from other reporting tools.

Prerequisites:

  • There is an additional cost to access the JDBC Drivers, contact your account manager for more details.

  • JDBC is only supported with DATABASICS Version 8.1 and higher.

  • Java SE Runtime Environment supported versions 8.1 and higher

  • To access Timesheet and Expense Report Transactions you would need to set up a View and publish it to the API click here for more details

  • Data Management tools that support JDBC:

  • PowerBi requires JDBC-ODBC bridge recommended drivers from the following vendors:

Setup:

DATABASICS will provide a link to download a zip file named DATABASICS JDBC.zip once you download the file unzip it and place the DATABASICS JDBC folder on your local server.

Driver Class

com.databasics.jdbc.Driver

Driver Location

<Local Drive>:\DATABASICS JDBC\wab.jdbc-8.1.0.jar

JDBC URL String

jdbc:data-basics:rest:https://api.data-basics.net/apihub/apis;logFile=<Local Drive>:\\DatabasicsJDBC\\Log\\log.txt

User ID

Provided by DATABASICS

Password

Provided by DATABASICS

Additional Information on Authentication

 

Additional Information:

2021 DATABASICS, Inc