AWS S3 Payment data Integration

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:

  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 Electricity Payments for the Dataset Type
  5. Choose Target - Select either the Program-Level or Project-level optionThis will create one bucket for all of your payment data that will be used for verification. 
If you are integrating your mini-grid data, select the Project-level option. If you are integrating distributed assets (i.e. SHS) select the Program-level option. 

Note:
1. You can download the ELECTRICITY_PAYMENT.csv file by clicking the link 
2. Your IT team is to automatically push your payment data from your CRM 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.

Please note that manual uploads of the CSV file are not allowed


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 ELECTRICITY_PAYMENT.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 for each project.
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
TIMESTAMP
Datetime for the reading

Required
Format: YYYY-MM-DD HH24:MI:SS+00:00
Assumes UTC, use the timezone specification to adjust.
ID
Unique ID for the payment
Required
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
UTILITY_ID
Unique serial number of the Inverter system
CUSTOMER_ID
Unique for the customer
Required
CUSTOMER NAME
Name of payer
Required
TRANSACTION CHARGES
 
PAYMENT_SOURCE
 
 
REFERENCE_ID
Payment reference ID
PAYMENT_AMOUNT
 
Required
ACCOUNT_TYPE
 
 
STATUS
 
 
NOTES


LOCATION
Payment Currency




    • Related Articles

    • 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: Enabling the remote verification of ...
    • UPYA 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 ...
    • Data Analytics - Data Permissioning

      The Odyssey platform offers multiple ways to integrate and share 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 ...
    • Angaza 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 ...