topic Re: ArcGIS Workflow Manager Database Model Diagram in ArcGIS Workflow Manager Questions

ArcGIS Workflow Manager Database Model Diagram

KitDwyer — Thu, 09 Apr 2015 21:02:16 GMT

Is it possible to export a database model diagram from the Workflow Manager application, or Workflow Administrator, which includes the custom tables configured for our team? I would like to visualize the connectivity between key fields.

Re: ArcGIS Workflow Manager Database Model Diagram

Anonymous User — Fri, 10 Apr 2015 00:42:03 GMT

Hi Kit,

There is no functionality to export a database model diagram from within Workflow Manager. We do provide a database diagram in the installation, however, it is WMX System Tables.pdf under the Help folder of the Workflow Manager install directory. You didn't specify which version of our product you were using, but for 10.3 onwards we have updated its styling to make it easier to interpret and I can provide you a copy if you would like.

External custom tables (Ie. Extended Property tables) are joined to the Workflow Manager database using the JobID field, the central table for job information is the JTX_JOBS table.

Cheers,

Michael

Re: ArcGIS Workflow Manager Database Model Diagram

KitDwyer — Fri, 10 Apr 2015 14:08:18 GMT

Michael, Thank you for the information. The version I have is 10.2.2, but I would very much like to see the copy which you offer to provide. I also appreciate the helpful information on how custom tables are joined to the Workflow Manager.

I look forward to your response,

Kit

Re: ArcGIS Workflow Manager Database Model Diagram

Anonymous User — Fri, 10 Apr 2015 16:23:15 GMT

Hi Kit,

I've attached the 10.3 WMX System Tables pdf with the improved styling. It's schema is almost identical to what you have at 10.2.2 with a few additions, but should serve your purpose well.

If you have any other questions please let us know

Cheers,

Michael

Re: ArcGIS Workflow Manager Database Model Diagram

KitDwyer — Fri, 10 Apr 2015 19:19:44 GMT

Hi Michael,

I don't see an attachment.

Re: ArcGIS Workflow Manager Database Model Diagram

Anonymous User — Fri, 10 Apr 2015 20:42:28 GMT

Hi Kit,

It's embedded in the text of my last message, just below "Cheers, Michael" there's a box with a graphic of a paperclip attaching it to my last message and it says WMX System Tables.pdf

Cheers,
Michael

Re: ArcGIS Workflow Manager Database Model Diagram

KitDwyer — Mon, 13 Apr 2015 03:58:14 GMT

OK, I found it. Thank you!