SQL Select String Considerations - System Administration - Cloud - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - Premier - external - Standard - Essential - Premier - Standard - Essential

Cloud System Administration

Platform
OnBase
Product
System Administration - Cloud
Release
Foundation 24.1
License
Premier
Standard
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.