In general,  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.

To use SQL queries, familiarize yourself with your underlying database. All SQL queries are issued by the following users:

If you run AR System  as one of these users without permission to access the database, you cannot issue the SQL query.

To access non- AR System  databases, use the database name as part of the SQL query syntax. For example, for Microsoft SQL Server database:

databaseName.owner.table
acme.ARAdmin.CUSTMR_INFO