Steps
Topology
- Physical Architecture (The location System)
- Duplicate the default physical data server (FILE_GENERIC)
- Enter the host name (and eventually the connection parameters)
- Create a physical Schema. Fill the following fields with one directory:
- Directory (Schema)
- Directory (Work Schema)
- Topology Physical Schema (The directory)
- Logical Schema (The context attached to the Physical schema)
Designer
- Model (The description of the file)
- Select the file technology (Scroll !)
- Right click on the model > New Data Store
- Configure the format in the Files tab
- Reverse Engineer the attributes in the attributes column
- Right click the data store > View Data
Support
ORA-00001: unique constraint
com.sunopsis.dwg.SQLWorkReposException: ORA-00001: unique constraint (DEV_ODI_REPO.AK_REV_COL) violated
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
When reversing, verify that two headers doesn't have the same name.