# 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.&lt;Database&gt;.cfg will be created in the &lt;Talend.runtime.dir&gt;/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 &lt;Talend.runtime.dir&gt;/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<br><br>Information noteImportant: Support for MySQL version 5 has been removed from Talend 8.0 R2026-04 onwards. | MySQL 5.x | 5.1, 5.1.44 | 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 |

Information noteNote: Other driver versions may work but have not been tested. For more information on software prerequisites, see the *Talend Installation and Upgrade Guide* .