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
|create_h2.sql||H2 Database Engine|
- Make sure your chosen database is installed properly and is accessible.
- Login with a user which has CREATE permissions.
Run the init SQL script for the corresponding database from the table
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.
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.