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 Hyland Software, Inc.'s 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.
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.
Any query created for direct access to the database should be run in a profiler by the customer DBA. That way, the DBA can 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 its construction and performance characteristics.