Page tree
Skip to end of metadata
Go to start of metadata

A hosted Library Data Platform (LDP) database is currently available for the reporting community.  It provides access to data extracted from folio-snapshot and is updated daily.  ERM and MARC/SRS data are not yet included.

To access the database using a web browser:

To access the database using a reporting tool such as Tableau:

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

For more information about using the database: https://github.com/folio-org/ldp/blob/master/USER_GUIDE.md

For query developers: Another database called ldp_query_dev 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/ldp-analytics/tree/master/testdata and updated occasionally.  To access this database, use the same settings as above, but change the database name to ldp_query_dev.

Connecting from MS Access:

Installing PostgreSQL drivers

First, you need to make sure your Windows machine has the right driver to connect to a PostgreSQL database. This is an ODBC driver that is tailored to PostgreSQL, and PostgreSQL shares ODBC drivers that can be installed a variety of ways.

  1. I recommend using the MSI (Microsoft Installer) version of the ODBC driver installer.
  2. On this page, scroll all the way down to find the latest versions of the driver.
  3. For each PostgreSQL version (e.g., 12.0.0), you'll see three files: a plain .zip file, then one that ends with x86 and another that ends with x64. The plain .zip contains a .exe file, but using this file doesn't seem to work well. I recommend using the x64 file if you have a 64-bit Windows machine and the x86 file if you have a 32-bit Windows machine.
  4. If you don't know if you have 32-bit or 64-bit Windows, go to your Windows settings and look for "About this PC". You should see something like "System type", which should say 32-bit or 64-bit. Most machines these days are 64-bit.
  5. Download the right .zip file, then extract the contents to get to the .msi file
  6. Run the .msi file to install the drivers

Creating an MS Access file and setting up the connection

  1. Open Access

  2. Create a new “Blank desktop database”

  3. Close the empty table that has been created by default.

  4. Click “External Data” in the top menu

  5. Under "New Data Source," expand "From Other Sources," then click “ODBC Database”

  6. Choose “Link to the data source by creating a linked table” and click “OK”

  7. In the “Select Data Source” window that opens, click the second tab found at the top of the window (“Machine Data Source”).
  8. Click "New..." to set up a new connection to the LDP public instance*
  9. Select "User Data Source"
  10. In the list of drivers that pops up, scroll down until you see the PostgreSQL drivers. Choose “PostgreSQL ANSI”. Click "Next >".
  11. Click "Finish."
  12. In the window that opens, enter the connection details from above, using the "host" information for the "Server" field. For Description, give the connection a name.
  13. Click "Test." If the connection is successful, click “Save.”
  14. In the next window that opens, click the “Select All” button on the right, click the “Save password” box so that it is checked, and click the “OK” button. (Note: if you choose to save the password, you may have to confirm this choice for every linked table.)

*Note: these instructions work for MS Access 2019. If they do not work for previous versions of MS Access, the MS Access 2016 instructions might work. In that version, you need to use the Windows ODBC administrator to set up the data connection outside of MS Access. I had trouble when I used the 64-bit version of the ODBC administrator to set up the data connection, so if you get an error with 64-bit, you might want to try the 32-bit version of the ODBC administrator.

Connecting from DBeaver:

  1. From the "Database" menu, select "New Database Connection"
  2. In the wizard that pops up, search for "PostgreSQL." Select it and click "Next >".
  3. Type in the connection details above for host, port, database, user, and password.
  4. Click on the SSL tab. Check the box next to "Use SSL." Using the "SSL mode" drop-down menu, select "require."
  5. Click Finish.
  6. The database connection should now appear in the left panel under the Database Navigator. Unless you changed the name, the connection will likely be named "PostgreSQL - ldp_snapshot."
  7. Expand the arrow to see the contents of the database.
    1. Under "Schemas", select "public"
    2. Under "public", select "Tables"
    3. Under "Tables", double click on a table name to see basic information about the table, including a tab that shows the data
  8. From the "SQL Editor" menu, select "New SQL Editor" to paste in and run an SQL query


  • No labels