Remote Online

Kalipso - Developing - Form - Database Connection Profiles - Tables - Remote Online

With an offline Profile you can import the structure of Tables or Views from an existing database into your Kalipso Project.

These Tables or Views will be considered by Kalipso as online Tables (Kalipso doesn’t have the concept of View). Online Tables in Kalipso means that the device has no database. It needs to have a TCP/IP connection to MIS Communicator established so that it can directly access a database on a server through ODBC, OLEDB or SQLite. In this case, there are no synchronization processes. Data is directly read from the server database and it’s directly written to it.

Before using this area the Communication profile to the database should be set up and running.

Having the communication profile selected in the left column (which should be one of the ones indicated above) you can then click on add tables.

Thus, the process for creating communication profiles with an online database follows these steps:

Step 1

The first time you click to add a table the following screen appears:

As you can see the fields are already filled because we have selected the communication profile on the left in the previous window. Although you can change the communication profile. If you want to list the System Tables from the selected database check the option in the bottom.

Then click "Next"

Step 2

In this step, you will have to choose the tables (or table) that you want to access.

In the table that appears, the tables associated with the database to which it was linked appear. It is enough to choose which of the tables you want to link.

In addition, you can also select the:

• Owner - Option to filter the database owner.

Then click "Next"

Step 3

After selecting the desired tables, in this step, the desired fields from each previously selected table are chosen. You can navigate with the arrow keys if you have several tables imported.

Then click "Next"

The data entered in all the fields are examples.

After selecting the fields to be associated, the process is completed. The tables and respective fields will appear available to be used in the project.

You can also use Storage Procedures. For that you can see more information here.