Database Tools and the Hidden Truth

There's been a number of posts recently referring to "Where is the data stored" in the webMethods schema.

I've seen questions and queries in the past relating to the "unpublished" webMethods schema. No one at webMethods will speak out about how the schema works, what's in it and how, when, it grows and for what reason.

My current project requires the use of data modeling tools. So, I've installed ERWIN, which is a very expensive (but worth it) Computer Associates Tool for modeling, reverse engineering and other DB creation functions.

But, for us poor folks (which is where I reside), there is a wonderful tool that you can get for free that will create a visual on a database, show relations and allow you to export the relationship diagram as a jpg. The tool is called DBVisualizer and I have version 4.3.5.

So, I pointed the DBVisualizer to my webMethods schema (I call it wmsupport), I choose the Partner Table to see what the relationships are.

I have attached the jpg to show you the output. (Note: I cropped the output because the original was 1.3mb so it will not show all relationships)

So, next time an issue arises during development and you need to determine where data is stored because you decide that you want to create your own workaround (Read: create a sql select to get the data out that you want, therefore avoiding the webMethods TN API), then you will move more quickly.