Installing the DataSource in an OSGi container - Cloud - 8.0

Talend ESB Container Administration Guide

Version
Cloud
8.0
Language
English
Product
Talend Cloud
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
Administration and Monitoring
Design and Development
Installation and Upgrade

About this task

Once the corresponding JDBC driver installed in the Talend Runtime Container, type in the following command on the console:

feature:install tesb-datasource-<Database>

The corresponding DataSource will be installed into the container and a configuration file named org.talend.esb.datasource.<Database>.cfg will be created in the <Talend.runtime.dir>/container/etc folder.

For example, to install the Derby DataSource:

Procedure

  1. Execute the following command:
    feature:install tesb-datasource-derby
  2. On the Talend Runtime Container console, execute the list command, you will find the installed bundles and configuration of Derby driver:
    [225] [Active] [       ] [ ] [60] Apache Derby 10.8 (10.8.1000002.1095077)
    [226] [Active] [Created] [ ] [60] Service Activity Monitoring :: Datasource-derby ()
    The org.talend.esb.datasource.derby.cfg configuration file has been created into the <Talend.runtime.dir>/container/etc folder. In this configuration file, the Database settings can be configured dynamically. For example, the default properties of org.talend.esb.datasource.derby.cfg are:
    datasource.server=localhost
    datasource.port=1527
    datasource.database=db
    datasource.createdatabase=create
    datasource.user=test
    datasource.password=test

Results

Here is a table with the DataSource information for other databases which work with the Talend Runtime Container:

DataSource Name

Database

Database, Driver Version

Feature

ConfigFile

ds-derby Derby 10.8, 10.8.1.2 tesb-datasource-derby org.talend.esb.datasource.derby.cfg
ds-h2 H2 Engine 1.3, 1.3.165 tesb-datasource-h2 org.talend.esb.datasource.h2.cfg
ds-mysql MySQL 5.x 5.1, 5.1.18 tesb-datasource-mysql org.talend.esb.datasource.mysql.cfg
ds-mysql8 MySQL 8.x 8.0, 8.0.27 tesb-datasource-mysql-8 org.talend.esb.datasource.mysql8.cfg
ds-oracle Oracle 11.2.0, 11.2.0.2.0 tesb-datasource-oracle org.talend.esb.datasource.oracle.cfg
ds-db2 IBM DB2 9.7, 9.7 tesb-datasource-db2 org.talend.esb.datasource.db2.cfg
ds-sqlserver SQL Server 2008R2, 3.0 tesb-datasource-sqlserver org.talend.esb.datasource.sqlserver.cfg
ds-postgresql PostgreSQL 9.2 tesb-datasource-postgresql org.talend.esb.datasource.postgresql.cfg
Note: Other driver versions may work but have not been tested. For more information on software prerequisites, see the Talend Installation and Upgrade Guide .