SlicingDice Documentation

SlicingDice - The All-in-One Solution Documentation

Welcome to the SlicingDice documentation. You'll find comprehensive guides and documentation to help you start working with SlicingDice as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    Guides

4.1 Installing JDBC/ODBC drivers

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.

Step 1: Download and install the SlicingDice's JDBC or ODBC driver.

Below are the links for the direct download of our drivers.


Step 2: Download and install the SQL Workbench/J

Please, go to the SQL Workbench/J download center and download the program. You can also read their installation manual for more information.

Note

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.


Step 3: Workbench configuration

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.

jdbc:slicingdice:APIKeys=DATABASE_KEY_OR_CUSTOM_DATABASE_KEY;

If you're using the ODBC drivers, read the ODBC driver documentation for more details.


Step 4: Testing the connection

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.