Solved

Create extended data model or data dictionary

  • 10 October 2022
  • 2 replies
  • 56 views

Before I reinvent the wheel ;-)… Is there a way to either:

  • add the table comments and column help text to a data model generated by the Definer/TeamWork, or
  • generate a data dictionary from the Definer tables?

Thanks!

icon

Best answer by USoft Support 11 October 2022, 16:33

View original

2 replies

Badge +1

Hi Marc,

 

Unfortunately you probably will have to reinvent the wheel ;-).

 

As we understand you questions, you are interested in creating a kind of report on the technical metadata in the repository (like tables and columns) and combining it with functional descriptions of the different elements.

 

The function "Generate Diagram” in the Definer regrettably produces a fixed content. The other possibilities we offer to extract metadata (as you may already have found) are:

 

In the Definer: 

  • Choose menu option "Tools”, menu item "Generate HTML reports ...”
  • in SQL Commander, use the function "Repo meta ...”
  • In SQL Commander, use the function “XML.SQLExport” to create a customized report on the repository tables (see: XML.SQLExport. This option offers you a lot of flexibility, but also requires a lot of "wheel reinvention” ;-).

 

In the user application:

  • Using the internal component "USMeta” (see: USMeta internal component). This component does not allow you to select additional metadata.
    In SQL Commander execute a statement like:

        INVOKE
           USMeta.Tables
        WITH
        SELECT
            'Yes'                        IncludeDatabaseTables
        ,    'application/json'    MimeType

 

Using USoft Blend:

 

Hopefully this gives you some avenues to explore, but at this point unfortunately there is no ready-made solution to what you want to achieve. Apart, of course, from writing your own queries on the repository tables (reinventing your wheel from scratch ;-)).

OK, thanks for the information!

Reply