Analytics Evidence AGSA1 - SQL Access to Data (Closed)

More than anything else users want SQL access to their raw data.

Issues

• Institutions own their data and have exclusive rights to access their data and use it as they see fit.
• Users should be able to export their raw data easily from Alma or Analytics for loading into institutional data warehouses. 
• Alma Analytics, powered by OBIEE, is a great tool but the star schema greatly limits how the subject areas can be combined. (AGSA 2)
• The data in Analytics is always at least 24 hours old.
• All of the data gathered in Alma is not migrated to Alma Analytics so users do not have access to all of their current data.
• Getting data added to Analytics from Alma is a time consuming process of NERS enhancement voting and Ideas Exchange voting and even then there is no guarantee that the data needed in Analytics will ever be mapped.
• The full MARC record is an example of this. Users do not have access to the full MARC record in Alma Analytics and they need it fully mapped.
• Users feel very strongly that they should have SQL access to all of their data in conjunction with Alma or Alma Analytics.

topic: general
priority: high
status: closed

Ex Libris Response at ELUNA 2018:

• Ex Libris maintains they will never provide users with SQL Access to their data.
• To get data out of Alma, users need to use the Alma publishing profiles and the Alma APIs.

From the IGeLU-ELUNA Analytics Working Group, Analytics Evidence Document

Please send questions or comments to the Analytics Working Group Listserv