Web Audit Customer Data Extract File Transfer

Oracle Utilities Opower uses a specific file format, naming convention, and file transfer method to send Home Profile data extracts to utilities.

File Format: Each extract is provided in a separate tab-delimited file with a single header record. Files are compressed using gzip.

File Name Convention: Files transferred from Oracle Utilities will use the following naming convention:

web_audit_customer_answers_and_questions[timestamp].tsv.zip

File Transfer: Files are delivered to the Oracle UtilitiesOpower Secure File Transfer Protocol (SFTP) site on a weekly cadence. Files may contain either a full or incremental dataset depending on the agreed-upon integration. Files may also be encrypted for enhanced security. See Data Extract File Transfer for more information.

File Retention: Files stored on the Oracle Utilities SFTP site adhere to a standard file retention policy. See File Retention Policy for more information.