Data Model

The Data Model is a list of all tables and columns in the database. You can also view table references and where tables are used. 

Click the Data Model link from the Main Menu to access the Data Model. The Data Model displays in a new tab or window.

The Data Model web page displays a list of all tables. 

  • Click a table name hyperlink to view columns for a specific table.
  • Click the Show Tables and Columns tab at the top of the page to view a list of all tables and columns. The page may take several minutes to load because of the large number of results this returns.
  • To view table references, click the table name hyperlink to view the columns for a table. At the top of the page with the list of columns, click the Table References tab.
  • To view where a table is used, click the table name hyperlink to view the columns for a table. At the top of the page with the list of columns, click the Where Used tab. Click the tab to display a list of all the tables where the Primary Key combination (displayed as links) of the selected table is used across the entire database. If the column names do not display, click the Show Tables and Columns button at the top of the page. 
  • If a column in a table is a key piece of information, it displays as a hyperlink. Click the hyperlink to open a page with a list of all the tables and columns the column is used in. This is helpful when the column name is not the same between tables.

Related articles

Comments

29 comments

Date Votes
  • Pat Falkner

    Where is the data model for v19.9/v20.9 ?

    It doesn't appear to be available on the Ungerboeck online data model

    0 upvotes

  • Maggie U.

    Hi Pat,

    We are currently finalizing the changes and it will be available shortly.  I'll post on the other thread when it is ready.

    Thanks,
    Maggie

    0 upvotes

  • Polina Zhitomirsky

    It's June 2017. Is there a link to the database model?

    0 upvotes

  • Maggie U.

    Hi Polina,

    The v20.9/v19.9 Data Model information was made available in February and uses the same Data Model link that is available from the Main Menu.

    Thanks,

    Maggie

    0 upvotes

  • Donnelle Curnow

    Hello,

    I am unable to open the Data Model from the main menu.  I am working in version 19.90FP42.  Where do I find the link?

    0 upvotes

  • Maggie U.

    Hi Donnelle,

    In v19.9, it is called EBMS Data Model and is in the Query & Reporting module on the Main Menu.

    Thanks,
    Maggie

    0 upvotes

  • John Sadler

    We're still on 20.8. I can't get this to run in 19.8 or 20.8. Is there another way to get the database model or diagrams? In the manual or something maybe? Thanks!

    0 upvotes

  • Maggie U.

    Hi John,

    Sorry to hear you are having problems.  Clicking on the Data Model link from the v20.8 Main Menu should open it directly.  When you click on the link, do you get a message or some other feedback?  That will help indicate what the problem may be.

    Thanks,
    Maggie

    0 upvotes

  • John Sadler

    Hi Maggie, thanks for the reply! Unfortunately that's the problem. I don't even have the link in 20.8. It tries to bridge me back to 19.8, and when I click it in 19.8 it tries to load an external website that doesn't give me access.

    0 upvotes

  • Maggie U.

    Hi John,

    What I think you are seeing is a prompt to enter your FTP credentials.  If you enter those credentials into the login screen, you'll be redirected to the new Data Model site.  Your system administrator has the FTP credential information and may need to log in for you.  In later versions, the credential authentication is done automatically but v20.8 requires the FTP login for the redirect.  

    Thanks,
    Maggie

    0 upvotes

  • John Sadler

    Ok thanks Maggie, I'll give that a try. Appreciate the help.

    0 upvotes

  • jorge berumen

    Is there a way to only return a subset of the fields return by the REST API? Getting an event returns a bunch of fields i don't need

    0 upvotes

  • Maggie U.

    Hi Jorge,

    I talked with my API expert and although it's not currently available, it will be in a future release.

    Thanks,
    Maggie

     

    0 upvotes

  • Pat Falkner

    When will v19.94/20.94 version of the data model be available?

    We want to begin testing/verifying changes so any of our custom applications and reports do not break.

    Would you happen to have a rundown of the changes at all?

    Thanks.

    0 upvotes

  • Maggie U.

    Hi Pat,

    This is targeted for mid-June. I'll let you know when it's available.

    Thanks,
    Maggie

    0 upvotes

  • Shilpa Ramesh
    • Edited

    Hi,

    It is still not working for 20.94 version and its past mid-June.We need access to data model to give some points for wrapper development ASAP.Could you please let us know when this would be working?

    Thanks!

    0 upvotes

  • Maggie U.

    Hi,

    Wanted to update the thread to let you all know the v20.94 Data Model is available.

    Thanks!

    Maggie

    0 upvotes

  • Sean Tame

    Hi @...,

    Any word on when the Data Model action in v30 will be hooked up?

    0 upvotes

  • Maggie U.

    Hi Sean,

    It is planned for v30.95 Release C which is estimated to be at the end of 2019.

    Thanks,
    Maggie

    0 upvotes

  • Christoph Höller

    Hi, 

    we're on v20.94 but there's no Data Model link in the Main Menu. Searching for it comes up with nothing. Is this a feature that needs to be activated first?

    Kind Regards,

    Christoph

    0 upvotes

  • Maggie U.

    Hi Christoph,

    This menu option is located under the Query & Reporting module. Your Account Manager is the best person to talk to see what may be needed to have access to this module.

    Thanks!

    Maggie

    0 upvotes

  • Christoph Höller

    Hi Maggie, 

    thanks for the clarification. As it turns out, "Query & Reporting" is just not something we have licensed and that's why we don't have the Data Model link in the Main Menu. 

    Kind Regards,

    Christoph

    0 upvotes

  • Lee Tickett (Tickett Enterprises Limited)

    Is the data model broken? Yesterday it was loading a garbage screen- today it's not loading anything "ERR_CONNECTION_RESET"

    Thanks

    0 upvotes

  • Maggie U.

    Hi Lee,

    I'm not experiencing the same problems. Please enter a ticket if it's an ongoing issue.

    Thanks,
    Maggie

    0 upvotes

  • Lee Tickett (Tickett Enterprises Limited)

    Working OK now- thanks Maggie

    0 upvotes

  • Rebecca Green

    Hi @..., I am trouble shooting a Crystal report issue after upgrading to .98.  When I attempt to change the version in the data model I get the prohibited symbol.  I am looking at the ER101 table.  Thanks!

    0 upvotes

  • Ryan Canny

    Hi Rebecca,

    Can you provide a screenshot of the error you are seeing?

    Thanks,

    Ryan

    0 upvotes

  • Rebecca Green

    Here you go...

    0 upvotes

  • Carrie Spalding

    Hi Rebecca!  I apologize it's taken me so log to get back to you - I have verified with our team that we have not made any updates to the data model, therefore 30.97 is still the most current version available.

    0 upvotes

Please sign in to leave a comment.