DATABASICS JDBC Driver

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:

  • RazorSQL

  • DBeaver

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

  • CData

  • ZappySys JDBC-ODBC

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.

Additional Information on Authentication

Additional Information:

• JDBC Compliance

• Select Statements

• Aggregate Functions