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.

2. In the Application Type list, select DatabaseApps.

3. 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.

4. Click ADD. A message for successful addition of the application is displayed.

5. 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 or Oracle. 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.

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

The database application is configured.