Installing the DataSource in an OSGi container

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.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 .

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here