Ingestion tool for quick data collection. Purpose of oralog is in loading various data based on database audit and diagnostics log to Hadoop, Elasticsearch, Amazon S3 or other tools for further processing and analyzing. oralog not just sends data but converts data to JSON format too. The following data are supported by oralog:
- Oracle Database Automatic Diagnostic Repository
- Oracle Database audit files in XML format including extended SQL_TEXT and SQL_BIND information (XSD schemas available at: 11.2, 12.2)
- more TODO
oralog can operate in different modes as
- Kafka Connect source connector
- Apache Kafka producer
- Amazon Kinesis producer
These instructions will get you a copy of the project up and running on your server.
Before using oralog please check that required Java8+ is installed with
echo "Checking Java version"
java -version
Build with
mvn install
Then run as root supplied install.sh passing target installation directory as script parameter. This directory will be mentioned hereinafter as A2_LOG_HOME. For example:
install.sh /opt/a2/oralog
This will create following directory structure under A2_LOG_HOME
bin - shell scripts
conf - configuration files
doc - doc files
lib - jar files
log - producer's log
Please look to ORALOG4ORAADR.md. For schema used for conversion of Oracle ADR xml to JSON please refer to adr.xsd
Please look to ORALOG4ORAAUD.md Mapping between JSON produced by oralog and Oracle RDBMS views available at ORA-AUDIT-SCHEMA.md For Oracle Database Audit XML schema please visit http://xmlns.oracle.com/oracleas/schema/dbserver_audittrail-11_2.xsd and http://xmlns.oracle.com/oracleas/schema/dbserver_audittrail-12_2.xsd
- Maven - Dependency Management
- PostgreSQL PGAudit support
- Linux auditd support
####0.7.0#### Initial release
- Aleksej Veremeev - Initial work - A2 Solutions
This project is licensed under the Apache License - see the LICENSE file for details