Manually migrate Oracle visualizations to lens in kibana version 8.6.0.
Preparation of data for testing
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
Dashboard : [Metrics Oracle] Tablespace
Dashboard : [Metrics Oracle] System Statistics
Dashboard : [Metrics Oracle] Sysmetrics
Dashboard : [Metrics Oracle] Performance
Dashboard : [Metrics Oracle] Overview
Verification and Validation
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:

Manually migrate Oracle visualizations to lens in kibana version
8.6.0.Preparation of data for testing
Migration stats
Dashboard : [Metrics Oracle] Memory Metrics
Memorydashboard visualizations to lens in kibana 8.6.0 #5786Dashboard : [Metrics Oracle] Tablespace
Tablespacedashboard visualizations to lens in kibana 8.6.0 #5754Dashboard : [Metrics Oracle] System Statistics
System Statisticsdashboard visualizations to kibana 8.6.0 #5815Dashboard : [Metrics Oracle] Sysmetrics
Sysmetricsdashboard visualizations to lens in kibana 8.6.0 #5757Dashboard : [Metrics Oracle] Performance
Performancedashboard visualizations to lens in kibana 8.6.0 #5758Dashboard : [Metrics Oracle] Overview
Overviewdashboard visualizations to lens in kibana 8.6.0 #5817Verification and Validation
Note
8.3.0to8.6.0is in TSVB the visualization is set to order byCustomwhich lens supports in8.4.0. After that we found that for one visualization ([Metrics Oracle] System Statistics-Parse count - Total [Metrics Oracle]), we needifelseproperty which is available in8.6.0. Hence for migration we picked8.6.0kibana version so that we can achieve100%migration for Oracle package.Before migration:

After migration:
