Access Incorta's Apache Derby Database Instance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2022 01:16 AM
we have an on-prem instance of Incorta at our organization that uses Apache Derby Database.
I'm wanting to access this DB Instance. I found a related community post below but there is a Page Not Found msg on the page.
Query Incorta's Derby Database - Page Not Found
any help on suggesting a solution or sharing related guidance would be very appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2022 05:36 AM
At times, for a variety of reasons, it can be convenient to query the metadata stored in this embedded Derby database directly. By its design, Derby can only handle one connection at a time and if Incorta is running (you guessed it) Incorta claims the one connection. However, if Incorta is stopped, the following steps detail how to connect so that the metadata can be queried or altered.
Accessing Derby DB
- Download Apache Derby from the following URL https://db.apache.org/derby/releases/ (Incorta embeds Derby so the ij tool leveraged below doesn't exist in our install)
- Unzip on server where Incorta is installed
- Ensure Incorta is NOT running
- Start ij tool
$ cd ./db-derby-10.13.1.1-bin
$ java -cp "lib/*" org.apache.derby.tools.ij
ij version 10.13
ij> connect 'jdbc:derby:/Users/johnpelz/IncortaAnalytics/derbydb/incorta';
Example once connected to Derby:
ij> show schemas;
TABLE_SCHEM
------------------------------
APP
INCORTADBUSER
NULLID
SQLJ
SYS
SYSCAT
SYSCS_DIAG
SYSCS_UTIL
SYSFUN
SYSIBM
SYSPROC
SYSSTAT
12 rows selected
ij> set schema INCORTADBUSER;
0 rows inserted/updated/deleted
ij> show tables in INCORTADBUSER;
TABLE_SCHEM |TABLE_NAME |REMARKS
------------------------------------------------------------------------
INCORTADBUSER |ACTION |
INCORTADBUSER |BOOKMARK |
INCORTADBUSER |CATALOG_LINK |
INCORTADBUSER |COMPONENT |
INCORTADBUSER |DASHBOARD |
INCORTADBUSER |DASHBOARD_COMPONENT |
INCORTADBUSER |DATAFILE |
INCORTADBUSER |DATASOURCE |
INCORTADBUSER |DB_UPDATE |
INCORTADBUSER |FOLDER |
INCORTADBUSER |GROUP |
INCORTADBUSER |GROUP_ROLE |
INCORTADBUSER |GROUP_USER |
INCORTADBUSER |LDR_JOB |
INCORTADBUSER |LDR_JOB_DETAILS |
INCORTADBUSER |LDR_JOB_DETAILS_HISTORY |
INCORTADBUSER |LDR_JOB_HISTORY |
INCORTADBUSER |PERMISSION |
INCORTADBUSER |QRTZ_BLOB_TRIGGERS |
INCORTADBUSER |QRTZ_CALENDARS |
INCORTADBUSER |QRTZ_CRON_TRIGGERS |
INCORTADBUSER |QRTZ_FIRED_TRIGGERS |
INCORTADBUSER |QRTZ_JOB_DETAILS |
INCORTADBUSER |QRTZ_LOCKS |
INCORTADBUSER |QRTZ_PAUSED_TRIGGER_GRPS |
INCORTADBUSER |QRTZ_SCHEDULER_STATE |
INCORTADBUSER |QRTZ_SIMPLE_TRIGGERS |
INCORTADBUSER |QRTZ_SIMPROP_TRIGGERS |
INCORTADBUSER |QRTZ_TRIGGERS |
INCORTADBUSER |ROLE |
INCORTADBUSER |SCHEDULER_JOB |
INCORTADBUSER |SCHEMA |
INCORTADBUSER |SESSION_VARIABLE |
INCORTADBUSER |TENANT |
INCORTADBUSER |TENANT_CONFIG |
INCORTADBUSER |USER |
INCORTADBUSER |USER_ROLE |
37 rows selected
