yes Amy, you just use the ca adapter and oralce java files like you do when you are attaching to jaspersoft.
ie, ca_jdbc_adapter_6.2.1.3.jar
ojdbc6-11.2.0.4.jar
I also found SQL Workbench, which I like a little better because it functions more like SQL Developer. Find it here SQL Workbench/J - Home
I do find it easier to switch from prod to dev environments and between ppm db and dwh db.
One little trick they have is to export directly to excel, use this code:
WbExport -type=xlsx
-file='C:\Users\taylk128\Downloads\SQL Workbench Export\export.xlsx'
-delimiter=','
-decimal=','
-dateFormat='yyyy-MM-dd';