Datasources Module

Follow these steps to create a data source connection with artificial intelligence in the Datasources module:

1. Log in to the Kuika platform and open the project you will work with from the Apps screen.

2. The screen will display Managed DB, a default local database created by Kuika.

• Thanks to Managed DB, you can develop and publish your application without the need for an additional database server.
• The relationships between database tables are also shown on this screen.

3. In the left menu, you can view the data sources, actions and tables in your application and add a new datasource, action or table.

• The Datasource panel has Actions and Tables sub-tabs by default.

Creating a SQL Action

1. Click the + icon next to the Actions heading in the left panel.
2. Select New SQL Action from the drop-down menu.

3. Write your SQL query via SQL Editor and click the CREATE button on the top right.
4. To create a SQL query with artificial intelligence, you can get suggestions by activating the Generate with AI option.
5. The generated action can be viewed in the left panel, then edited, renamed or deleted.

• For editing: Hover over the action and use Edit.
• To update: Edit the SQL query and click the Update button.
• To delete: Use the Delete option in the drop-down menu.

Creating a Select Action

1. Click the + icon next to the Actions heading in the left panel.

2. Select New Select Action from the drop-down menu.
3. In the window that opens, give the action a name.
4. Click the + icon to select the data source.
5. Define Fields, Filter and Sort Order fields according to your needs.

Table Creation

With Kuika you can quickly add a new table to the data source.

1. Click the + icon next to the Tables heading in the left panel.

2. Select New Table from the drop-down menu.
3. In the Create a New Table screen, name the table and click Next.

4. Enter the column information:
   
   • Column Name
   • Type: Data Type
   • Required: Whether it is a mandatory field
   • Unique: Whether it is unique
5. Click the ADD button.
6. Click the CREATE button to complete the table insertion process.

You can activate the Kuika AI button to use artificial intelligence suggestions.

With the Work Offline switch, your application can perform data operations while offline and automatically synchronize with the server when an internet connection is restored.    

Offline Work and Data Filtering

When the Work Offline switch is turned on, you can perform data operations while offline. This feature allows you to control the transfer of data. In particular, the options With Schema or With Data are offered.

• With Schema: Allows transfer of the table schema.
• With Data: Allows the transfer of data.

Offline Table Properties:

• Criteria support has been added to filter the records to be transferred. This makes the management of the data set more efficient by ensuring that only the necessary data is transferred.
• This way, you can control data transfer while working offline and avoid unnecessary data transfer.

Editing and Deleting a Table

• To edit the table: Select the table in the left panel and click the ellipsis. You can update the existing table using the Edit option.‍
• To delete a table: Click Delete.

With Kuika, you can create new data sources using different data sources during the application development process.

1. Click on the + icon next to the Sources heading.
2. The following ten different data source types are available on the screen that opens:
   
   • MSSQL DB
   • PostgreSQL
   • Oracle
   • Swagger API
   • Rest API
   • C#
   • Bluetooth
   • AI Actions
   • MQTT
   • Google Blockly
3. Fill in the required information and click the CREATE button to create your data source.

With these steps you can manage your application's data connections by using the Kuika data sources module effectively.