Per Hyland's Database Use policy only Insert, Update and Delete Statements violate the Agreement but direct SQL queries, while not the recommended approach, are allowed as long as they are Select Statements
Accessing the OnBase Database to Retrieve Data
OnBase provides an API that makes access to documents and their attributes straightforward. Through
the API, information required to interact with OnBase is accessible. This is the only recommended access
to the database.
Against our recommendation, direct SQL queries can be written if no other method is available for
capturing required information. The only allowable DML query that directly accesses an OnBase table is a
SELECT statement.
Caution: Queries that are not written with the index schemas and data distributions in mind
can become long-running queries that will consume substantial database server resources
and adversely affect the overall system.
All queries created for the direct access to the database should be run in a profiler by the customer DBA
to review the database optimizer access plan. This analysis needs to be performed against the live
database or a database of similar size with similar data distribution for all tables involved in the query.
The DBA should verify that the query is well formed and not I/O intensive. The data access plans should
be documented to provide a baseline in case database performance degrades at a later time.
If requested, Hyland Software will review a query to verify the construction and performance
characteristics.
