SQL Database System Connection Configuration Overview

The following tasks are performed when configuring the Agentry Server to communicate over a SQL Database system connection. Certain tasks may or may not pertain to a particular implementation environment and you should perform a careful review of the application’s requirements and functionality before proceeding.

  1. Research and information gathering on the database with which the Agentry Server is to connect, including:
    • Database identifiers (e.g. ODBC System DSN names or Oracle Local Net Service Configuration Names)
    • Database login information for use by the Agentry Server
    • Back end user authentication needs of the application
    • Other relevant communications information for the back end system.
  2. Modifications to the Agentry Server’s Agentry.ini file, specifically the sections:
    • [System Connections]
    • [SQL-n]

    Make these modifications using SAP Control Center, rather than manually modifying the configuration file.

  3. Application-specific modifications to the Agentry Server’s SqlBe.ini configuration file.
  4. Application-specific additions or modifications to the query constants file, or the creation of additional constants files.