Running the Get_arcs script

Introduction

The Get_arcs script get information about arcs from SQLDeveloper which describes disjoint subtypes in the BIRD LDM. You only need to run this if you are working with the Logical Data Model (LDM), if you only use the BIRD Input Layer you do not need to run this script.

It should be run from within the transformations window of SQL Developer.

Note that it appears that SQLDeveloper requires Java 11, particularly when running scripts. You can make SQLDeveloper use Java 11 by setting the JAVA_HOME environment variable to point to your Java 11 installation.

Note that the latest version of SQLDeveloper states that it requires Java 17, so to use this script it appears that you must be running a slightly older version of SQLDeveloper such as version 23.11 available at https://www.oracle.com/tools/downloads/sqldev-downloads-2311.html

Steps

You can get the SQLDeveloper version of the BIRD Content sectionof the 'About BIRD' page on the BIRD website https://bird.ecb.europa.eu/projectDefinition.

Extract the files from the downloaded zip file into to a local directory.

Download and start the Oracle SQLdeveloper tool from https://www.oracle.com/uk/database/sqldeveloper/

Open the datamodel by choosing file->data modeler->open and choose the dmd file from the unzipped content.

Open the transformations dialog

create new script called Get Arcs, save it an run it (click save and then click apply)

you can get the contents to paste in here at:

arcs.txt

Copy the resulting comma separated results from the output log message

Remove the time stamps (It runs so quick that they are mostly the same, so you can do replace in Notepad)

Save this as arcs.csv in the same place as where you stored the LDM csv files exported from SQLDeveloper ( as described here https://github.com/eclipse-efbt/efbt/wiki/Export-Files-from-SQLDeveloper)