Database installation and initialization

This section describes database initialization.

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/sam/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_postgres.sql create_postgres_ind.sql	PostgreSQL

Once the scripts executed, the EVENTS and EVENTS_CUSTOMINFO tables are created in your database.