Data Acquisition - External

cdawson-stantec commented 4 years ago

name: Access RAMM Data about: Access the data and store it in DB

User Story

As a Dashboard developer I want to access up to date data So that I can use it in my app

Acceptance Criteria

[x] Get permission to access RAMM - DB, Credentials @petehilljnr to give Ramm details to @Ponting7
[x] Use FME to access the data through API
[ ] Store data (upload to Cloud environment)
[ ] Map data to meet data view for dashboard elements (from teams site storymap)
[ ] Develop back end for data analysis (from teams site storymap - may need separate issue)

Note

Questions still to be answered (Create issues later):

[ ] How much data do we access?
- [ ] Do we pull in aggregated data or aggregate it ourselves?
- [ ] What are the limitations of the RAMM API? Use FME for solution?? FME for notifications Swagger for Documentation - high level readme for dev team? @petehilljnr Log Service account credentials, and reporting. https://github.com/stanlytics/ramm-reporting/wiki/RAMM-API

http://example.tecstand.com/surfacing.html

Add an Assignee, Milestone and any relevant Labels.

cdawson-stantec commented 4 years ago

API into RAMM is working well, getting Data successfully. Pushing RAMM data into our own database is not working: Request in with IT to allow us access to the DB from our local PC's

cdawson-stantec commented 4 years ago

@magewire to push to front end @Ponting7 to update wiki with process (bullet points) by 5th June

stanlytics / ramm-reporting