SQL Connection (CONN)
SQL Connection objects contain the data that make the communication between Automic Automation for AIOps and an SQL database possible. Creating SQL Connection objects is usually an administrator's task. Designers use SQL Connection objects with the following two purposes:
- Define VARA objects that retrieve values from an SQL database
- Create SQL Jobs
To Define an SQL Connection Object
Database page
-
In the Connection section, specify the type of database and the connection data.
The system 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. For all other database types, enter the following:
-
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.
-
Database Name
Name of the database that should be used.
-
-
In the Login Data section specify:
-
Login Object
Optionally, enter the Login object that provides the login data.
-
Alternative User Name and Alternative Password
Alternative user and password in case the data delivered by the Login object fails.
-
- In the Connection Test section click the Test button to try the connection. A message displays the results of the test.
Advanced Settings page
In this page you can define additional parameters to access the database.
See also: