Appendix
B
SQL reference
This appendix includes the following topics:
■
About SQL export parameters
■
Using Oracle tables
■
Using MySQL tables
About SQL export parameters
Symantec Network Security can export event and incident data to two supported
SQL-compliant databases: Oracle 9
i
and MySQL 4.0. SuperUsers can enable this
functionality.
The Symantec Network Security software and the Symantec Network Security
7100 Series appliance employ a common core architecture that provides
detection, analysis, storage, and response functionality. Most procedures in this
section apply to both the 7100 Series appliance and the Symantec Network
Security 4.0 software. The 7100 Series appliance also provides additional
functionality that is unique to an appliance. Each section describes this
additional functionality in detail.
Setting up SQL export
To export to Oracle 9
i
or MySQL 4.0, you must establish export tables for the
incident and event databases, add the appropriate drivers manually, and
configure the SQL Export Parameters.
To set up SQL export
1
Establish export tables for the incident and event databases, referencing the
following files provided by Symantec Network Security:
■
For the Oracle database, use the following:
Summary of Contents for 10521146 - Network Security 7120
Page 1: ...Symantec Network Security Administration Guide...
Page 12: ...12 Contents Index...
Page 14: ...14...
Page 70: ...70...
Page 110: ...110 Populating the topology database Adding nodes and objects...
Page 158: ...158 Responding Managing flow alert rules...
Page 188: ...188...
Page 242: ...242 Reporting Playing recorded traffic...
Page 268: ...268 Managing log files Exporting data...
Page 316: ...316 Advanced configuration Configuring advanced parameters...
Page 318: ...318...
Page 338: ...338 SQL reference Using MySQL tables...
Page 366: ...366 Glossary...
Page 392: ...392 Index...