Develop > Tailoring > Links > Entity Relationship Diagram creation utility > Import a DDL file into a database modeling tool

Import a DDL file into a database modeling tool

To import a DDL file into a database modeling tool, this example uses Erwin Data Modeler. Other tools may have different steps.

  1. From the Erwin Data Modeler, click File > Open.
  2. Change the file type to SQL DDL.
  3. Browse to locate the DDL file.

    By default, Service Manager stores these files at the root level of the client installation folder.
    For example: ..\Program Files\Micro Focus\Service Manager x.xx\Client\.

  4. Click the file to select, and then click Open.

    The Erwin Data Modeler displays the Reverse Engineer - Select Template wizard.

  5. Modify the settings in the Target Database section, as follows:
    • Select the appropriate Database.
    • Select the appropriate Version.
  6. Click Next.
  7. Select the appropriate values.
  8. Click Next.

    The resulting Entity Relationship Diagram opens. You can use the Zoom tool to view the content of each entity in the diagram.

Related concepts

DDL mode
Entity Relationship Diagram creation utility
What are Master link records?
What are related link records?
What is the required input for ERD Create?

Related references

Checklist: Creating an ERD record for an application
Checklist: Generating a DDL file

Related tasks

Associate a data policy record with an application
Create an ERD record
Create manual relationships
Generate a DDL file
Modify an ERD record