SQL database considerations
Consider the following issues when working directly with an SQL database:
- The AR System server typically has full administrator access to the database for reading and writing any data. AR System users have permissions to read and write specific data using an AR System client, and these permissions are managed by the AR System server. If users access the database directly through a database client, they are bypassing the AR System security model.
- BMC Remedy AR System stores some data in the database in formats that can cause third-party applications to become confused. For example, AR System date/time fields store values as timeticks, which are the number of seconds from 1 January 1970 at midnight until the current time. These numbers are stored as integer numbers, and typically need to be converted by the third-party application.
- All SQL commands are sent to the database server that holds the AR System database. To access databases that are external to this DB server, you must have the appropriate conduit installed and issue the SQL commands needed to use the conduit for your SELECT statement.