Exports

Using the exports module you can export data to text or XML files; text files can be setup as either fixed-width or delimited data. Export files can be configured to generate a file for download (file system) or transmitted via SFTP. When the delivery method is setup for file system, the export file is encrypted and stored in the OPERA Cloud database for 30 days. The file generated is decrypted and delivered securely when you select to download or zip the file.

You can configure export files to generate a file for download (File System) or transmit using SFTP. When the delivery method is set up for File System, the export file is encrypted and stored in the OPERA Cloud database for 30 days. The file generated is decrypted and delivered securely when you select to download or zip the file.

Note:

Export files are generated with UTF-8 encoding unless otherwise specified in Managing Export Definitions.

The following export types exist in OPERA Cloud:

General: Used for all general or generic exports.
Back Office: Used for export of financial data to general ledger / ERP solutions. For more information, see Back Office Exports
Membership: Used to export membership and point data to airline reward programs. For more information, see Membership Exports
Country: Used for country-specific exports. For more information, see Oracle Hospitality Localization Center for Hotel

OPERA Cloud offers a number of pre-defined export templates that you can use as-is or customize to suit your needs. For more information, see General Export Template Catalogue

You can also configure component exports that reference different data sources and then combine the data from each component into a single export file.

Export File Configuration Workflow

The setup of an export involves the following steps:

Creating the export from a template or as-new. For more information, see Managing Exports
Setup data definitions for static variables. For more information, see Managing Export Definitions
Select fields and setup formula columns to output in header, detail and footer. For more information, see Managing Export Columns
Select an export delivery method. For more information, see Managing Export File Delivery

Export File Generation Methods

There are three methods for generating export files.

End of Day. When the GENERATE EXPORT NA DATA End of Day procedure is active, exports configured for End of Day processing are generated. For more information, see End of Day Procedures.
Scheduled. You can schedule exports to generate periodically. For more information, see Managing Scheduled Exports.
Manual. You can generate export files on an ad-hoc basis with the ability to enter runtime parameters. For more information, see Exporting a General or Back Office Data File

Export File Generation Process

The export file process typically consists of the following steps:

Runtime Parameters: For manually generated exports, you are prompted to input parameters to control the execution of the export generation. For example, the parameter screen can prompt for the start and end dates of the date range covered by the export. Not all exports use a parameter screen.
Pre-Processing: When export generation commences, a pre-processor (pre-export procedure) runs. This occurs only if a pre-processor is defined for the export. The procedure is specific to the export and populates views and sets variables and filters. Each export uses views that are supplied as standard with OPERA Cloud. Views are collections of data that are pulled from the many hundreds of OPERA Cloud database tables specifically for use in creating exports and reports.
Fetch Data: The export generation process pulls data from the views, applies parameters and filters (if defined in the export setup), and calculates formulas as appropriate. Exported data is stored in tables and can be viewed through the View Exports option. For more information, see Managing Export Results
Generate File: When the export is automatically generated during End of Day processing, the export file is generated with no user intervention required.
Post-Processing: A Post Export Procedure runs to perform clean-up after the export data is generated. This includes activities such as truncating temp tables and resetting variables that were set by a parameter form.

Exports with Sensitive Data

Any exports configured with the following field attributes are considered sensitive and are flagged accordingly:

CREDIT_CARD (PAN)
CC_NO (PAN)
PAY_REF
ID_NUMBER
PASSPORT
PPT_NO
BIRTH_DATE
BIRTHDAY
BIRTH_DAY
DATE_OF_BIRTH
DOCUMENT_NUMBER

The View Exports with Sensitive Datatask must be granted to roles in order to enable the View Exports action for exports flagged with sensitive data. The Personally Identifiable Information (PII) data is unmasked in the View Details screen for exports flagged with sensitive data.

Note:

The Sensitive Data check box will be unchecked when PII columns are removed from the export definition and no data files have been generated. Delete all generated export files to update the export definition and remove PII columns. For more information, see Managing Export Results

Parent topic: Miscellaneous