ERM

This project requires getting ERM (Electronic Resource Management) usage statistics from EBSCO as an Excel file on a regular schedule and importing this data into an AWS reporting database. The ERM Tableau dashboard 

-selectors want both dashboard and excel files

-would be ideal to have the data sent to us monthly 

-separate the files by material/resource type

-need to see how to 

-this is a file that comes out of the EBSCO Admin application, Usage Consolidation Reports, Title Usage Reports, Title Usage Details

-first 5 rows of title information that needs to be removed just delete the first 5 rows

Here are the specifics on the data that is needed from Ebsco once every six months:

1. From the ‘Usage Consolidation Reports’ we need ‘Title Usage Details’, and it should include ALL the options (all metric types, all resource types, all access types, and all access methods).
2. Also from the ‘Usage Consolidation Reports’ we need ‘Database Usage Reports’ , also with all options included (all metric types, and all database types). Screenshots for both are below.

Lib Pass

-AWS warehouse is already set up 

-set up a server