Running Reverse Engineering
To run reverse engineering:
1. In the navigation menu click Tools > Reverse target database.
A window opens.
2. Select the source database.
3. Click Next.
4. Select the Type of data source: Extraction file obtained using the data extraction utility (see Extracting Database Schema Description from Data Sources).
5. Indicate the location of the file.
6. Define the Options:
If the database has already been reverse engineered, it is possible to specify the extent of the Reinitialization, which can concern only Additions, Deletions or Modifications.
The Simulation option is provided so you can simulate the operation and generate a report indicating the impact on the repository.
7. Click the Next button to run reverse engineering.
Messages inform you of progress.
8. On completion of processing, a report displays the details of the execution.
At the end of reverse engineering, the database tables and columns are created. However, the relational diagram must be created in order to view the database in a graphical model.
If non-standard datatypes were created in the DBMS, they must be added to the configuration if they are to be recognized by HOPEX. See Recognizing Datatypes by ODBC.