Automic Automation Intelligence DB schema

[Timothy Yanosko]

Hi,
  We're installing AAI and I was asked if there is any documentation on the schema much like what is available for the Automation Engine?  I looked at the online docs and could not find it so I'm asking you fine folks.

Thank you in advance.

Tim

[Christopher Walsh]

Hello Timothy,

Unfortunately there is not a published schema for the AAI database.

After installation there is a .sql file created in the <Install Dir/scripts folder called createJawsDB.sql which will have all of the tables and columns listed within, this is one of the files used to create the AAI database, so it can be a reference.


The other thing to note, is that most items that you may want to pull from the database is also available from the REST API.

You can reach the AAI REST API Swagger page, which has details about each field documented on the page via the URL below post installation:

http://<serverName>:8080/aai/devPreview

There is some documentation on the REST API in the link below:
https://docs.automic.com/documentation/webhelp/english/ALL/components/TERMA/latest/AAI%20Guides/Content/REST_API/REST_API_INTRO.htm?tocpath=Reference%7CAAI%20REST%20API%7C_____0