Instructions to create an ERD (Entity Relationship Diagram) for Maximo 7.6.1.x environments

 View Only

Instructions to create an ERD (Entity Relationship Diagram) for Maximo 7.6.1.x environments 

Wed January 11, 2023 03:57 PM

Understanding the Maximo database with its enormous amount of database objects, attributes and relationships is a huge task.  Using an ERD (Entity Relationship Diagram) can streamline that task in providing details on selected objects - and how they are related to each other.

IBM provides instructions and features to create a custom ERD Diagram for a Maximo 7.6.1.x environment.   A custom ERD will pick up any new database objects, attributes you have added - along with any database features added by Industry Solutions and Third Party Products.

The instructions to create a custom ERD diagram are located at: https://www.ibm.com/support/pages/node/6403201

These instructions are copied below:

1.  Log on to the server where the Maximo Application workstation is installed

2.  Open a Command Prompt (Windows) or a Terminal session (Linux)

3.  Change directory to IBM\SMP\maximo\tools\maximo\internal (Windows) or /IBM/SMP/maximo/tools/maximo/internal (Linux)

4. Execute generd.bat|.sh

5.  Execute generdwithlogical.bat|.sh

6.  In a browser, open <SMP_directory_location\maximo\tools\maximo\erd\index.html

Statistics

0 Favorited
47 Views
0 Files
0 Shares
0 Downloads

Comments

Andy Winter
Mon January 23, 2023 04:45 AM

I have managed from the start without an ERD. Yes I craved one but found I could manage by just following the Relationships in each table on the Database Configuration tool. This works for me in SQL, Auto Scripts (python) and using "." in Communication templates. Even creating new ones as required e.g. specific roles for Comm Templates