Copying Dashboards Using ADS Definitions

Oracle delivers ADS definitions to copy or migrate dashboards from one environment to another.

For information on using ADS, see Understanding ADS Projects.

The following table lists the ADS definitions:

ADS Definition

Description

PTSF_INSIGHTS_DBOARD_ATT

Defines the JSON files of a dashboard.

PTSF_INSIGHTS_DB_CREATE_ROLE

Defines the privileges assigned to a role with respect to a dashboard.

PTSF_INSIGHTS_DBOARD_DTL

Defines the deployed dashboards.

PTSF_INSIGHTS_DBOARD_ROLE_MAP

Defines the roles mapped to a dashboard.

PTSF_INSIGHTS_SYSDB

Defines the system monitoring dashboards that are imported and deployed.

The following table lists the records that are used in the ADS definitions for OpenSearch:

Record

Purpose

Merge Group

Custom Transform

Customization

Comments

PTSF_DBOARD_DTL

Stores the dashboard details.

Yes

No

No

The PTSF_KIB_ROLE record is it’s child. Has a relation to the PTSF_INSIGHTS_DBOARD_ATT dataset.

PTSF_DBOARD_ATT

Attachment table that stores the dashboard JSON files.

No

No

No

PTSF_KIB_ROLE

Maps dashboard to roles.

Yes

No

No

The customer's (target’s) privilege (Edit/View access) is preserved.

PTSF_KIBCR_ROLE

Stores the roles assigned with Create access in OpenSearch Dashboards.

No

No

No

PTSF_KIB_SYSDB

Stores the server metrics dashboard details.

No

No

No

Has a relation to the PTSF_INSIGHTS_DBOARD_ATT dataset.

Note: Copying of tile configuration using ADS requires purging of cache and restarting of the application server domain on the target environment.