A day in the life of an Oracle Applications Consultant

Saturday, June 12, 2004

Configuring the ADI client to connect to the database

This post outlines how to configure the ADI client software to connect to the database. It’s aimed at non-technical people and assumes that you have already configured the TNSNAMES.ora file.

Assumed TNSNAMES.ORA file settings

Typical TNSNAMES.ORA lines

ADI database connection settings

To get to the settings displayed below, from the ADI toolbar click on the signon button. In the Signon screen, on the bottom left hand side of the screen you should then click on the Define Basis button and configure your connection.

An example of how to configure your ADI client database connection

The name and description you give to the database connection can be user defined. The GWYUID and FNDNAM settings are consistent for most databases that you connect to and lastly, the connect string should be the same as the SID contained in the TNSNAMES.ORA