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.

Work Offline

The Kuika platform has a Work Offline option so that you can use the data tables offline. This option is available in two different modes:

1. With schema: Makes the database schema available offline, but without data.
2. With data: Includes the database schema along with data filtered according to the criteria you specify.

This feature is especially useful for mobile applications and allows you to optimize data synchronization processes. When creating a data table, you can select Work Offline mode according to your needs.

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.

         7. 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.