Prerequisites to the Monitoring Server - 8.0

Talend Installation Guide

Version
8.0
Language
English
Operating system
Windows
Subscription type
Subscription
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend LogServer
Talend MDM Server
Talend MDM Web UI
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
Last publication date
2022-10-30
Available in...

Data Fabric

Data Services Platform

ESB

MDM Platform

Real-Time Big Data Platform

The Monitoring Server requires a database engine to store Events data. The supported databases are listed in Compatible databases.

The following are the script files corresponding to the databases, run them to configure the database properly. You can find the SQL scripts in the <TalendESBPath>/add-ons/sam/db directory.

SQL script filename

Database

create.sql Apache Derby
create_mysql.sql MySQL
create_oracle.sql Oracle
create_sqlserver.sql SQL Server
create_h2.sql H2 Database Engine
create_db2.sql IBM DB2

Procedure

  1. Make sure your chosen database is installed properly and is accessible.
  2. Login with a user which has CREATE permissions.
  3. Run the init SQL script for the corresponding database from the table above.
    Tip: If the value of db.recreate property in the logserver.properties is set to true, the init SQL script will be executed automatically when starting the Monitoring Server. This is not recommended for any database except Apache Derby running in embedded mode.

Results

You will then find the EVENTS and EVENTS_CUSTOMINFO table have been created in your database.

Now, you can install the Monitoring server either in standalone or as a Feature in the Talend ESB Container.