Sharing Customer Exported Data

Some data export related batch processes support an option that streamlines the process by which customer extracted data may be routed to and shared with Oracle so it can be uploaded to Oracle's data lake for analytic purposes.

Note: This option is only available in a cloud installation.

Implementations may choose to share data with Oracle in addition to exporting data for their own purposes. For this use case, you could configure the batch control parameters as follows:

  • Define the file path / file location parameter with the appropriate configuration for extracting the data to your location. Refer to Indicating a File Path or File Name for more information.
  • The batch controls that support this include the Copy to Oracle batch parameter. Use this parameter to indicate that you want to also share the data with Oracle.

You may have a use case where you only want to extract the data to Oracle and you do not need to write this data to any extract location for your own use. For this use case, configure the batch control parameter for file path / file location with the mnemonic %ORACLE%. This mnemonic signals to the program to extract the data to the configured Oracle location only. There is no need to populate anything in the Copy to Oracle parameter, if applicable.

Note: Not every background process supports this mnemonic in the File Path / File Location. Any batch control that includes the Copy to Oracle parameter also supports copying only to Oracle using this mnemonic. There maybe be batch controls that only support extracting data to Oracle and not to your implementation's file location. This type of batch doesn't need the separate Copy to Oracle parameter and will indicate explicitly that it is used for sharing data with Oracle and therefore supports the %ORACLE% mnemonic in the file path.