Local Databases

Use the Local Databases tab to create a database in Design Studio. Note that databases created in Design Studio are only available in Design Studio.

To make the database available both in Design Studio and on the server, the databases must be configured in the Management Console. See the following:

A list of created connections is shown in the left pane. Create new connections, remove connections, or change their order using the buttons under the list. The currently selected connection is configured in the "Local Databases" window. The field name, host, type, schema, username and password are mandatory and must be specified.

The different database types are defined in the Management Console and automatically distributed to Design Studio at startup. New database types must be created in the Management Console.

Option	Required	Description
Name	Yes	A name for uniquely identifying the database in Tungsten RPA. The name is used for internally referencing the database and it may only contain alphanumeric characters and underscores.
Host	Yes	The host name of the database server. This can be either an IP address or the fully qualified domain name, such as myhost.tungstenautomation.com. For custom non-default application ports, use host:port as the Host name.
Type	Yes	The type of database. The different types of databases are configured in Management Console and provided automatically at Design Studio startup.
Schema	Yes	The name of the schema or database. If the concepts of schema and database are equivalent (used interchangeably) by the database provider, specify the name of the schema in this field. Otherwise, specify the name of your database or use the default.
Username	Yes	The user name for the database. If you are using an Oracle database, you must enter both a username and a role. For example, if the username is "sys" and the role is "sysdba," you should enter "sys as sysdba" in the Username field.
Password	Yes	The password for the database.
Max Active Connections	Yes	The maximum number of concurrent connections to the database that Tungsten RPA (RoboServer or Design Studio) create. The connections are managed by a connection pool, which means that existing connection is reused before creating new connections.
Max Idle Connections	Yes	The maximum number of idle connections allowed. If more connections are created due to a heavy load, they are closed automatically when no longer needed.