1.1.2 Initiate Data Export

This topic describes the systematic instructions to initiate an export.

The user can export data from the SaaS tenancy to Object Storage with encryption.

To initiate data export:

1. Select the encryption profile from the following options:
   • OCI Vault: Available for BYOK customers.
   • Local Wallet: Default option for other customers.
2. Pass the list of required Schemas in the Initiate Export screen as given below
3. Initiate the export process and wait for the Export Status to be SUCCESSFUL..
4. Retrieve PAR URLs for:
   • Data dump files.
   • Encryption keys (ciphertext and AES-256 key).
5. Download the exported data using the provided PAR URLs.

   Figure 1-6 Initiate Data Export

   
   

   
   Description of "Figure 1-6 Initiate Data Export"

   
   

   If this is the first time performing the export, the user will receive a confirmation that the export has been successfully initiated.

   If an export has been run previously, the UI will display a summary of the last initiated export instead of starting a new one. In this case, the user can view the Data Export Status page, which shows details of the prior export, such as the timestamp, status, and PAR links.

   Figure 1-7 Initiate Data Export Status

   
   

   
   Description of "Figure 1-7 Initiate Data Export Status "

   
   

   Users can click on View URL to retrieve the Pre-Authenticated Request (PAR) URLs for the respective objects and dump files.

   Figure 1-8 PAR URL - objects and dump files

   
   

   
   Description of "Figure 1-8 PAR URL - objects and dump files"

   
   

   The PAR URLs generated for the dump files are time-sensitive and remain valid for approximately 2 hours from the time of generation. If a PAR URL expires before the file is downloaded, a new URL can be generated by clicking the Regenerate PAR URL button on the Data Export Status page.

   Figure 1-9 Regenerate PAR URL

   
   

   
   Description of "Figure 1-9 Regenerate PAR URL"

   
   

   Additionally, the exported dump files remain available in Object Storage for 7 days from the time of export. After this retention period, the files are automatically expired and removed, and the export process must be re-initiated to generate the files again. Users can also re-run the Initial Export at any time by clicking the Retry Export option available in the top-right corner of the page.

   Figure 1-10 Retry Export option

   
   

   

   
   

   Prerequisites Before Proceeding:

   Before proceeding further to configure ongoing replication (GoldenGate Extract), ensure the following:

   • Target PaaS environment is set up as per the Data Replication PaaS Setup Guide.
   • Oracle Autonomous Database exists in the target tenancy for importing the dump.
   • OCI GoldenGate deployment is configured in the SaaS tenancy.
   • Required network connectivity and IAM policies are in place.