Using relational databases with BMC Remedy AR System
BMC Remedy AR System can use any of the following database platforms :
- IBM DB2
- Microsoft SQL Server
- Oracle
Each type of relational database behaves differently with regard to search qualifications, wildcards, and so forth. The following topics describe these differences.
In general, BMC Remedy AR System hides the underlying database from the user. The AR System server interacts with the database and provides information to the user independent of the underlying database. All access through the API supplied with the product goes through this server and is independent of the database.
BMC Remedy AR System supports read access directly from the tables but does not support update access to any of the AR System tables directly through SQL. You must go through the AR System API for update access.
Other than AR System data, BMC Remedy AR System and its installation do not interact with or affect other data in the database. The only exception is data referenced by using the Direct SQL capability within workflow or by using a view form. For more information about this function, see the Developing section.
When you install BMC Remedy AR System over a relational database, an AR System database is created. By default, this database is named ARSystem, and the user ARAdmin is defined. You can choose other values during installation. This document refers to the default values, so if you changed them during installation, substitute your database and user names for ARSystem and ARAdmin. The characteristics of the AR System database vary depending on the type of underlying relational database.
You can perform any system administrator activity on the database or on any of the tables it contains. This includes performing regular backups, creating more tablespaces to be added to the AR System database, and adding more containers to tablespaces.
After the AR System database is created, BMC Remedy AR System creates a series of tables that form its data dictionary. See The AR System data dictionary.
For information about different behaviors and requirements for installing BMC Remedy AR System with specific databases, see Preparing your database in BMC Remedy ITSM Deployment documentation.
For information about configuration options and parameters associated with specific databases, see ar-cfg-or-ar-conf.