Versions Compared

Old Version 1

changes.mady.by.user Megan Forbes

Saved on

compared with

New Version 2

changes.mady.by.user Megan Forbes

Saved on

Key

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

Jaspersoft Studio is desktop software for designing reports using data from CollectionSpace.  This guides This guide shows the process of connecting Jaspersoft Studio to the CollectionSpace database.  The steps are outlined in a screencast and further described in the this step-by-step guide.

A screencast of the process can also be viewed via the CollectionSpace Vimeo page.

Prerequisites

  1. Download Jaspersoft Studio (and the Java Development Kit, if necessary). Details are provided in the Getting Started with Jaspersoft Studio documentation.
  2. Configure the CollectionSpace server to allow direct access to the Postgresql database. A username and optionally a password are also needed to connect the Postgresql database.
  3. Determine the "JDBC URL" for use in the connection process. A JDBC URL has the form jdbc:postgresql://<hostname>:<port>/<database_name> where:
    1. <hostname> is the name of your CollectionSpace database server (typically the same as the CollectionSpace web server)
    2. <port> is the Postgresql database port, typically '5432'
    3. <database_name> is the name of the database where the CollectionSpace data is stored, typically 'nuxeo_default' unless this is an unusual CollectionSpace installation.

...