Skip to main content Skip to complementary content

Prerequisites to the Monitoring Server

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.
    Information noteNote: 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. However, 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!