Connection Object (CONN)

This topic describes how to define R3 and SQL Connection objects. You need them to provide the parameters that establish the connection between certain solutions and the Automation Engine, R3 for RA solutions and jobs as well as for SAP agents and SQL that allow VARA objects to retrieve values from an SQL database.

Object Definition

The Connection objects of Rapid Automation solutions differ from the standard ones provided with the Automation Engine. For Rapid Automation agent documentation, see the Automic Hosted Documentation.

A Connection definition is made up of the following pages:

This topic provides the following information:

SQL Connection Objects

You need SQL Connection objects when you define VARA objects that retrieve values from an SQL database.

To Define an SQL Connection Object

ClosedDatabase Page

  1. In the Connection section you specify the type of database and the connection data.

    Automic supports multiple database types. If you do not find yours in the Database Type dropdown list, select Generic JDBC and enter the Connection String as indicated by your provider as shown below.

    For all other database types in the dropdown list the following must be specified:

    1. Server:Port

      Name of the computer on which the database is available and the port number.

      If you specify Port 0 the database agent itself attempts to find a suitable port.

    2. Database Name

      Name of the database that should be used.

  2. In the Login Data section specify:

    Field Description
    Login Object Optionally, enter the Login Object (LOGIN) that provides the login data (client, user, password).
    Alternative User Name Alternative user in case the data delivered by the Login object fails.
    Alternative Password Alternative password in case the data delivered by the Login object fails.
  3. In the Connection Test section click the Test button to try the connection.

    A message displays the results of the test.

ClosedAdvanced Settings Page

In this page you can define additional parameters to access the database: