In WSO2 SP, there are datasources specific to each runtime (i.e., worker, editor, manager, and dashboard runtimes). The datasources of each runtime are defined in the <SP_HOME>/conf/<runtime>/deployment.yaml file. e.g., To configure a datasource in the worker runtime, the relevant configurations need to be added in the <SP_Home>/conf/worker/deployment.yaml file.
...
| Database Access Requirement | It gives the capability of creating the tables at the siddhi app runtime and access the existing tablesif a user defined carbon datasource or JNDI property in a siddhi app. Documentation can be found in https://wso2-extensions.github.io/siddhi-store-rdbms/api/4.0.15/ |
|---|---|
| Required/Optional | Optional |
| Default Datasource Name | No such default Datasource. User has to create the datasource in the Siddhi app |
| Tables | No such default tables. User has to define the tables |
| Schemas and Queries | Information about the default queries and schema: https://github.com/wso2-extensions/siddhi-store-rdbms/blob/v4.0.15/component/src/main/resources/rdbms-table-config.xml |
| Tested Database Types | H2, MySQL, Mssql, Oracle 11g, DB2, PostgreSQL |
...
| Database Access Requirement | IdP client access the DB layer to persist the client id and the client secret of dynamic client registration when External IdP Client is used. |
|---|---|
| Required/Optional | Mandatory for external IdP clients |
| Default Datasource Name | DB_AUTH_DB |
| Tables | OAUTH_APPS |
| Schemas and Queries | |
| Tested Database Types | H2 |
...