With Kuika, you can use various data sources while developing applications. Thanks to Kuika's technical features, you can establish data connections with sources such as MSSQL DB, Oracle, Swagger API, Rest API, C#, Bluetooth and AI Actions.
This training content consists of the following topics:
Datasources module review,
Creating new Datasource and Datasource types.
Examining the Datasources Module
To create a data source connection with artificial intelligence in the Datasources module:
After logging into the Kuika platform, open the project you will work with from the “Apps” screen.
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 an additional database server. The drop-down screen also shows the relationships between the database tables in Managed DB.
In the left menu, you can view the datasources, actions and tables in the application you have developed, add a new datasource, a new action and a new table.
The Datasource panel in the left menu has “Actions” and “Tables” sub-tabs by default.
Creating SQL Action
Click on the “+” icon next to the “Actions” heading in the left panel.
Select "New SQL Action” from the drop-down menu.
3. Write your SQL query via SQL Editor and click on the "CREATE ” button on the top right.
4. To create SQL queries with artificial intelligence, you can get suggestions from Kuika AI assistant by activating the “Generate with AI” switch.
5. You can view the action you created in the left panel, then edit, rename and delete it.
To edit the action, hover over the action and click on the three dots that appear.
Then select “Edit”.
On the screen that opens, you can edit the existing SQL queries and update them by clicking on the “Update” button on the top right.
Also, if you want to delete the action, click on the “Delete” option in the drop-down menu and complete the process.
Creating Select Action
Click on the “+” icon next to the “Actions” heading in the left panel.
Select “New Select Action” from the drop-down menu.
In the window that opens, name the query you want to create.
Click on the “+” icon to select the data source of the action.
After selecting the data source, you can define Fields, Filter and Sort Order fields according to your needs.
Creating Table
With Kuika you can quickly add a new table to the data source.
Click on the “+” icon next to the “Tables” heading in the left panel.
Select “New Table” from the drop-down menu.
In the “Create a New Table” screen, name the table and click the “Next” button.
Enter Column Name, Type, Required and Unique information and click the “ADD” button.
You can get suggestions for the data types in the table from the Kuika AI assistant by activating the “Kuika AI” button.
Then click on the “CREATE” button in the upper right corner to complete the table addition process.
By using the Work Offline switch in the upper right corner, you can enable your application to perform data transactions in the local database while offline and automatically synchronize with the server when the internet connection is restored.
You can view the table you created in the left panel, then edit, rename and delete it.
To edit the table, hover over the action and click on the three dots.
Then select “Edit”.
On the screen that opens, you can edit existing tables and update them by clicking on the “Update” button on the top right.
Also, if you want to delete the table, click on “Delete” in the drop-down menu and complete the process.
Creating a New Datasource and Datasource Types
You can create a new Datasource using various Datasource types during the application development process with Kuika.
Click on the “+” icon next to the “Sources” title.
On the screen that opens, there are seven different Datasource types.some text
