Installing the DataSource in an OSGi container - 6.5

Talend ESB Container Administration Guide

EnrichVersion
6.5
EnrichProdName
Talend Data Fabric
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
task
Administration and Monitoring
Design and Development
Installation and Upgrade
EnrichPlatform
Talend ESB

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:

  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 (6.5.1)

    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

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-derbyDerby10.8, 10.8.1.2tesb-datasource-derbyorg.talend.esb.datasource.derby.cfg
ds-h2H2 Engine1.3, 1.3.165tesb-datasource-h2org.talend.esb.datasource.h2.cfg
ds-mysqlMySQL5.1, 5.1.18tesb-datasource-mysqlorg.talend.esb.datasource.mysql.cfg
ds-oracleOracle11.2.0, 11.2.0.2.0tesb-datasource-oracleorg.talend.esb.datasource.oracle.cfg
ds-db2IBM DB29.7, 9.7tesb-datasource-db2org.talend.esb.datasource.db2.cfg
ds-sqlserverSQL Server2008R2, 3.0tesb-datasource-sqlserverorg.talend.esb.datasource.sqlserver.cfg
ds-postgresqlPostgreSQL9.2tesb-datasource-postgresqlorg.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 Guide.