A datasource provides information that a server can use to connect to a database or to an external data store. Datasource management is provided by the following feature in the WSO2 feature repository:
Name : WSO2 Carbon - datasource management feature
Identifier: org.wso2.carbon.datasource.feature.group
If datasource management capability is not included in your product by default, add it by installing the above feature, using the instructions given under the Feature Management section of this documentation.
With this feature, you can define any RDBMS datasource, which can be used to connect to a database/external data store, or you can define your own custom datasources. New datasources can be added to your product using the management console, which can be later edited and deleted for your product instance if required. Note that all datasources created using the management console are saved to the registry of your product.
Creating new datasources
Use the following steps to add a datasource:
- In the product management console, click Data Sources on the Configure tab.
- Click Add Data Source.
- Specify the required options for connecting to the database. The available options are based on the type of datasource you are creating:
When adding an RDBMS datasource, be sure to copy the JDBC driver JAR file for your database to <PRODUCT_HOME>/repository/components/lib.
After adding datasources, they will appear on the Data Sources page. You can edit and delete them as needed by clicking Edit or Delete.
You can view, edit, and delete the datasources in your product instance by clicking Data Sources on the Configure tab of the product management console. However, you cannot edit or delete the default <WSO2_CARBON_DB> datasource.