Database Profile
Kalipso - Developing - Form - Database Connection Profiles - Database Profile
Last updated
Kalipso - Developing - Form - Database Connection Profiles - Database Profile
Last updated
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:
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.
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.
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.
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.
