Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Alma

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Alma
    3. Community Knowledge
    4. Analytics Evidence AGSA1 - SQL Access to Data (Closed)

    Analytics Evidence AGSA1 - SQL Access to Data (Closed)

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    Created By: IGeLU-ELUNA Analytics Working Group
    Created on: 11/20/2018



    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





    Report
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Analytics Evidence AGSA6 - Field naming consistency needed
      • Analytics Evidence BESA1 - Institution Anonymization in Network or Community Zone
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      Enhancements
      Content Type
      Documentation
      Product
      Alma
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved