for surrogate keys you need to look at entity dialog and thee is "create surrogate key" check box.
I used Oracle Designer and could always generate columns with prefixes
There are tow transformation scripts delivered with Data Modeler and you can use them to add/remove prefix if you have table abbreviation defined:
1) "Table abbreviation to column"
2) "Remove Table abbr from column"
thank you for you answer, but I'm really stupid. I use Data Modeler in German Language. When I look at the Dialogue Box "Entity Eigenschaften" I cannot find the check box.
Please help me again.
Where can I find "table Abbreviation" and the 2 scripts.
Thank you again for your help
Message was edited by: siegwin.port Please have a look to the link
I use Data Modeler in German Language. When I look at the Dialogue Box "Entity Eigenschaften" I cannot find the check box.
It should be under "Typsubstitution erlauben" check box. And it's available in DM 3.3 - if you are on version 3.3 then you need to extend entity dialog.
Where can I find "table Abbreviation"
Table dialog - it's called "Abbreviation" and it's the third one - 1)Name, 2) Long name and 2) Abbreviation
For scripts you need to go to "Tools>Design rules>Transformations> - you can create, edit, debug and execute transformation scripts there, otherwise you can execute transformations
using "Apply Custom transformation scripts" in context menu in browser for logical and relational models.
Which version of Data Modeler are you using? Are you using the Windows version of Data Modeler?
The Create Surrogate Key (Surrogatschlussel erstellen) check box is new in Data Modeler version 3.3.
It's the last field on the General (Allgemein) tab for an Entity.
thank you for your answer. I am using
in German on Windows 7 64 Bit
I cannot find another Version on the download section of otn.oracle.com
Please help me again.
Thank you and regards
The version you are using (22.214.171.1240) does not include the Surrogate Key funcionality.
You can download the latest version (126.96.36.1997) from http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html
You can add a prefix to column names using the Transformation Script "Table abbreviation to column".
First you need to set the Abbreviation property for the relevant Tables (it's the third property on the General tab for the Table).
Then you need to select Design Rules/Transformations from the Tools menu. Select "Table abbreviation to column" and click the Apply button. Finally click the Close button to close the dialog.
This should add the Table Abbreviation to the beginning of all its column names.
thnak you for your help. Please have again a look onto this link.
You will see that there are Primary Key and Foreign Key genarated automatically and the Abbreviation was used. But the columns did not get the Prefix.
What did I wrong?
Thank you for yout help.
After you have forward engineered the Logical Model to the Relational Model), you should check that the Abbreviation property is set appropriately for the relevant Tables, and then run the transformation script "Table abbreviation to column".
This should prefix the column names with the table abbreviation.
Abbreviation (Abkurzung) is on the General (Allgemein) tab in the Properties Dialog for a Table in the Relational Model.
There are 2 alternative ways to run the Transformation script:
1. Right_click on the Relational Model in the Browser, and select Apply Custom Transformation Scripts (Benutzerdefinierte Transformationsskripte anwenden) from the drop-down menu.
Use the right arrow to move "Table abbreviation to column" from the left column into the right column.
Select the Apply (Anwenden) button.
2. From the Tools (Extras) menu select Design Rules/Transformations (Entwurfsregeln/Transformationen).
Select the fourth entry ("Table abbreviation to column") and click the Apply (Anwenden) button.
Then click the Close (Schliessen) button.
Note that you can run Data Modeler in English if you wish.
First close Data Modeler and then edit the file datamodeler.conf (if you are using Data Modeler in 32 bit mode) or datamodeler64.conf (if you are using Data Modeler in 64 bit mode).
These files are in folder datamodeler\datamodeler\bin.
To run Data Modeler in English, you should add the following lines to the file: