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:
Datasources View Mode Review
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.
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.
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.
Datasource view mode in the left menu has Actions (SQL Actions) and Tables panel by default.
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.
Define your action using SQL through the SQL Editor on the screen that opens, and click the CREATE button in the upper right.
You can view the action you created in the left menu. You can also edit, rename and delete the action you created later.
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.
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.
Click New Table via the drop-down menu.
On the Create a new table screen that opens, name your table and click the Next button.
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.
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 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.
There are 4 different Datasource types on the screen that opens. These Datasource types are;
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 updated
