Standard Data Extracts File Transfer
Oracle Utilities Opower uses a specific file format, naming convention, and file transfer method to send standard data extracts to utilities.
File Format: Each data extract file 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 contain the type of the extract, the utility code, and the date of creation using the following pattern:
opwr_[utility]_[extract]_[yyyymmdd].txt.gz
For example, a full customer extract created for "The Great Energy Company" on December 15, 2013, would be named:
opwr_gec_full_customer_20131215.txt.gz
File Transfer: Files are delivered to the Oracle Utilities Opower Secure File Transfer Protocol (SFTP) site on a weekly cadence. Files may contain either a full or incremental data set depending on the extract. 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.