You'll be presented to the JDBC download link, as well as how you can connect.
Download and connecting
Before you start
You need to have the Java Development Kit 1.6 (JDK / Java 6) or later in order to use the JDBC driver.
If you don't have the JDK 1.6, download the latest JDK at Oracle's page.
You also need a software that allows to unpack files in .zip format.
You need to download the JDBC installer.
Unpack the file and double click the setup.jar.
If nothing happens, open your command console, navigate to the directory path where your setup.jar is and type the following command:
java -jar setup.jar
Follow the wizard. When installation finishes, you're ready to connect to SlicingDice using JDBC.
To connect, find the
cdata.jdbc.slicingdice.jar, which is in your lib folder, and
add it to the classpath of the application.
Finally, you'll need to provide the following connection string.
To connect to JDBC Driver you can use any SQL Client or any language that supports JDBC. You only need to add the driver to the classpath and provide the following connection string:
The JDBC driver has a lot of connection string options that you can use to customize your experience, below you can find the most important ones.
- Logfile: The path to the log file, with the log file you can find the translations made by the driver and debug if any error occur;
- Verbosity: The log verbosity, you can set a value between 1 and 5 where 1 is the lower verbosity and 5 the higher.
- Auto-create: Allows to auto-create missing columns using the INSERT statement, using
You can find all the connection string options on the JDBC Driver documentation.
The driver supports the SQL-92 insertions and queries, so you can use pure SQL to make queries and insertions
using the JDBC driver.
Learn more about SQL compliance in other pages of this section.