Configure DatabaseApps

It allows you to configure database application to Automation Studio.

 

To configure a database application:

  1. In the Admin menu, click the  (Add Application) icon to add an application. The Add Application dialog box appears.

 

 

  1. In the Application Type list, select DatabaseApps.
  2. In the Application Name field, enter a desired name of the database application you want to add. The name must not contain any special character or space.
  3. Click ADD. A message for successful addition of the application is displayed.
  4. Close the displayed message and enter the following details in the Application Properties pane. Mandatory fields are highlighted in a red box.

 

Property Name

Usage

Details

DB Type

The type of database application configured. Supported types are:

  • SQL
  • Oracle
  • MySQL
  • Excel

Authentication Type(SQL)

The type of authentication configured in the SQL database. Appears when DB Type is set to SQL. Available options are:

  • SQL - system uses the SQL database pass
  • Windows - system automatically connects to the database application using system password.

DB Server

The server name where database is hosted for database storage and retrieval.

This information is fetched from the SQL Server Management Studio if DB Type is SQL.

This information is available in Oracle SQL Developer if DB Type is Oracle.

DB Port

The port number to connect to the database server.

DB Name

The name of the database created.

SID(Oracle)

The unique name of the Oracle database instance. Appears when DB Type is set to Oracle.

This information is available in Oracle SQL Developer.

Excel Directory Path (Example - D:\folder)

The path of the excel application saved on the system. For example, D:\folder.

Display

Application Description

A small description of the web application added.

Display Name

The  desired name of the application entered by the user. This is a mandatory field.

General

Application Name

Name of the application entered at the time of adding the application. It auto populates as per the name of the application entered while configuring the application.

Application Type

Type of the application selected at the time of adding the application. It auto populates as per the application type selected while configuring the application.

Misc

Is Application Tracked

Is applicable only for AssistEdge Engage.

Signifies if the application is tracked for time spent by Engage during the process execution. It used for activity tracking report and tracking time spent on each application in the execution dashboard reports. By default the check box is selected and can be edited.

Is multiInstance allowed

It has been decommissioned now.

It was applicable only for AssistEdge SE (until version 8.6) which is AssistEdge Engage now.

Signifies if multiple instances of SE (now Engage) processes can be initiated on a single user machine.

Reset

Is Reset Required

Signifies if the application reset needs to be done after each automation is executed. If it is not selected, the application does not reset.

Is Sequential Reset

Signifies if the application reset needs to be done one after other in no particular order. If it is selected, it is mandatory to have a Reset Process for that particular application created and used inside the application.

Sequential Launch/SignIn

Is Sequential SignIn

Signifies if signing in to the application is required by the automation process in a sequence in which the application is used in the process. If it is selected, it is mandatory to have a SignIn Process for that particular application created and used inside the application.

SignIn

SignIn

Signifies if sign in to the database application  is required.  Be default, it is set to True and can not be edited.

 

  1. Click the (Save Properties) icon to save the application.

The database application is configured.