Prerequisites to the Monitoring Server - 7.0

Talend Data Fabric Installation Guide for Linux

EnrichVersion
7.0
EnrichProdName
Talend Data Fabric
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

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 Talend-ESB-VA.B.C/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.
    Note: 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. But 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.