Links
Comment on page

Explore Datasources mode

Learn Datasources with Kuika.
You can use various Datasources when developing applications with Kuika. Due to its technical features, Kuika enables data connection via MSSQL DB, Swagger API, REST API,and C#.
This training content consists of the following topics:
  1. 1.
    Datasources View Mode Review
  2. 2.
    Creating a new Datasource and Datasource Types

1. Datasources View Mode Review

Open the Datasources view mode from within the project you are working on in Kuika.
Datasources penceresi ekran görüntüsü
Datasources view mode
On the screen that opens, you will be greeted by ManageDB, a default local database created by Kuika. With ManageDB, you can develop and publish your application without the need for a server for an additional database. In addition, the relationships between database tables in ManageDB are also shown on the screen that opens.
Datasources penceresi sol menü ekran görüntüsü)
Datasources view mode left menu
You can view the datasources, actions and tables in the application you developed through the left menu in the Datasource view mode, and you can add a new data source, a new action and a new table.
Datasources penceresi alt sekmeler ekran görüntüsü
Datasources view mode subpanels
Datasource view mode in the left menu has Actions (SQL Actions) and Tables panel by default.
Datasources penceresi yeni Custom Action ekleme ekran görüntüsü
Adding new SQL Action in Datasources view mode
You can add SQL Actions to the application you have developed. You can expand the Actions panels to view the actions you have added. Hover over the Actions panel to add a new action to the application you are developing. Click the + icon next to the Actions panel.
Click the New SQL Action or New Folder via the drop-down menu. If you want to create a new SQL Action under the Actions panel, click New SQL Action. If you want to create SQL Action under a new folder, click New Folder and create your folder by naming it.
Hover over the folder you created with the cursor. Click the + icon next to the folder. Click New SQL Action from the drop-down menu. On the Create a new Action screen that opens, name your action and click the Next button.
 Datasources penceresi yeni Custom Action oluşturma ekranı ekran görüntüsü
Datasources view mode new SQL Action creation Screen
Define your action using SQL through the SQL Editor on the screen that opens, and click the CREATE button in the upper right.
Datasources penceresi yeni Custom Action ekleme SQL Editör ekran görüntüsü
Adding a new SQL Action to the Datasources view mode SQL Editor
You can view the action you created in the left menu. You can also edit, rename and delete the action you created later.
Custom Action menüsü ekran görüntüsü
SQL Action menu
To edit the action you have created, hover over the action you want to edit. Click on the three dots icon next to the action. Click Edit from the drop-down menu.
Custom Action düzenleme ekran görüntüsü
SQLAction edit
Edit the existing SQL queries in the SQL editor on the screen that opens, and click the Update button in the upper right. Also, if you want to delete the action you created, click Delete in the drop-down menu. Complete the verification process on the pop-up screen that opens and click the Delete button.
Kuika gives you the ability to quickly add a new table to the data source. Hover over the Tables panel to add a table to the data source. Click the + icon next to the Tables sub-panel.
Datasources view mode add new data table
Click New Table via the drop-down menu.
Datasources penceresi yeni veri tablosu oluşturma ekranı ekran görüntüsü
Datasources view mode new data table creation screen
On the Create a new table screen that opens, name your table and click the Next button.
Yeni veri tablosu bilgi giriş ekranı ekran görüntüsü
New data table information entry screen
On the screen that appears, you can manually add table columns by entering the Column Name, Column Type, Required, and Unique information and then clicking the Add button. For the data types in the table, you can get suggestions from the Kuika AI assistant. All you have to do is activate the Kuika AI switch and enter the Column name, then press the Tab key. After completing the column addition process, finalize the table addition by clicking the CREATE button located in the upper right corner.
You can view the table you created in the left menu. You can also edit, rename and delete the table you created later.
Veri tablosu menüsü ekran görüntüsü
Datatable menu
To edit the table you have created, hover your cursor over the table you want to edit. Click on the dot-dot-dot icon next to the table. Click Edit from the drop-down menu.
Edit datatable
Edit the table on the screen that opens and click the Update button in the upper right. Also, if you want to delete the table you created, click Delete in the drop-down menu. Complete the verification process on the pop-up screen that opens and click the Delete button.

2. Creating a new Datasource and Datasource Types

Datasource by using various Datasource types during the application development process.
Click the + icon opposite the Datasources heading to add a new data source to the application you are developing.
Datasource penceresinde “Create Datasource” butonu ekran görüntüsü
Create Data Source button in Datasource view
There are 4 different Datasource types on the screen that opens. These Datasource types are;
Yeni veri kaynağı tür seçim ekranı ekran görüntüsü)
New datasource type selection screen
Datasource type you selected on the screen that appears and click the CREATE button.
You can access the detailed training contents for the Datasource type information entry you have selected through the links below.
Last modified 20d ago