Data Sources

Datasource mode

You can use various data sources while developing applications with Kuika. Due to its technical features, Kuika allows data connection via MSSQL DB, Swagger API, REST API and C#.

This training content consists of the following topics:

Datasources Module review.
Creating a new Datasource and Datasource Types

Open the Datasources module in the project you are working in Kuika.

On the screen that opens, you will be greeted by Managed DB, a default local database created by Kuika. Through Managed DB you can develop and publish your application without the need for a server for an additional database. The screen also shows the relationships between the database tables in Managed DB.

Through the left menu in the Datasources module, you can view the data sources, actions and tables in the application you have developed, add a new data source, a new action and a new table.

The Datasource panel in the left menu has Actions (SQL Actions) and Tables sub-tabs by default.

You can add SQL Actions to the application you developed. You can expand the Actions sub-tab to view the actions you have added. To add a new action to your application, hover over the Actions sub-tab. Click the + icon next to the Actions sub-tab.

You can create a New SQL Action or a NewFolder via the drop-down menu. If you want to create a new SQL Action under the Actions sub-tab, click New SQL Action. If you want to create a SQL Action under a new folder, click New Folder and create it by naming the folder.

Hover over the file you created. Click on the + icon next to the file. Click New SQL Action from the drop-down menu. From the Create a New Action screen, name the action and click Next .

Define the action using SQL through the SQL Editor on the screen that opens and click the CREATE button on the top 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 on the top 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 and click the Delete button.

Kuika provides you with the ability to quickly add a new. table to the data source. To add a table to the data source, hover over the Tables sub-tab. Click on the + icon next to the Tables sub-tab.

Click New Table via the drop-down menu.

On the Create a new table screen, name your table and click Next .

You can manually add table columns via the Add button by entering Column Name, Column Type, Required and Unique information on the screen that appears. You can get suggestions from Kuika AI assistant for the data types in the table. The only thing you need to do is to activate the Kuika AI Switch, enter the column name and press Tab. After completing the column insertion process, complete the table insertion process by clicking the CREATE button 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 over the table you want to edit. Click on the three dots icon next to the table. Click Edit from the drop-down menu.

Edit your table on the screen that opens and click the Update button on the top 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 and click the Delete button.