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.jarfile (you’ll need to accept the license agreement first, you may need to create an account)
The driver is a single JAR file called
- Copy the JAR file to the
lib/jdbcdriver of DSS
- Restart DSS