SQL Developer Data Modeler

Hi All,

Our current development practices for changing our data model is to update the models as required and regenerate the entire database structure using Oracle SQL Developer Data Modeler (OSDDM), including the generated DDL as a code artifact within GIT for use within our build farms. This has been working well for us from a quality perspective, however as our teams have started to grow we're encountering an increasing number of conflicts in GIT relating to the generated header and footer data found in the generated output (see examples below). We are using the following generation steps within OSDDM  (File -> Export -> DDL File -> Generate) to generate the DDL.

I've found a couple posts previously which indicated OSDDM cannot be invoked on the command line along with the outstanding feature request, so have focused on how to alter the generated output rather than re-generating on the fly. I've found the information in Doc ID 1496126.1 describing how to add custom transformations, however this doesn't seem to apply to the export functionalities.

I've also looked into templating table definitions as described in , however the templates do not appear to affect the headers or footers and the ddl objects available in the debugger indicate post generation hook is isolated from the generation process so I cannot remove the first 4 lines and last N lines.

Lastly, I've looked into creating an OSDDM extension to alter the DDL generation, however when reading through the documentation provided with OSDDM at .\datamodeler\xmlmetadata\doc I wasn't able to find anything which would enable me to alter the DDL generation. Working through the examples on GitHub helped show how to create a customization mid-business process however the documentation didn't extend to import/export functionality or customizations.

Question:

I was wondering if anyone knew where to find some documentation (JavaDoc?) on how to create an OSDDM extension that affects the DDL generation routines or how I might be able to gain access to the generated ddl within a transformation macro to delete these rows?

Thanks!

David

Header

-- Generated by Oracle SQL Developer Data Modeler 4.1.3.901

--   at:        2018-12-19 13:21:51 EST

--   site:      Oracle Database 11g

--   type:      Oracle Database 11g

Footer

-- Oracle SQL Developer Data Modeler Summary Report:

--

-- CREATE TABLE                           861

-- CREATE INDEX                          1124

-- ALTER TABLE                           8933

-- CREATE VIEW                              0

...