Reach MySQL (including HeatWave DB System) in an OCI private subnet through a PuTTY SSH tunnel, using your WordPress server as a jump host. Compared with OCI Bastion, plus a security checklist and troubleshooting.
PuTTY SSH Tunnel to a Private MySQL on OCI via a Jump Host Read Post »
Show points with latitude/longitude columns and boundaries with a GeoJSON custom map layer in Oracle Analytics (OAC and OAS), based on current documentation, and what changed since MapViewer and Map Builder.
Custom Map Layers in Oracle Analytics: Latitude/Longitude Columns and GeoJSON Read Post »
Normalize a mixed-format date column to yyyy-MM-dd with four Replace (regex) steps in the Oracle Analytics dataset editor, then convert it with Convert to Date. Tested examples included.
Normalizing Mixed Date Formats with Regular Expressions in Oracle Analytics Read Post »