[O11y][Oracle] Lens Migration

[harnish-elastic]

Manually migrate Oracle visualizations to lens in kibana version 8.6.0.

Preparation of data for testing

• Use sample_event.json / setup live instance using docker / mock data using mock server to populate dashboards

Migration stats

Oracle Dashboards	Before Migration		After Migration
	Lens	Visualization	Lens	Visualization
[Metrics Oracle] Memory Metrics	0	11	11	0
[Metrics Oracle] Tablespace	0	4	4	0
[Metrics Oracle] System Statistics	0	8	8	0
[Metrics Oracle] Sysmetrics	0	15	15	0
[Metrics Oracle] Performance	0	15	15	0
[Metrics Oracle] Overview	0	13	13	0
	0	66	66	0

Dashboard : [Metrics Oracle] Memory Metrics

• Migrate 11 visualizations to the lens
  • [O11y][Oracle] Migrate Memory dashboard visualizations to lens in kibana 8.6.0 #5786

Dashboard : [Metrics Oracle] Tablespace

• Migrate 4 visualizations to the lens
  • [O11y][Oracle] Migrate Tablespace dashboard visualizations to lens in kibana 8.6.0 #5754

Dashboard : [Metrics Oracle] System Statistics

• Migrate 8 visualizations to the lens
  • [O11y][Oracle] Migrate System Statistics dashboard visualizations to kibana 8.6.0 #5815

Dashboard : [Metrics Oracle] Sysmetrics

• Migrate 15 visualizations to the lens
  • [O11y][Oracle] Migrate Sysmetrics dashboard visualizations to lens in kibana 8.6.0 #5757

Dashboard : [Metrics Oracle] Performance

• Migrate 15 visualizations to the lens
  • [O11y][Oracle] Migrate Performance dashboard visualizations to lens in kibana 8.6.0 #5758

Dashboard : [Metrics Oracle] Overview

• Migrate 13 visualizations to the lens
  • [O11y][Oracle] Migrate Overview dashboard visualizations to lens in kibana 8.6.0 #5817

Verification and Validation

• Verification of functionality remains the same after migration in kibana
• Verification of data count of after-migrated visualization with before-migrated visualization in kibana
• Verification of Dashboard are not distorted in supported kibana version (8.6.0)

Note

• The reason behind migrating visualizations from kibana version 8.3.0 to 8.6.0 is in TSVB the visualization is set to order by Custom which lens supports in 8.4.0. After that we found that for one visualization ([Metrics Oracle] System Statistics - Parse count - Total [Metrics Oracle]), we need ifelse property which is available in 8.6.0. Hence for migration we picked 8.6.0 kibana version so that we can achieve 100% migration for Oracle package.

Before migration:

After migration:

[harnish-elastic]

All PRs are approved and merged. Hence closing this issue!