Custom K2 Reporting


Badge +5
What are the options for custom reporting against K2 data and Application DB data?

Obviously you can go through K2ROM but there are user access issues

Is it supported to do read only queries off the K2Log DB

Any other options?

thanks

3 replies

Badge +11
Yes, that is one of the main reasons for the existence of the K2Log db. You are allowed to do read only queries on the K2Log db.

Regards,
Ockert
Badge +5
thanks, is there any help on the data model or sql queries or is it a matter of figuring the data structures out yourself.

thanks
Badge +11
You can contact your local K2 support office for a copy of the K2Log ERD document. This is a draft document explaining the table layouts. What I normally do is to run a SQL trace on the K2Log db and then run a specific K2Workspace report which returns more or less the same data that I need. I then use this query as a starting point.

Regards,

Reply