About the Data Transfer Process

Transferring your data to Oracle Energy and Water generally involves the following phases:

In each phase, Oracle Energy and Water will work with you to integrate, validate, and approve each of these files. The files will contain the same columns, and will follow the same formatting and naming standards. The files will only differ in the number of customers included and the periods of time they cover.

Phase 1: Sample Historical File Integration

A sample historical data file based on the data specifications is sent to Oracle Energy and Water.

Oracle Energy and Water will share the data specifications with your technical team. Your team then generates a sample historical data file based on the specifications and sends it to Oracle Energy and Water. This sample file should allow Oracle Energy and Water to analyze and diagnose issues, and give feedback on how to provide an updated file. This process is repeated until a sample historical file passes diagnostic testing. It typically takes several rounds of sample file generation, analysis, and feedback to approve a sample historical file.

Phase 2: Full Historical File Integration

The process of generating, validating, and approving a full historical file begins after the sample file has passed validation.

After the sample file has passed validation, the process of generating, validating, and approving a full historical file can begin. This file needs to include actual production data for a specific timeframe. Full historical file approval typically requires several rounds of generation and validation. The approved historical data files will be loaded into the Oracle Energy and Water production application, and the data within it will be displayed in the Storm ERT user interface.

Phase 3: Incremental File Integration

Incremental files that include any new customer information and data recorded since the most recent record in the full historical file that was delivered are generated after the full historical data has been implemented.

After the full historical data has been implemented, your team will generate incremental files that include any new customer information and data recorded since the most recent record in the full historical file that was delivered. After the first set of incremental files are approved, your team will schedule an automated file transfer. During this transfer, your system will push ongoing incremental files to the Storm ERT cloud service.

Note:

The number of phases you need to follow may vary slightly depending on various factors such as how much data you have, how many resources are available to assist with the transfer, and so on.