External Database Access

You can configure the Firewall Management Center to allow read-only access to its database by a third-party client. This allows you to query the database using SQL using any of the following:

• industry-standard reporting tools such as Actuate BIRT, JasperSoft iReport, or Crystal Reports

• any other reporting application (including a custom application) that supports JDBC SSL connections

• the Cisco-provided command-line Java application called RunQuery, which you can either run interactively or use to obtain comma-separated results for a single query

Use the Firewall Management Center's system configuration to enable database access and create an access list that allows selected hosts to query the database. Note that this access list does not also control appliance access.

You can also download a package that contains the following:

• RunQuery, the Cisco-provided database query tool

• InstallCert, a tool that you can use to retrieve and accept the SSL certificate from the Firewall Management Center that you want to access

• the JDBC driver you must use to connect to the database

See the Secure Firewall Management Center Database Access Guide for information on using the tools in the package you downloaded to configure database access.