Hello,
I am currently looking for an alternative to SAP PowerDesigner for our developer team. I have two questions regarding SQL Developer Data Modeler.
We are looking for a product that allows for automated creation of triggers for certain columns in a table. More precisely, for example if a user updates a table record, then its field USER should be updated with the username and its field UPDDATE should be updated with the current date. The trigger that does this should be created automatically by the application when creating a table. Does Data Modeler have any such feature or does it at least allow for the definition of custom extension scripts for that purpose?
The second question I have is whether or not it is possible to use version control for the graphical representation of the databases such that after pulling a new version from the repo, the graphical representation does not have to be generated again but instead is pulled as well in the newest version.