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



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 .

    • 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 ...
    • 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 ...
    • 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 ...
    • SparkMeter 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 ...
    • SteamaCo 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 ...