cancel
Showing results for 
Search instead for 
Did you mean: 

Access Incorta's Apache Derby Database Instance

vickar
Rocketeer

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.

1 REPLY 1

JoeM
Community Manager
Community Manager

@vickar 

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

  1. 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)
  2. Unzip on server where Incorta is installed
  3. Ensure Incorta is NOT running
  4. 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