Metadb has been adopted by many academic instititutions all over the world to provide data analytics services for their FOLIO data. This streaming data integration platform can use the FOLIO application server as its data source to provide access to near real-time data in a reporting database that is separate from the main transactional server. The Metadb software is open source and designed to transform data stored in JSON format into tables, columns, and fields in a database running Postgresql. The reporting database can be used to build and export data reports using common data analytics programming languages, such as SQL and Python. Metadb is the evolution of the LDP (Library Data Platform) software running on FOLIO reporting database systems.
Features of Metadb include:
open source software with active development, upgrades, and releases
extracts, transforms, and loads data from the source server continuously in near real time
most data elements from the data source are extracted into columns
transforms MARC data into an easy-to-use columnar format
adopted by several institutions in the FOLIO community