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.

A list of created connections is shown in the left pane. You can create new connections, remove connections, or change their order using the buttons below the list. The currently selected connection is configured in the right side of the "Local databases" window. The field name, host, type and schema 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 BizRobo!. 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 an IP address, or the fully qualified domain name (e.g. myhost.kapowtech.com).

Type Yes The type of database (e.g. Oracle). The different types of databases are configured in Management Console and provided automatically at Design Studio startup.
Schema Yes The name of the database schema (or catalog).
User Name No The user name for the database.
Password No The password for the database.
Max Active Connection Yes The maximum number of simultaneous connections to the database that BizRobo! (RoboServer or Design Studio) creates. The connections are managed by a connection pool, which means that existing connection is reused before creating new connections.
Max Idle Connection 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.

To test the current connection, click Test Connection.

Note This will only test the connection to the database; it will not test that you have the proper permissions in the database.

Connecting to Oracle: If you are using an Oracle database, In the Username field, you must enter 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.


Reference pattern using Database Mapping from the robot to the Database

0 out of 2 found this helpful



Article is closed for comments.