- Features by Edition
- Latest Features
- Licensing/Activation
- Installation
- Getting Started
- Data Sources
- Deployment/Publishing
- Server Topics
- Integration Topics
- Scaling/Performance
- Reference
- Specifications
- Video Tutorials and Reference
- Featured Videos
- Demos and screenshots
- Online Error Report
- Support
- Legal-Small Print
- Why Omniscope?
|
||||||
Oracle 10g Thin JDBCOracle 10g Thin JDBC ExampleConnecting to Oracle using the JDBC driverBelow is a guided example to connecting to an Oracle 10g database using the Oracle Thin JDBC driver. ScenarioDatabase version: Oracle 10g version 10.1.0.2.0 Other versions of OracleUnless you're using a really old version of Oracle this approach should work. Alternatively, see the Oracle 8.1.7 page. JDBC driverYou will need the Oracle JDBC driver. This is a file called “ojdbc14.jar” and is normally installed by default alongside the database server/tools. Alternatively it can be found in the download archive or installation CD, or on the Oracle website. This is a pure Java driver for connecting to local or remote Oracle databases. StepsChoose File > Connect to database and the Database Connection dialogue will appear: 1. Connection type
2. JDBC Details
3. Authentication
4. Choose table
5. Customise SQL
6. Columns
7. Specify a title
Exploring your dataOnce the Omniscope has finished opening the data, you’ll see a Table, Chart and Pie View, and a set of devices on the right. You can change to different views (visualizations such as Graph and Map) by clicking “Table view”. You can filter data by dragging sliders and clicking checkboxes on the right. The green/red barometer at the top will show you records that have been included or excluded. The Reset button resets all filters to show all records. Save your settingsIt is recommended that you save an IOK file (from the File menu) to save going through the database dialogue again for this particular database table. In future, you can open this IOK file, and optionally refresh data from the database (picking up any updated records). |