Cisco Cisco Firepower Management Center 2000 Developer's Guide
2-7
FireSIGHT System Database Access Guide
Chapter 2 Setting Up Database Access
Connecting to the Database Using a Third-Party Application
The following sections contain tips for connecting to the Cisco database using three popular
industry-standard reporting tools. Whether you use one of these tools or another Java-based application,
you should refer to the documentation for your reporting tool for detailed instructions on how to create
a JDBC SSL connection.
industry-standard reporting tools. Whether you use one of these tools or another Java-based application,
you should refer to the documentation for your reporting tool for detailed instructions on how to create
a JDBC SSL connection.
Crystal Reports
The following is valid for installing Crystal Reports 2011 on a 32-bit Windows environment. If you
run a 64-bit Windows environment, the filepaths may be different.
run a 64-bit Windows environment, the filepaths may be different.
To allow Crystal Reports 2011 to connect to the Cisco database, you must:
–
add the JDBC driver JAR files that you downloaded from the Defense Center to the Crystal
Reports classpath. Assuming a default installation of Crystal Reports, you can edit the classpath
section in the following file:
Reports classpath. Assuming a default installation of Crystal Reports, you can edit the classpath
section in the following file:
C:\Program Files\SAP BusinessObjects\SAP Business Objects
Enterprise XI 4.0\Java\CRConfig.xml
–
copy the keystore that was created when you installed the client SSL certificate to the
appropriate Crystal Reports security directory. Assuming a default installation of Crystal
Reports, that directory is:
appropriate Crystal Reports security directory. Assuming a default installation of Crystal
Reports, that directory is:
C:\Program Files\SAP BusinessObjects\SAP Business Objects
Enterprise XI 4.0\win32_x86\jdk\jre\lib\security
–
create a new JDBC (JNDI) connection with the Database Expert, using
Cisco
as the database
name.
JasperSoft iReport
To allow iReport to connect to the Cisco database, you must:
–
add the JDBC driver JAR files that you downloaded from the Defense Center to the iReport
classpath.
classpath.
–
add a new JDBC driver using the JDBC driver JAR files that you downloaded from the Defense
Center. After you add the driver files, iReport should find the correct driver class.
Center. After you add the driver files, iReport should find the correct driver class.
–
create a new database connection using the driver you just created.
Actuate BIRT
To allow BIRT to connect to the Cisco database, you must:
–
add a driver definition using the
Generic JDBC Driver
template.
–
create a new database connection using the
Generic JDBC
profile type.
–
create a data source for reports using the
JDBC Data Source
data source type.
JDBC driver class
You must use the following driver class when you configure a connection to
the Cisco database:
the Cisco database:
com.sourcefire.vjdbc.VirtualDriver
user name and
password
password
To connect to the database on an appliance, use a user account that has the
External Database User permission. For more information, see
External Database User permission. For more information, see
Table 2-2
Connection Information for Database Access Clients (continued)
Information
Description