Streamlining Sensor Data Integration: Enhancing Telematics with AWS and SAP Digital Vehicle Hub

[abhishek05]

Introduction:

In the rapidly evolving world of connected vehicles, leveraging telematic data is crucial for improving operations, enhancing driver safety, and optimizing vehicle performance. Integrating various systems and databases can be complex and time-consuming, but with the right tools and strategies, it becomes an achievable goal. In this blog post, we will explore how the combination of AWS services and SAP Digital Vehicle Hub can simplify the process of enabling telematic data persistence, integrating Otonomo with Amazon Kinesis, and displaying sensor data on SAP's user interface of SAP Digital Vehicle Hub.

Enabling Telematic Data Persistence into an AWS Timeseries Database:

One of the key steps in harnessing the power of telematic data is its persistent storage for analysis and future use. By leveraging Amazon Timeseries Database, you can store and manage vast amounts of sensor data efficiently. This eliminates the need for manual intervention, allowing a seamless and automated transfer of telematic data from vehicles to the database.

Benefits:

Reduced implementation efforts: By leveraging Amazon Timeseries Database, the process of bringing sensor data from vehicles is simplified, reducing implementation efforts significantly.

Streamlined data transfer: The automated integration enables a streamlined and efficient transfer of data from vehicles to the timeseries database.

Cost-effective storage: Amazon Timeseries database offers cost-effective storage solutions, allowing you to handle large volumes of sensor data without breaking the bank.

Continuing Integration of Otonomo with Amazon Kinesis:

Integrating Otonomo, a leading automotive data services platform, with Amazon Kinesis provides a powerful solution for processing and streaming real-time vehicle data. Amazon Kinesis allows you to receive and process massive volumes of sensor data at high speed, ensuring timely and accurate insights.

Benefits:

Enhanced data processing: By integrating Otonomo with Amazon Kinesis, you can efficiently process and analyze vast amounts of sensor data, unlocking valuable insights for your operations.

Real-time analytics: Amazon Kinesis enables real-time data streaming, empowering you to make informed decisions and respond promptly to critical events.

Cost-effective scalability: With Amazon Kinesis, you can scale your data processing capabilities based on demand, ensuring a cost-effective solution that grows with your needs.

Enabling Persistence of Telematic Data Using SAP Digital Vehicle Hub Naming Conventions:

SAP Digital Vehicle Hub is a comprehensive platform for managing vehicle-related data. By leveraging its naming conventions, you can ensure consistent and standardized storage of telematic data in the Timeseries database. This enables easy access and retrieval of sensor data when needed, enhancing the overall functionality of your system.

Benefits:

Standardized data organization: Utilizing SAP Digital Vehicle Hub's naming conventions ensures consistent and organized storage of sensor data, simplifying data retrieval and management.

Seamless integration: The integration of SAP Digital Vehicle Hub with the Timeseries database enables a seamless flow of telematic data, reducing complexity and maintenance efforts.

Improved data accessibility: With standardized naming conventions, sensor data can be easily accessed and displayed across various applications and user interfaces.

Displaying Sensor Data on SAP Digital Vehicle Hub's User Interface:

To fully leverage the power of telematic data, it is crucial to present it in a user-friendly and intuitive manner. By displaying the sensor data from the Amazon Timeseries database directly into the vehicle master of SAP Digital Vehicle Hub, you can provide a comprehensive view of vehicle performance and enable informed decision-making.

Benefits:

Enhanced data visualization: Displaying sensor data on SAP Digital Vehicle Hub's user interface enables intuitive visualization, making it easier for users to interpret and analyze the information.

Improved operational insights: By presenting sensor data within the context of SAP Digital Vehicle Hub, you gain valuable insights into vehicle performance.

Technical Integration details:

Prerequisite: Subscriptions to AWS and Otonomo accounts are available.

The following services are required in AWS for the integration: Kinesis Data Stream, Kinesis Data Analytics, Amazon Timestream

Follow the below steps to set up the integration

• Configure the Streaming for fleet to send the data to AWS Kinesis from the Otonomo Dashboard

Configure Streaming for a Fleet in Otonomo Dashboard

• Create a data stream in AWS Kinesis

AWS Kinesis data stream overview section

• Create a Database and table in Amazon Timestream

Amazon TImeseries tables section

• Upload the JAR file provided by SAP Digital Vehicle Hub in S3. For JAR file please reach our us by creating a ticket using component LOD-DMO-DVH (this process could change in the future)

Upload the provided JAR file in S3 bucket

• Create a AWS Kinesis Analytics Application with the provided JAR file

      

Provide the path of the upload JAR file in S3 in configuration of streaming application

• Create Runtime properties for the application

Runtime Properties section for streaming application

• Once, the application is created you should be able to open the Apache Flink Dashboard and see a running job called “Preprocess and save to Timestream”

Job in Apache Flink Dashboard

•  Create a technical user in AWS with permission "AmazonTimestreamReadOnlyAccess" using IAM


• Create an access key for the technical user


• Create a destination in your BTP subaccount: DVH_AWS_IOT.
  See: Setting up destination for fetching telematics data from AWS for more information
  


• Create a vehicle using create vehicle API with same vin present in Otonomo fleet and “telematicsDataSource” as “02” (AWS Kinesis Timestream).

         

Creating a Vehicle using Postman

• Open View/Modify Vehicles App in IAM FLP. Search for the newly created vehicle and open it. Navigate to the “Indicator Chart” section, select the sensor for which you would like to view the data

Indicator Chart section in View/Modify Vehicles App

You should now be able to visualize the telematics data for vehicles present in your system. There also new features panned which should help you in visualize the complex data of the vehicle sensors in an easier way.

Please, share your feedback in the comments. If you have any questions, you can reach out to me or harshachaithanya.kethepalle

Also, make sure to follow the blog, we have exciting new features on the way, they will be shared in upcoming blogs.

Thanks!