AWS S3 Meter metrics / Consumption data Integration

AWS S3 Meter metrics / Consumption data Integration

The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source.  Integrating this data makes it available for the following purposes:

  1.  Enabling the remote verification of connections required by some results-based financing programs.
    1.  To learn more about submitting connections and using remote verification, please refer to the Odyssey user guide.
  2. Enable analytics and visualizations of the data via Odyssey’s Analytics platform; providing insights into the operations across your mini-grid sites or solar home system installations; and joined with other data on the Odyssey platform.
  3. Sharing operating data with other users of the Odyssey platform, such as investors or financing program administrators.
    1. When you share, what you share, and who you share with, is entirely up to you and controllable via the Odyssey Project Sharing User Interface. 

AWS S3 Integration


Integration Set-Up

  1. Obtain credentials for accessing S3.  
    1. Send an email to support@odysseyenergsolutions.com directly with the financing facility or initiative you are participating in and request that your credentials be created.
    2. Once completed, you will have;                                     
  1. An Access Key ID
  2. A Secret Access Key
  3. Analytics access in Odyssey
       2. Set up and schedule your integration in the Odyssey platform
  1. Navigate to Analytics > Data Integrations
  2. On the API Data Integrations tab, click the Create button
  3. Complete the following data;
  1. Dataset Name
  2. Choose ODYSSEY as The Data Provider
  3. Choose AWS S3 as the Data Source
  4. Chose Meter Metrics for the Dataset Type
  5. Select the Project Level Integration as the target



Notes
Note:
1. You can download the METER_METRICS.csv file by clicking the link 
2. Your IT team is to automatically push your data from using the fields on the CSV file. 
3. Once set up, the integration will run daily, and ingest the file posted to the S3 Bucket specified.


ii) Posting Data to S3

The integration will run daily and ingest the data into the Odyssey Analytics platform.

The file must meet the following specifications to be ingested:
1. The file must be saved as a .csv format.
2. The file must be named METER_METRICS.csv as shown in the file path
3. The file must contain the header names included in the sample file (see file definition below).
4. You can use the AWS REST APIs to post data to the S3 bucket.
5. Once the file has been ingested, it will be moved to a sub-directory called Processed ; if there is an error processing the file it will be moved to a sub-directory called Error .

Field Name

Description

Notes

Example

METER_ID

Unique ID for the meter

Required – For remote verification, this must match the external_id value entered in the connections section of the project. Learn more about verification here: https://help.odysseyenergysolutions.com/portal/en/kb/articles/submit-remote-verifie#Complete_Remote_Verification

A200004567

Customer ID

Unique ID for the customer

Required

FN99998

CUSTOMER_NAME

Name of the customer who uses the meter.

Required

John Doe

FREQUENCY

Frequency of the AC power received by the meter

Not Required



METER_ENERGY_READING_KWH

Total cumulative energy consumption recorded at the reading interval

Not Required

20.456


METER_ENERGY_CONSUMPTION_KWH

Total energy consumption recorded over the reading interval

Required

0.004

METER_ENERGY_CONSUMPTION_COST

Total energy consumption cost recorded over the reading interval

Not Required

4.316

VOLTAGE_MIN


Minimum voltage recorded over the reading interval

Not Required

220.07

VOLTAGE_AVG


Average voltage recorded over the reading interval

Not Required

221.14

VOLTAGE_MAX


Maximum voltage recorded over the reading interval

Not Required

223.43

CURRENT_MAX

Maximum current recorded over the reading interval

Not Required

0.054

CURRENT_MIN

Minimum current recorded over the reading interval

Not Required

0.052

CURRENT_MAX

Maximum current recorded over the reading interval

Not Required

0.054

CURRENT_AVG

Average current recorded over the reading interval

Not Required

0.052

TRUE_POWER_AVG

Average true power over the reading interval

Not Required

10

APPARENT_POWER_AVG

Average power recorded over the reading interval

Not Required

10

POWER_FACTOR

Average power factor recorded over the reading interval

Not Required

0.993

METER_STATE

State of the meter at the time of this reading

Not Required

On or Off

COMMS_UPTIME

Communication uptime

Not Required

100

POWER_LIMIT

Meter power limit

Not Required

3

CREDIT DEBT

Customer balance debt

Not Required

2000

ADDRESS_FULL

Customer's full address

Not Required

Full address

LOCATION

Location of the Meter

Not Required


METER_TAGS

Meter tags

Not Required

Pole99, R, Y


    • Related Articles

    • AWS S3 Payment data Integration

      The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source. Integrating this data makes it available for the following purposes: Enabling the remote verification of ...
    • Calin Integration

      The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data, depending on the data source. Integrating this data makes it available for the following purposes: Enabling the remote verification of ...
    • Mojec Integration

      The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source. Integrating this data makes it available for the following purposes: Enabling the remote verification of ...
    • Chanels Integration

      The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source. Integrating this data makes it available for the following purposes: Enabling the remote verification of ...
    • Okra Integration

      The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source. Integrating this data makes it available for the following purposes: Enabling the remote verification of ...