Creating Avaloq Connection Objects

To make the communication between the Avaloq Agent solution and your Avaloq system possible, you need Connection objects. Connection objects store all the connection information and define the security protocol and corresponding credential information. You assign Avaloq Connection objects to your Avaloq Jobs.

After deploying the .jar file, a Connection object template called CONN.AVALOQAGENT.JDBCCONNECTION is available by default in Client 0 > Process Assembly > Explorer > TEMPLATE. You use this template to create the Connection objects that you need.

Creating JDBC Connection Objects

To Create a JDBC Connection Object

  1. Click Add Object in the toolbar and, on the Add Object dialog, select Connection.

  2. Enter and Name and, optionally a Title that describes the purpose of the object.

    Tip: Give the Connection object a name that helps you identify the database to which it should connect.

    The object definition pages open to Avaloq Connection.

  3. In the Connection section select your Database Type. Depending on the database, the Connection settings change.

    Keep the Free from Entry check box unchecked. The Host, Port and SID fields are displayed. The values you fill in will populate the read-only JDBC Connect String field in the following 12c format for Oracle:

    jdbc:oracle:thin:@//{host}:{port}/{service}

    In previous releases, there was a SID field in place of the Service Name field. In those releases, the JDBC Connect String field was populated in the Oracle 9i/10g/11g format: jdbc:oracle:thin:@{host}:{port}:{sid}. If you need to continue using the older format going forward, you can enter the JDBC connect string manually as described below.

  4. In the Login Data section, enter the user credentials of the Avaloq database. For information about how to create and configure this user in the Avaloq database, please refer to the official Avaloq product documentation.

  5. Save the object.

Creating Program Connection Objects

Create an AVALOQAGENT > AVALOQCONNECTION object in Client 0 as described in the Automic Automation documentation. Optionally create additional Connection objects that can be used for Job overrides in the Clients where you define jobs.

The Login field on the Attributes page is not used Automic Automation jobs of the Avaloq Agent.

Troubleshooting

For Oracle Databases

If you cannot connect to the Avaloq database after properly configuring the Connection object, make sure that the database in the Avaloq system is compatible with the provided Oracle-JDBC driver.

In case of incompatibilities, replace the Oracle-JDBC-jar ojdbc*.jar with the latest version.

See also: