Ver. 4.2.0 or later of Unifinity Studio can link the created database to a cloud database (UniBaaS DB).
By integrating with cloud databases, logic for sending and receiving data to and from cloud databases can be automatically generated, and data can be stored in the same cloud database from multiple applications.
Cloud Database (UniBaaS DB)
One of Unifinity's services. It is a schema-less database that resides in the cloud, allowing data to be registered with any schema. Because it resides in the cloud, the device must be connected to the Internet for the app to send and receive data to and from the cloud database.
A separate contract is required to use the cloud database. Please contact our sales department for details.
Cloud Linkage
To link to a cloud database, display the table that has been designed in DB Design and select "Cloud Linkage" in the Properties area.
| item name | Description. |
|---|---|
|
Linked ID |
If the table is linked to a cloud database, the ID of the linked database is displayed. |
|
name |
If the table is linked to a cloud database and a name has been set for the linked database, the name will be displayed. |
|
Add linkage |
Displays a dialog for linking with the cloud database. Details are described below. |
|
logic generation |
Automatic generation of processing design files and logic for sending stored data to and receiving data from cloud databases. If it has already been generated, it will be overwritten. If the table is not linked to a cloud database, logic generation cannot be performed. |
|
Disengage the linkage |
Disengage the table from the cloud database. |
Cloud Linkage Settings
[Clicking the "Add Linkage" button displays the Cloud Linkage Settings dialog.
| item name | Description. |
|---|---|
|
endpoint |
Enter the endpoint for the cloud database. If a contract for the use of a cloud database is in place, it will be automatically populated. For the latest information5. "Data Sources" tabYou can check it at |
|
token |
Enter a token to access the cloud database. If a contract for the use of a cloud database is in place, it will be automatically populated. For the latest information5. "Data Sources" tabYou can check it at |
[Contents of the "Create New Database" tab
Select to create a new database in the cloud database.
| item name | Description. |
|---|---|
|
name |
Enter the name of the database to be created. The name is used to manage the cloud database. It appears in the database list. |
|
Create a database |
A database with the entered name will be created in the cloud database. |
[Contents of the "Select Existing Database" tab
Select this option if you wish to link to a database that has already been created in a cloud database.
| item name | Description. |
|---|---|
|
Load the database list |
Load the database list from the cloud database. From the loaded databases, select the database to be linked. Right-click to delete. Once deleted, the database will no longer be available to other applications. |
|
Work with selected databases |
Link with the database selected in the database list. |
Items that are automatically added after the linkage
After linking with the cloud database, the following items will be added automatically
| Field Name |
Description. |
|---|---|
|
_id |
When data is newly registered in the cloud database, the ID numbered on the cloud database side is stored. |
| flg | Indicates how data is sent to the cloud database. Data with "1" recorded is "new addition" if the _id is blank, and "update" if the _id is not blank. Data with "2" recorded will be "deleted". |
How to use the generated logic
The following logic for sending and receiving data to and from the cloud database is automatically generated when linking to the cloud database or when the [Generate Logic] button is clicked.
| logic name (programming language) |
Description. |
|---|---|
|
user-configurable logic |
Logic that sets the behavior of the logic. The next section will provide more details. |
| generic logic |
Logic that describes common processes referenced by the write/read logic. No editing is required. |
| Writing Logic |
Set this logic to write data edited in the Unifinity application, such as at the press of a button, to the cloud database. Data with a 1 in the "Send Flag" of the linked table will be updated to the cloud database, and data with a 2 will be deleted from the cloud database. Edit this logic if you wish to do your own processing when writing. |
| read-only logic |
Set this logic to retrieve the latest data from the cloud database when a button is pressed. Edit this logic if you wish to do your own processing on read-in. |
How to set up user configuration logic
In the user configuration logic, there are items colored yellow as shown in the figure below.
Select each item and edit the content as needed.
If not set, some items will be marked in red to indicate an error. If you do not use it, delete it.
If you have added or deleted items to the linked tables after generating the logic, re-generate the logic or review the settings related to "fields" in the user setup logic.
Supplemental] Settings for running cloud-connected apps in Unifinity Studio
The process automatically generated by cloud integration uses the access information to the cloud database delivered from UniBaaS to perform communication processes such as sending and receiving data.
When using the cloud integration process from a debug run in Unifinity Studio, please check the "UniBaaS authentication before debugging" checkbox in the [Preferences] tab of the Properties.
For more information on how to use the trial, please refer to theprocedurefor more information.