Database Profile

Kalipso - Developing - Form - Database Connection Profiles - Database Profile

Whether you want to work online or offline, this is your starting point. A Database Connection Profile is how you tell Kalipso how he should access a remote database. There’s a default internal profile called “<Local>” that you should use to create Tables that only exist in Kalipso.

There are three kinds of profiles: Local (internal, not editable), Online and Offline.

By default the screen that appears when you click on add a new profile is this:

General

• Profile's Name - Name indication for the database connection profile. The name can not contain spaces.

• Type - Indication of how to connect to the database. The possible types are:

  • Dynamic

  • ODBC

  • OLE DB

  • SQLite

• Description - Open field for the description of the database profile. Kalipso does nothing with this information.

Depending on the type of connection to the database previously selected, the information requested in the window changes. Thus, choosing the "Dynamic" option, the application only prompts you to fill in the fields already indicated.

Following are the screens for the type of connection to the database. The first part (General) is the same for all types. From there, the data is different. Thus:

ODBC

Details

• ODBC Connection - Choose how to connect via ODBC. This can be through:

  • Excel Files

  • MS Access Database

• User - Username associated to the database.

• Password - Password associated to the database.

• Database - Name of the database.

On the right side of the "ODBC Connection" option are two icons. The first refreshes the data by consulting the selected file. The second opens the Windows option for managing ODBC connections.

Online

• Online Connection - Selecting and activating this checkbox indicates that the profile works online. For this purpose, you will have to choose a communication profile already created or edit an existing one (find out more here). It's mandatory having a profile created before adding a database profile working online. If you try the following message appears: "You don't have any TCP/IP Communication Profile"

• Communication Profile - After activating the online profile in the previous option, the communication profile already created appears immediately. You can change (if there is more than one) or edit the existing one.

• Server (IP/Name) - This field is automatically filled with the IP or name of the server associated with the selected communication profile.

• Port - This field is automatically filled with the port of the server associated with the selected communication profile.

OLE DB

Details

• Provider - Choose the data provider for the connection. This can be through:

  • Manual

  • SQL Server

According to the option previously selected, the system asks for each one:

Manual

• String Connection - Enter the connection string

SQL Server

• Server - Enter the server name

• Port - Enter the port number of the server. You can leave empty for default value

• Database - Name of the database.

• User - Username associated to the database.

• Password - Password associated to the database.

On the right side of the "ODBC Connection" option are two icons. The first refreshes the data by consulting the selected file. The second opens the Windows option for managing ODBC connections.

Online

• Online Connection - Selecting and activating this checkbox indicates that the profile works online. For this purpose, you will have to choose a communication profile already created or edit an existing one (find out more here). It's mandatory having a profile created before adding a database profile working online. If you try the following message appears: "You don't have any TCP/IP Communication Profile"

• Communication Profile - After activating the online profile in the previous option, the communication profile already created appears immediately. You can change (if there is more than one) or edit the existing one.

• Server (IP/Name) - This field is automatically filled with the IP or name of the server associated with the selected communication profile.

• Port - This field is automatically filled with the port of the server associated with the selected communication profile.

SQLite

Details

• Database´s Name - Enter the database name.

• Database file - Opens a window to associate the database file to be used.

• Password - Password for the database

The SQLite DB name cannot be "main" because that is the name of Kalipso's internal database.

Advanced Options

When selecting the type of connection to the ODBC or OLEDB database, an option below is available for advanced options. Clicking the following window appears:

Here the available options are configured for:

• Object's Prefix

• Ansi Quoted Identifiers Mode

• NoLock on Select

• Trim

You can access and read the purpose of each option in the window (as shown above).

You can set the properties of a Database Connection Profile in runtime with the “Set DB Profile Parameter” Action. To get the properties of a Database Connection Profile in runtime use the “Get DB Profile Parameter” Action.

You cannot switch a Database Connection Profile between online and offline in runtime.