Event Database Structure - 7.1

Talend ESB Infrastructure Services Configuration Guide

EnrichVersion
7.1
EnrichProdName
Talend Data Fabric
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
EnrichPlatform
Talend ESB
Talend Runtime
task
Design and Development
Installation and Upgrade

The Event Logging Database schema consists of two primary tables:

  • EVENTLOG

  • EVENTLOG_METADATA

For the complete list of Compatible Databases, see the Talend Installation and Upgrade Guide .

To create those tables, SQL scripts are provided to you for the supported databases.

  1. Make sure your chosen database is installed properly and is accessible.

  2. Log in with a user account with CREATE permissions and run the "init SQL" scripts for the corresponding database (see table below). There are two initial scripts for each database. The script with "_ind" suffix is used to create indexes in database.

    The script files for the corresponding databases are described in the following table. The SQL scripts can be found in the <TalendRuntimePath>/add-ons/event-logging/db directory.

    SQL script filename

    Database

    create.sql

    create_ind.sql

    Apache Derby

    create_mysql.sql

    create_mysql_ind.sql

    MySQL

    create_oracle.sql

    create_oracle_ind.sql

    Oracle

    create_sqlserver.sql

    create_sqlserver_ind.sql

    SQL Server

    create_h2.sql

    create_h2_ind.sql

    H2 Database Engine

    create_db2.sql

    create_db2_ind.sql

    IBM DB2

    create_postgresql.sql

    create_postgresql_ind.sql

    PostgreSQL

Once the scripts executed, the EVENTLOG and EVENTLOG_METADATA tables are created in your database. Below is the data structure of those tables:

For the EVENTLOG table:

Field Type
ID(Primary Key) BIGINT
EVENT_UUID CHAR(36)
CATEGORY varchar(255)
EVENT_TYPE varchar(255)
LOG_MESSAGE CLOB(2147483647)
SEVERITY varchar(255)
LOG_SOURCE varchar(4000)
AGENT_TIMESTAMP TIMESTAMP
SERVER_TIMESTAMP TIMESTAMP
LOG_TIMESTAMP TIMESTAMP
AUDIT char(1)
AGENT_ID varchar(255)
AUDIT_SEQUENCE_NO varchar(255)
SIGNED_LOG_MESSAGE BLOB(2147483647)
CORRELATION_ID varchar(255)
SUBJECT varchar(255)

For the EVENTLOG_METADATA table:

Field Type Description
ID(Primary Key) BIGINT Unique id of the CustomInfo
EVENT_ID BIGINT Relative EVENT's ID value
METADATA_TYPE varchar(255) Metadata type
METADATA_KEY varchar(255) Metadata key
METADATA_VALUE varchar(4000) Metadata value