BlueCielo Meridian Enterprise Server 2017 Administrator's Guide

Appendix B: Reporting from the repository

The Meridian Explorer repository can be a data source for your favorite reporting applications. You can configure reports against the repository using any application that supports SQL Server or Oracle as a data source, for example, Microsoft SQL Server Reporting Services or SAP Crystal Reports. You may also create reports from any application that functions as a web API client.

The repository database includes approximately 50 interrelated tables. To simplify reporting, the repository provides predefined views upon which you can base your reports:

• Area View – Includes all projects.

• DocumentView – Includes all properties for all document revisions. Filter on the IsLatestRevision column to exclude prior revisions.

• Folder View – Includes all folders.

• ObjectTagView – Includes all properties for all asset tag revisions. Filter on the IsLatestRevision column to exclude prior revisions.

We recommend that you create reports on these views, not on the source tables. If you have special requirements that cannot be easily met using these views, contact your BlueCielo Partner or BlueCielo ECM Solutions Professional Services for more specific views.

Meridian Enterprise Server provides a web API for external applications that need to query an Explorer repository for documents based on property filters with HTTP(S) web requests. The web API supports standard AJAX GET and POST requests, and the data is returned in JSON format. For more information about the web API, see Web API reference.