Data Infrastructure Management Software Discussions
we have DFM server version 5.0.2 installed and I am looking for accessing DB tables. are there any restrictions that I can access certain tables?
You cannot directly access the database tables, however you can access the data via the built-in views.
You can find a list of the available views in the MAN pages on your UM server under the topic "Relationship among fields of various database views".
TR-3690: Access to DataFabric Manager and Performance Advisor Data Using Database Access and Data Export.
You cant access the dfm tables, but you can access the built in views as kevin said.
The documentation for Views are in two places.
Also you will have a to create a database user and enable the user both via dfm database user create and dfm database access enable -u <user-name-or-id>
You can find more details on the db views and how to access information in the TR that kevin mentioned above.
BTW UM 5.2 has few more view compared to version 5.0.2