Database installation and initialization - 8.0

Talend ESB Infrastructure Services Configuration Guide

Version
8.0
Language
English
Product
Talend Data Fabric
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend ESB
Talend Runtime
Content
Design and Development
Installation and Upgrade
Last publication date
2024-02-13

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.