Cisco Systems OL-24201-01 Camera Accessories User Manual


 
15-18
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 15 Managing System Operations and Configuration in the Monitoring & Report Viewer
Configuring Remote Database Settings
Step 1 From the Monitoring & Report Viewer, choose Monitoring Configuration > System Configuration >
Remote Database Settings.
The Remote Database Settings Page appears as described in Table 15-12.
Step 2 Click Submit to configure the remote database.
Note You can view the status of your export job in the Scheduler. See Viewing Scheduled Jobs,
page 15-11 for more information.
Note If there are two log collector servers that have been configured to export data to a remote database, only
one log collector server can export data to the remote database at a time. If a second log collector is
pointed to the same remote database, it can cause issues such as over-writing of existing entries in the
tables.
Table 15-12 Remote Database Settings Page
Option Description
Publish to Remote Database Check the check box for ACS to export data to the remote database periodically. By
default, ACS exports data to the remote database every 4 hours.
Server Enter the DNS name or the IP address of the remote database.
Port Enter the port number of the remote database.
Username Enter the username for remote database access.
Password Enter the password for remote database access.
Publish data every n hours Choose a time interval from the drop-down list box for ACS to export data at the
specified interval. Valid options are 1, 2, 4, 6, 8, 12, and 24 hours. The default
interval is 4 hours.
Database Type The type of remote database that you want to configure:
Click Microsoft Database radio button to configure a Microsoft database, and
enter the name of the remote database.
Click Oracle SID radio button to configure an Oracle database, and enter the
system identifier for the Oracle database.
Download Remote Database schema
files
Click this link to download the remote database schema files. The following two
schema files are downloaded:
acsview_microsoft_schema.sql
acsview_oracle_schema.sql