We have a detailed howto for your first steps with SQL databases in DSS.

You might want to start with that Howto. The rest of this page is reference information for Oracle.

DSS supports the full range of features on Oracle and Exadata:

  • Reading and writing datasets
  • Executing SQL recipes
  • Performing visual recipes in-database
  • Using live engine for charts

Installing the JDBC driver

The Oracle JDBC driver can be downloaded from Oracle website.

  • Select the driver page corresponding to your Oracle database version
  • Download the ojdbc6.jar file (you’ll need to accept the license agreement first, you may need to create an account)

The driver is a single JAR file called ojdbc6.jar

  • Copy the JAR file to the lib/jdbc driver of DSS
  • Restart DSS