Access Incorta's Apache Derby Database Instance

vickar — Tue, 14 Jun 2022 08:16:12 GMT

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.

Re: Access Incorta's Apache Derby Database Instance

JoeM — Tue, 14 Jun 2022 12:36:13 GMT

@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

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:

topic Access Incorta's Apache Derby Database Instance in Data & Schema Discussions

Access Incorta's Apache Derby Database Instance

Re: Access Incorta's Apache Derby Database Instance