JDBC driver

You'll be presented to the JDBC download link, as well as how you can connect.


Download and connecting

You need to download the JDBC installer.

Direct download link to the JDBC driver.

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.

jdbc:slicingdice:APIKeys=DATABASE_KEY_OR_CUSTOM_DATABASE_KEY;

Connection

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:

jdbc:slicingdice:APIKeys=DATABASE_KEY_OR_CUSTOM_DATABASE_KEY;

Connection Options

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 Other="EnforceTableSchema=false"

You can find all the connection string options on the JDBC Driver documentation.


SQL compliance

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.