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