database schema

, ,
1

Hi,
does anyone know if there is documentation on the webMethods tables? if so can you please point me in the right direction.

thanks

2

Hi Cory,
Unfortunately the webMethods product tables (internal) are not documented due to various reasons. But you can find a overview of them in the chap. Creating and Dropping Database Components from the 9-8_Installing_webMethods_and_Intelligent_Business_Operations_Products

May I know what is that your are looking for?

1 Like
3

thanks for the speedy response. I will check that documentation. More specifically I am looking for TN tables so I can create custom reports.

4

Hi Cory,
I would recommend you to use Database tools to generate E-R diagram against TN schema installed. That way you will understand the relationship between TN tables very easily. Also dividing the tables into static and run-time helps you.

When you run a TN query/transaction search from MWS, there are options to show the SQL syntax used behind. That will also help you to understand better.

Thanks,
Manohara

2 Likes
5

Thank you Manohara for the response,
Good idea, I will do both.