TABLE OF CONTENTS
- What is SODA?
- What is kind of data is in SODA?
- How can I access SODA?
- Can I access SODA database directly via SQL Queries?
- How often does the data in SODA get updated?
- Is there a detailed API/Database reference available for SODA?
What is SODA?
Scout Open Data Architecture (SODA) defines a standard, simplified and normalized data model for Scout data. Scout's core algorithm consumes raw Scout data, adds value to it and produces the output into SODA.
What is kind of data is in SODA?
All user interactions captured from the scouted applications and domains are stored in SODA. It essentially captures the user interaction stream where "a user interacts with an element present in a screen belonging to an application". All metadata associated with such interactions is available in a fully normalized database.
How can I access SODA?
Scout provides a REST API to access SODA data, it is flexible and supports all abstractions like date comparisons, filtering, pagination and limits.
Can I access SODA database directly via SQL Queries?
No, this is not the recommended approach to access SODA as the database is locked down in the server and no external access is allowed. SODA API provides support to perform all kinds of analytics via a simplified REST API interface.
How often does the data in SODA get updated?
SODA database is updated daily when the scout pipelines are executed at 6 am server time in most standard deployments to process the previous days data. There is a reconciliation job that runs every Tuesday night to catch up on any delayed data which may have flowed in from the customers data agent due to any network lag or connectivity issues.
Is there a detailed API/Database reference available for SODA?
A. Yes, we have detailed Rest API and Database table documentation available along with the SODA Documentation.