Generating a Data Dictionary Report and Diagram for a SubView

thatjeffsmith SQL Developer 5 Comments

Tell Others About This Story:

Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews.

All I want is a report of the HR or ‘blue’ stuff.

So let’s open the reports, which you’ll find on the main File menu.

Two things here to pay attention to.

First, we don’t want the main diagram in the report, that’ll give us EVERYTHING. I just want the subview diagram.

So after un-checking ‘include main diagram,’ we need to go look at the ‘Objects’ page.

We need to create a new Report Configuration.

Now we can define a reporting configuration that defines which objects we want included.

Give it a name, click on ‘subviews’, click over the subview(s) you want included, then save the configuration.

With our configuration saved and now available, we can go back and select it from the Objects panel.

Depending on how big your subview is, this could take a second or 3.

And Our Report!

Data dictionary info AND our subview diagram – all in one HTML report.

Note I generated this using 4.2.0.17 of SQL Developer. Also note I noticed there’s a bug where the Subview Diagram links in the navigation bar to the left don’t work. Thankfully the object links work for the data dictionary bits, and you can just scroll down to the diagram.

If we had included the main diagram (remember when we unchecked that box?), our report would have two diagrams instead of just the one here for the SubView.

Tell Others About This Story:

Comments 5

  1. Hi Jeff,

    The SDDM reports are great and we would like to automate the production and embed them in our system documentation (Atlassian Confluence) by an overnight job. We have a large data warehouse model with 4000 tables and the number of reports/models is too high to make this as regular, manual task.
    So – with the reporting schema as a source for the SDDM reports – could it be possible to call the pl/sql procedure PKG_OSDM_UTILS.Generate_Report to produce the standard table reports in batch (just setting up a scheduled job producing reports from the db server)?

  2. I am using SQL Developer 4.0.0.13, the options are completely different. There is no place to uncheck “Include All Objects”. Can you please clarify how to do this for this version ?

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author

Leave a Reply

Your email address will not be published. Required fields are marked *