Database installation and initialization - 7.1

Talend ESB Infrastructure Services Configuration Guide

Version
7.1
Language
English (United States)
Product
Talend Data Fabric
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend ESB
Talend Runtime
Content
Design and Development
Installation and Upgrade

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.