User Guide > Objects > Alphabetical Listing > Database Tab

DB Tab

The DB tab is object typeAn individual object is provided for the individual activities: There are User, UserGroup, Notification, Cockpit, CodeTable, Documentation, Event, Agent, FileTransfer, Group, Include, Job, Workflow, Calendar, Login, Client, RemoteTaskManager, Schedule, Script, Server, Sync, Variable and TimeZone objects-specific and is only available in "Connection" objects of type "Database".

Object: Connection
Object class: System objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task

Object type (short name): CONN


Connection objects of type "Database" are required for SQL variables that read their values from the specified databaseA database is an organized collection of data including relevant data structures. when they are accessed. You can specify the Connection object which should be used in the variable tab.

Field/Element Description
Connection parameters

 

Database type

Type of database to which a connection should be established.

Example: Oracle

Possible database types:

  • Microsoft SQL Server
  • Oracle
  • IBM DB2
  • Sybase
  • MySQL
  • Informix
  • Oracle OCI (RAC)
  • SAP HANA
  • PostgreSQL
  • EXASOL
Server Name of the computer on which the database is available.
Port

Port number for computer access.

If you specify the value "0", the database agentA program that enables the de-centralized execution of processes (such as deployments) on target systems (computers or business solutions) or a service that provides connectivity to a target system (such as for databases or middleware). An agent is also an object type in the Automation Engine. [Formerly called "Executor."] See also: host itself attempts to find a suitable port.

Database Name of the database that should be used.
Login Data  
User Name of the database userIn the Automation Engine, a user is an instance of a User object, and generally the user is a specific person who works with Automic products. The User object is assigned a user ID and then a set of access rights to various parts of the Automation Engine system and product suite. These access rights come in the form of Automation Engine authorizations and privileges, Decision user roles and EventBase rights and ARA web application object rights. You can manage all these centrally in the ECC user management functions. See also, Unified user management..
Password Password of the database user.
Alternative Login Login object whose loginAn Automation Engine object type that stores account credentials used by agents on target systems. data (user, passwordA secret combination of characters for a Automation Engine user.) is used.
Test connection An attempt is made to establish a connection to the database with the specified parameters. Doing so requires a particular database agent (for variables) and a Login object to be selected via a separate dialog. A Message WindowA window that appears on the user interface and contains information, warning, and error messages. displays the result of this test connection.
Additional parameters  
Parameters

Name of the parameter that should additionally be used to access the database.

Example: MARSCONNECTION

Value

Value for the additional parameter.

Example for the parameter MARSCONNECTION: TRUE

The Connection String and Connection Properties tabs can be used to define how the additional parameter should be passed on.

 


Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support

Copyright © 2016 Automic Software GmbH