Welcome to the Jazz Community Forum
Can we run SQL queries on RTC-SQL Database?
One answer
the databases used are relational databases. So technically you can.
Just running queries would do no harm, I just don't see why it would be of any value, except using the available reporting mechanism. Since the application is responsible for providing the data and has interfaces that should be used.
Comments
Hi Ralph,
I was wondering if you knew how to do it.
I've been searching around for using SQL queries, but RTC client doesn't support it.
I was wondering if queries could be created with the API.
Thanks,
FYI
https://jazz.net/forum/questions/28856/manually-entering-an-sql-query-into-rtc
I'm a Jazz Admin (since v1 days). I'm also pretty decent with database management and this is my $0.02:
I often run SQL on RTC database, but for the purpose of finding issues (e.g. attribute issues). Having looked at the schemas and tables, one would have to be an expert in the design of the respective CLM database (i.e. could quote the meaning of every column MODEL.WORK_ITEM_MEDIUM_STRING_EXTENSIONS, for example) to make good use of SQL. To my knowledge, the database schema are not documented publicly.
In addition, the CLM applications put controls upon the data that would be bypassed by direct SQL access. For this reason alone we reject any request for enabling users to access any of our CLM databases directly.
2 votes