Database Connection Profiles
Kalipso - Developing - Form - Database Connection Profiles
Last updated
Kalipso - Developing - Form - Database Connection Profiles
Last updated
Kalipso lets you interact with either offline or online databases.
To access an existing database, Kalipso does by ODBC, OLE DB or SQLite. If you want, you can also create tables that will only exist in Kalipso. To work in online mode, you’ll need a TCP/IP Communication Profile. When working offline, Kalipso will use an SQLite database to support your structure and data.
Note that no matter how many profiles you have, there will only be one database on the device, therefore you may work with several remote databases but you cannot have two Tables with the same name, even from different Profiles.
To configure a communication profile, choose the option on the ribbon. There the following window appears:
As you can see, the window appears divided into two areas: Database connection profiles and Tables.
The section on "Database connection profiles" is where the profiles are created. You can access a list of profiles already created or create new ones. The icons on the right side of the table with the profiles allow:
Add - Adds a new Database connection profile to the project (this option opens a new window).
Edit - Edit a Database connection profile already created. In this case, you will have to select the profile already created in the list (this option opens a new window).
Copy - Copies a Database connection profile already created.
Paste - Paste a copied Database connection profile.
Delete - Deletes the Database connection profile selected in the list.
When you click on add a new database connection profile a new window appears that allows you to create it. This window is similar to the one that appears when editing an already created profile. Therefore, the process for both actions is described simultaneously. To access the description in more detail click on the following link:
The section on "Tables" is where the tables are created. You can access a list of tables already created or create new ones. The icons on the right side of the table with the profiles allow:
Add - Adds a new table to the project (this option opens a new window).
Edit - Edit a table already created. In this case, you will have to select the table already created in the list (this option opens a new window).
Rename - Renames a selected table in the list.
Copy - Copies a table already created.
Paste - Paste a copied table.
Duplicate - Duplicates a selected table in the list.
Delete - Deletes the table selected in the list.
The table presenting the tables already created shows their name and description.
When you click on add a new table a new window appears that allows you to create it. This window is similar to the one that appears when editing an already created table. Therefore, the process for both actions is described simultaneously. To access the description in more detail click on the following link:
The screen shown above has no data on database connections in the project. The following image shows example data from a communication profile, the database and links to specific tables (right side of the window).
As you can see, the profile created is a connection profile to an online database. The Local profile remains available and it is not possible to remove it. On the right side there are already associated tables and you can also see that there is a new tab on "Stored Procedures".
