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.