DataConnect Data Extracts

Oracle Utilities DataConnect can be used to extract two types of data:

Master Data
(see Customer and Premise Data Extracts for more information)
- Service agreement, account, and person related information
- Service point and premise related information
- Service point / meter history related information
Billing Data

(see Billing Data Extracts for more information)

The extraction processes used for each type of data can be run to produce separate extracts or combined into one.

If individual flat files are preferred, the data can be correlated in external systems through service agreement and/or service point data that is included in each type of extract. All data extracts contain the following data elements that can be used for this correlation:

Service Point ID: The service point ID in Oracle Utilities Customer Care and Billing and/or
Service Agreement ID: The service agreement ID in Oracle Utilities Customer Care and Billing

External systems receiving data extracted from the Oracle Utilities DataConnect facilities can use these IDs to associate billing data to extracted master data.

If a single flat file is preferred, meaning an extract that contains billing data and master data in one export file, the Billing Data extraction process can be configured to retrieve the associated master data of the bills and place the information in the same row as the billing data.

Note: There is a version 1 and version 1+ for the DataConnect extracts. In the following pages where a system object such as a batch control or data area is noted the objects are listed as (v1/v1+). When only a single object is noted it applies to both v1 and v1+.