Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A hosted reporting database is currently available for the FOLIO community.  It provides access to data extracted from the FOLIO reference environment folio-releasesnapshot and is updated daily.

To access the database in a web browser using Metabase:

  • URL: http://glintcore.net:3000
  • User name: folio@glintcore.net
  • Password: (contact Sharon Beltaine, Reporting SIG convener)
  • Database: folio_releasesnapshot

To access the database using a client-side reporting tool such as DBeaver or Tableau Desktop:

  • Host: glintcore.net
  • Port: 5432
  • Database name: folio_releasesnapshot
  • User name: ldp
  • Password: (contact Sharon Beltaine, Reporting SIG convener)
  • SSL mode: require
  • JDBC: jdbc:postgresql://glintcore.net:5432/folio_releasesnapshot

For more information about using the database: https://github.com/folio-org/ldp/blob/master/doc/User_Guide.mdFor the reporting community: Another database called folio_snapshot is available to the FOLIO reporting community for testing with the very latest changes in FOLIO modules.  Its data are extracted from folio-snapshot which is a nightly snapshot of FOLIO modules as they are being developed.  This often contains newer or different data as compared to folio_release, but the data model may be less stable.  To access this database, use the same settings as above, but change the database name to folio_snapshot.

For query developers: Another database called folio_test_data is used by the FOLIO reporting community for query development and testing.  It houses a relatively static data set maintained at https://github.com/folio-org/folio-analytics/tree/master/testdata and updated occasionally.  To access this database, use the same settings as above, but change the database name to folio_test_data.

...