Migrating Archived Incidents and Audit logs from RightNow to ADW using AIDP

This white paper presents a practical architecture for retaining historical service data as part of a RightNow-to-Fusion migration. It covers transforming archived incident XML and audit-log exports into structured data, loading them into Autonomous Database with Oracle AI Data Platform, preserving related records and attachments, and building a searchable audit-history view using reference-data mappings and ADW transformations.

Design:

Processing of Archived Incidents:

The Archived Incident XML file is converted to below csv files to support child relationships in the xml file:

• incidents.csv — Main incident/case (scalar fields only)
• incident_threads.csv — One row per thread entry (notes/messages)
• incident_transactions.csv