SQL Select String Considerations - System Administration - On-Premises - English - Foundation 22.1 - OnBase - Essential - Premier - Standard - external - Standard - Premier - Essential

On-Premises System Administration

Platform
OnBase
Product
System Administration - On-Premises
Release
Foundation 22.1
License
Standard
Premier
Essential

SQL Select String functionality is no longer recommended and may be removed in a future release. It is strongly recommended that Unity Scripts be used instead of SQL Select Strings. In all cases where SQL Select Strings are used until port to Unity Scripts is possible, the following considerations are strongly recommended:

  • A read-only user account with the most restrictive privileges must be used for access to an external database.

  • SQL Views should be created in the external database, if supported. SQL Select Strings should be executable against these SQL Views only.