AnsweredAssumed Answered

What's in a Database?

Question asked by shawn.tuttle on Aug 17, 2018
Latest reply on Aug 17, 2018 by Suman Pramanik

Hey fellow Clarity users,

 

I got JasperSoft hooked up to dev and prod Clarity adapters. I want to query tables like srm_resources and cmn_sec_assgnd_right. 

 

The problem is that it looks like there are hundreds of databases to choose from such as ABITU01, ACHSA09, SANNI06, ZORST01, and so on. No clue what any of these mean. Trying to click into a database to look at the options to see "synonym," "table," and "view" takes several seconds, let alone then trying go into each of those to look for tables and views. 

 

Has anyone else run into this problem? How do I find the tables or views that are useful to me?

 

Thanks!

Outcomes