...
Creating the connection string
Most reporting systems use URL-like "connection strings" to connect to databases.
Postgres
| Code Block |
|---|
| title | connection string for postgres |
|---|
|
jdbc:postgresql://HOSTNAME:5432/dspace |
Oracle
| Code Block |
|---|
| title | connection string for oracle |
|---|
|
jdbc:oracle:thin:@//HOSTNAME:5432/dspace |
TODO
Creating reports
ODBC-based reporting tools work by running one or more SQL query against the underlying DSpace database. You can find some examples in
| Jira |
|---|
| server | DuraSpace JIRA |
|---|
| key | DS-1645 |
|---|
|
which illustrate the kinds of SQL joins that you'll be looking at using. Note the use of item.in_archive = 't' and item.withdrawn = 'f' to check whether the item has been deleted or withdrawn respectively. A diagram of the DSpace database schema is included in the
Storage Layer section of the DSpace documentation. The SQL itself is stored in database-specific subdirectories of
https://github.com/DSpace/DSpace/tree/master/dspace/etc...