Configuring External Access to the KACE SMA Database

Note: Read-only access

• In the KACE interface, enable database access in the security settings.

• Connection Information:
  • Name: K1000
  • JDBC: MySQL(com.mysql.jdbc.Driver)
  • JDBC URL: jdbc:mysql://K1000/ORG1
  • Username: R1
  • Password: box74

Once access is enabled, you can use (for example):

• MySQL Workbench

http://dev.mysql.com/downloads/tools/workbench/

Here is a version that works well with Quest: download

• iReport

http://sourceforge.net/projects/ireport/files/iReport