Database Logs (JDBC)

Java Database Connectivity (JDBC) is a standard API that enables applications to connect to and interact with relational databases. JDBC-based log ingestion allows Falcon LogScale Collector to directly query database tables and views to collect log data and audit trails.

This approach is particularly useful for ingesting audit logs, transaction records, and other structured data stored in databases. It eliminates the need for intermediate log files or export processes by reading directly from database tables.

Data Flow

The following diagram shows how database data flows through Log Collector's ingestion pipeline via JDBC:

flowchart LR A[Database Systems] --> B[JDBC Connector] B --> C[LogScale HTTP Endpoint] C --> D[Parser Pipeline] subgraph "Parser Types" D --> D1[SQL Result Parser] D --> D2[Database Audit Log Parser] D --> D3[Structured Data Parser] D --> D4[Database Error Log Parser] end D1 & D2 & D3 & D4 --> E[Compression] E --> F[Repository Storage]
flowchart LR A[Database Systems] --> B[JDBC Connector] B --> C[LogScale HTTP Endpoint] C --> D[Parser Pipeline] subgraph "Parser Types" D --> D1[SQL Result Parser] D --> D2[Database Audit Log Parser] D --> D3[Structured Data Parser] D --> D4[Database Error Log Parser] end D1 & D2 & D3 & D4 --> E[Compression] E --> F[Repository Storage]

LogScale's JDBC connector supports major database platforms including Oracle, SQL Server, MySQL, PostgreSQL, and DB2. It can execute scheduled queries to extract new records based on timestamp fields or incremental identifiers.