The JDBC and ODBC drivers are a kind of connectors to perform operations via programming languages and supported programs.
JDBC is used in Java programming language and it's applications, and ODBC is an open standard to connect with other languages like C/C+, Python and so on.
SlicingDice clients and SDKs
In order to make your life easy, we developed client libraries and SDKs for several programming languages, so you don't need the ODBC or JDBC drivers.
Take a look on our supported client libraries and SDKs.
In order to use the JDBC or ODBC driver, we kindly ask you to download SQL Workbench/J, a free, DBMS-independent, cross-platform SQL query tool. Although this guide uses SQL Workbench/J, you are free to use any other SQL query tool you already have installed.
Below are the links for the direct download of our drivers.
- ODBC Linux x86 (.deb)
- ODBC Linux x86 (.rpm)
- ODBC Linux x64 (.deb)
- ODBC Linux x64 (.rpm)
- ODBC Mac
- ODBC Windows
SQL Workbench/J requires the Java Runtime Environment (JRE) installed on your system. Ensure you are using the correct version of the JRE required by the SQL Workbench/J client. To determine which version of the Java Runtime Environment is running on your system, do one of the following:
Mac: In the System Preferences, click the Java icon. Windows: In the Control Panel, click the Java icon. Any system: In a command shell, type `java -version`.
For information about installing and configuring the Java Runtime Environment, go to https://www.java.com.
Open the Configuring Workbench/J page on a different window to see step-by-step how to add the drivers to the Workbench/J tool.
If you're using the JDBC driver, add the following connection string.
If you're using the ODBC drivers, read the ODBC driver documentation for more details.
In order to make sure you have successfully connected to the database, copy, paste and execute this SQL query below.
SELECT * FROM default;
Once you run it, you should get one line with the number of entities on the database.
Success! Now you are all set to move forward and insert and query data on your SlicingDice database.
If you're having any issues to connect to your database or if your query returned a different result, contact us.