.png%3Falt%3Dmedia%26token%3D1a272b22-653e-4b09-918c-4e0629bae4d6)
.png%3Falt%3Dmedia%26token%3D1a272b22-653e-4b09-918c-4e0629bae4d6)
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.Datasources View Mode Review
- 2.Creating a new Datasource and Datasource Types
Open the Datasources view mode from within the project you are working on in Kuika.
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 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 view mode subpanels
Datasource view mode in the left menu has Actions (SQL Actions) and Tables panel by default.
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 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.
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.
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.
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 view mode new data table creation screen
On the Create a new table screen that opens, name your table and click the Next button.
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.
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.
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.
Create Data Source button in Datasource view
There are 4 different Datasource types on the screen that opens. These Datasource types are;
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 7d ago