Import DB objects from Oracle

[Bryan Donohue]

Hello, I am trying to Reverse Engineer into EA from an Oracle DB (11g).  I have noticed several discrepancies when pulling this information.  I was wondering if there is a way to customize this import (more than from the 'Import DB schema from ODBC source' window?  Or if there is any documentation specific to Data Modeling for Oracle.
Here is a quick list of the type of issues I have come across:
 - Not Null check constraints --> explicit constraints are not pulled into EA
- For VARCHAR2 column types, explicit 'BYTE' or 'CHAR' storage is not pulled.
- Materialized Views are pulled in as Tables

[Bryan Donohue]

Ok, so I have resolved the following: for VARCHAR2, length type (BYTE or CHAR) is not pulled over.
This is resolved from the 'Import DB schema from ODBC source' window
 - Within the filter options, 'Include Length Semantics (Oracle)'
Hope this helps if someone else was not sure...

[Bryan Donohue]

Hello, further update on the issues I have had with importing DB information.  I have had several e-mails with Sparx support discussing this.  My apologies for not updating this earlier.

I believe Sparx has taken note that Materialized views are not handled in EA and is planning on adding this feature (please correct me if I am wrong).

Not Null Check Constraints - My understanding is that they are aware of this.  They have had requests to prevent these constraints coming over in the past, so they no longer (or never have) allowed it.  I find that odd, since it seems you can create these check constraints within EA, and we were able to generate DDL with them.