Database Connections

This section describes how to create a database in Design Studio. It should be noted that databases created in Design Studio are only available in Design Studio. In order to make the database available both in Design Studio and on the server the databases must be configured in the Management Console.

Configure database connections in Design Studio

In the left side of the window is a list of the created connections. 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 window.The fields name, host, type and schema are mandatory and must be specified.

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

Below is an in-depth description of the database fields:

Option

Required

Description

Name

Yes

A name for uniquely identifying the database in Kapow Katalyst. 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 concurrent connection that Kapow Katalyst (RoboServer or Design Studio) will create to the database. The connections are managed by a connection pool, which means that existing connection will be reused, before creating new connections.

Max Idle Connection

Yes

The maximum number of idle connections allowed. If more than this amount of connection have been created, due to heavy load they will automatically be closed when they are no longer needed.

Options descriptions


You can test the current connection by pressing the “Test Connection” button. 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, you need to enter a username and a role in the “Username” field. For example, if the username is “sys”, and the role is “sysdba”, you should enter “sys as sysdba” in the “Username” field.