Export Files from SQLDeveloper - eclipse-efbt/efbt GitHub Wiki

Steps for Exporting SQLDeveloper files.

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/ choose 'download SQLDeveloper' not 'download SQLDeveloper Data Modeler'

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

To export choose file->data modeler->export->To CSV.

You can then choose which model you want to export. You should choose the Logical Data Model or the Enriched Input Layer (not 'Enriched Input Layer with full names')

Not all the files are needed for the running the script, the subset we use if using the LDM is as follows:

DM_Domains.csv

DM_AVT.csv

DM_Domain_AVT.csv

DM_Logical_To_Native.csv

DM_Entities.csv

DM_Attributes.csv

DM_Relations.csv

DM_Mappings.csv

DM_Classification_Types.csv

the subset we use if using the Enriched Input Layer is as follows:

DM_Domains.csv

DM_AVT.csv

DM_Domain_AVT.csv

DM_Logical_To_Native.csv

DM_Tables.csv

DM_Columns.csv

DM_Constr_Index_Columns.csv

DM_ForeignKeys.csv

Note that although these are in csv format, they may not all be in csv utf-8 format.

For each file you should open it in Excel and “save as” with the same name, specifically choosing CSV UTF-8 as the file format. When ypou open the file you may get a pop-up message asking if you want to convert the format, you should choose 'No'

After this, if you are using the files to configure PyBIRD AI, and if you are using the LDM files, you will want to get the arcs.csv file describing the disjoint subtypes on BIRD, this can be recieved by following the instructions at https://github.com/eclipse-efbt/efbt/wiki/Running-the-Get_arcs-script