All docs This doc

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Database Access RequirementCarbon Dashboard feature uses its datasource to persist the dashboard related information
Required/OptionalOptional
Default Datasource NameWSO2_DASHBOARD_DB
TablesDASHBOARD_RESOURCE
Schemas and Queries

https://github.com/wso2/carbon-dashboards/tree/master/features/org.wso2.carbon.dashboards.api.feature/src/main/resources/sql

Tested Database TypesH2, MySQL, Postgres


Business Rules 
Anchor
Business Rules
Business Rules

...

Database Access RequirementIdP client access the DB layer to persist the client id and the client secret of dynamic client registration
Required/OptionalMandatory for external IdP clientsclient
Default Datasource Name DB_AUTH_DB
TablesOAUTH_APPS
Schemas and Queries

https://github.com/wso2/carbon-analytics-common/blob/v6.0.52/components/authentication/org.wso2.carbon.analytics.idp.client/src/main/resources/queries.yaml

Tested Database TypesH2, MySQL, Oracle 11g


Permission  provider 
Anchor
Permission Provider
Permission Provider

...

Database Access RequirementThe Siddhi application and the dashbioard configured for the Distributed Message Tracer solution that is shipped with WSO2 SP by default access this database to both read and write data.
Required/OptionalOptional, default is in H2. This database is only needed when Distribution Message Tracing is enabled.
Default Datasource NameMessage_Tracing_DB
Tables SpanTable
Schemas and QueriesThis database uses Siddhi Queries to insert data. It reads data from TracingListGadget, TracingSearchGadget, TracingTimelineGadget


Tested Database Types H2, MySQL, Mssql, Oracle 11g, PostgresSQL