Forum Discussion

andyazz1234's avatar
andyazz1234
9 years ago

CA Database Schema - SQL Querying

Hi there - I am currently looking to build some custom SQL queries against the CA database but am struggling to understand the various tables and their relationships.

Is anyone aware of where I can find a data relationship diagram, CA data model schema, or data dictionary to assist?

As a temporary option, I am looking at the IntDiscoveredItems table which I understand are similar to the alerts produced when certain hotwords are hit. However I am unsure how to link this table back to the IntHotwordID table?

Any help is much appreciated.

Basics
Compliance Accelerator
Documentation
Features
Information Governance
Monitoring
Not Applicable
Reporting
Rules
Search & Analysis
  • Kenneth_Adams's avatar
    Kenneth_Adams
    Level 6
    9 years ago

    Hello, andyazz1234;

    We don't publish any documentation on the relationships between the different tables in the CA (or DA) databases.  That's proprietary information.  Sorry.

    What I can tell you is:

    1. We don't keep track of the numbers of hits found in each search.  That's an enhancement request that we've received from a small number of customers, but has not made it into the product as yet.

    2. The tblIntHotword table contains information that can relate the individual Hotwords to the specific Department or Departments in which they have been configured for use.

    3. The tblIntDiscoveredItems table contains the items captured through Random Sampling or searches that have been added to the review set.  Items in searches that are awaiting acceptance or rejection are in a different table.

    If you want to get an idea of table relationships, you can create a database diagram for a specific table and its related tables.  That's what I do when I need to find out what tables are related to others that I've not used before.

    I hope this helps.  Sorry for not responding sooner.  We've been busier than expected lately.

    Kind regards,

    Ken

  • JimmyNeutron's avatar
    JimmyNeutron
    Level 6
    9 years ago

    Can you give more details on what you want the query to do? What type of info are you trying to query?