I've had some issues with the reverse engineering (EA version 8.0.862):
1. I created a package with an empty diagram.
2. I used Oracle ODBC driver connected to an Oracle schema, marked the tables to be reverse engineered and pushed the Import. So far so good.
3. The import went on without problems, but
4. In the resulting diagram, only the lengths of the atttributes were visible, not the type: like this: STREET(100), STREETNR(5) while STREET is VARCHAR2(100) and STREETNR is NUMBER(5). In the details of attributes, everything was correct.
5. When I opened the properties for an attribute and changed the data type (even to the same value) and saved, the correct data type information appeared for ALL the attributes in this table - STREET VARCHAR2(100) and STREETNR NUMBER(5).
6. Because I had only about 12 tables, I could do the above operation for each of them and got a reasonable-looking diagram. But what I wasn't able to achieve, was to get the NOT NULL information to the diagram (even though the Not Null property was correctly set in the attribute properties).
So my question is, why does it behave as described in 4.,5.,6. and can it be helped somehow?
Thank you for your answers.