Analytics Database Refresh

Ex Libris Analytics enables you to run reports on library activities. You can use out-of-the-box reports that are provided by Ex Libris or you can create your own reports. Groups of reports can be displayed in dashboards that you customize. You can share reports and dashboards that you create with other users in your institution or in other institutions. These reports help you understand the activities that your library performs, which allows you to make informed decisions on how to run the library.

Analytics is built on Oracle Analytics Server (OAS). Every day, a full database refresh (also known as an ETL) takes place in Esploro Analytics. This process may take several hours to be completed. The time it takes to complete it depends on various factors, such as the changes made to the data.

Typically, the ETL starts in the evening and the data is available by the beginning of the following work day. This is the case for all data except for a few subject areas such as Titles and Benchmark.The staff user can see when the data was extracted from Esploro and when it was loaded to Esploro Analytics from the Analytics menu in Esploro. For example:

• Data available as of is the time that the load of the data to Esploro Analytics was completed.
• Data updated as of is the time the data was extracted from Esploro.

In the example above, the data was extracted on Dec. 21, 2019 at 10:00 PM and the load of this data to Esploro Analytics was completed on Dec. 22, 2019 at 06:28 AM.