Setting up a remote database for view forms

If the database table is in a remote database, you must perform the required database configuration steps described in this section and use the correct table name syntax to access the remote table. For databases that require you to create a database link or proxy database, refer to your database documentation, and work with the database administrator to configure access to the remote database table.

To set up a remote database for view forms on an Oracle database

1. Set up a link between the  database and the Oracle database. In the database user's schema, create a view that accesses this link (by default, the user is ARADMIN), for example:
   CREATE VIEW view_name AS (SELECT * FROM ownername.tablename@link)
2. Create the view form on the view created in step 1.
3. To enable the support of multiple remote Oracle databases with different character sets, add the Oracle-Dblink-Character-Set parameter to your ar-cfg-or-ar-conf file.

To set up a remote database for view forms on a Microsoft SQL Server database

1. Create a link to the remote database, and give the ARAdmin user an account on the remote database or use the proper login credentials.
2. Turn on the Distributed Transaction Coordinator for the local and remote databases.
3. Specify the following server configuration setting in the ar-cfg-or-ar-conf file:
   SQL-Server-Set-ANSI-Defaults: T
   This setting enables the DB-Library connection that  uses to use ANSI-NULLs and ANSI warnings.
   The format for the table name is:
   LINKNAME.DATABASENAME.OWNER.TABLENAME