Internal: Does erwin Data Modeler support the Oracle Data Type: IDENTITY? (4279768)

Question: 

Does erwin Data Modeler support the Oracle Data Type: IDENTITY?

Answer:

Currently versions of erwin Data Modeler 2020 R2 and below do not support the Oracle 12c IDENTITY clause.  It is scheduled to be supported in the near future.

Workaround: 

1. Download the attached file and save it to your local drive.
2. Launch erwin DM and open the needed model.
3. Create a Column Level UDP name 'Gen_Identity' as follows:

​  

  Please note that the name must match as that is the one referenced in the FET file.

4.  In the Column Editor for the respective Columns which will be used for IDENTITY, add the value as needed, e.g.:
  ​

5 . Initiate Forward Engineering (Schema) and in Option Selection tab, click on Edit... button at the bottom and navigate to the FET file as saved in step # 1.  Click on Preview and note the syntax. Here is what we see in our sample test model:
      ​

Note: If there is a FK related to the Column which has this UDP value added, it will also migrate to the FK Column where it may not be desired. In that case, in the Column Editor, under UDP tab, click on the box to open the editor and replace the syntax with a single space.

If the syntax generated is what you like, then you can also change the location of the file to use it by default rather than having to select it each time. Here is how to do it:
1.  Go to the following folder
      C:\ProgramData\erwin\Data Modeler\9.9\Templates
      (This is for erwin DM 2020 R1 SP1, please change it as per the version being used at your end).
2.  Save the attached file to the same folder:
3.  In the same folder, rename the existing file named 'Oracle11g.fet' to 'Oracle11g.fet.orig'
4.  Rename the newly copied file to 'Oracle11g.fet'.

So, basically the existing file is being replaced by the new .FET file, but it will also preserve the original file. When erwin DM is relaunched, it will pick up the new Oracle11g.FET file to give the expected syntax for Identity clause.