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.