Oracle
Features
Work with Oracle straight from Quix, execute multiple queries in parallel, explore the db tree, visualize and download the results into csv.
Setup
To setup Oracle note you have to perform the following two steps :
1. Pick new name and update .env
Add/update following properties to .env file to configure your new oracle note
| Variables | Meaning | Example |
|---|---|---|
MODULES | list of registered notes | foo,boo,prod,qa |
MODULES_FOO_ENGINE | note type | jdbc |
MODULES_FOO_DRIVER | jdbc driver class | oracle.jdbc.driver.OracleDriver |
MODULES_FOO_URL | jdbc url | jdbc:oracle:thin:@localhost:1521:db |
MODULES_FOO_USER | db username | user |
MODULES_FOO_PASS | db password | pass |
MODULES_FOO_SYNTAX | syntax marker | ansi_sql |
example of oracle jdbc note that will be named foo in the UI
MODULES=<comma separated list of your modules>,foo MODULES_FOO_ENGINE=jdbc MODULES_FOO_DRIVER=oracle.jdbc.driver.OracleDriver MODULES_FOO_URL=jdbc:oracle:thin:@localhost:1521:db MODULES_FOO_USER=your-user MODULES_FOO_PASS=your-password MODULES_FOO_SYNTAX=ansi_sql