Installing the DataSource in an OSGi container

Installing the DataSource in an OSGi container - 7.3

Talend ESB Container Administration Guide

Version

7.3

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

Last publication date

2023-09-13

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

Execute the following command:
```
feature:install tesb-datasource-derby
```
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.1, 5.1.18	tesb-datasource-mysql	org.talend.esb.datasource.mysql.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 .