1. Log in to the Kuika platform and open the project you’ll be working on from the Apps screen.
2. Open the Datasources module from the top menu. In this module, you can view the data sources and actions in your application under the Recently modified and Data sources tabs, search using the Search by name field, and add a new data source.
3. Click the Create a Database card at the top of the screen. This card allows you to connect to MS SQL Server, PostgreSQL, and Oracle databases.
4. From the Databases list that opens, select the MS SQL Server (Microsoft SQL Server database) option. You can use the ↑/↓ keys to navigate the list and the Enter key to make a selection.

5. Enter a name for your data source in the Name field (e.g., userguidemssql). The CREATE button remains disabled until a name is entered.
6. Click the CREATE button to complete the process. To cancel the operation, use the CANCEL button; to return to the database selection screen, use the < MS SQL Server link.

Note: You can also start the process of adding a new data source by clicking the + icon next to the Sources heading in the left panel.

After these steps, the MSSQL connection settings screen will open. At the top of the screen, you’ll find a back button (←), the data source name (with a pencil icon to edit the name), and the CREATE button to save the settings. You can enter the connection information using either the Enter fields or Connection string tabs in the Endpoint section.

To connect to an MSSQL database running locally, the MSSQL Server must be accessible over the internet.

In the Endpoint section, select the Enter fields tab and fill in the following fields.

01 Endpoint

Contains the server information Kuika will use to connect.

• Server (required): Enter the MSSQL database server address. Example: myServerAddress
• Database (required): Enter the name of the database you want to connect to. Example: myDataBase

02 Credentials

These are the credentials that are part of the connection string.

• User ID: Enter the username. Example: myUsername
• Password: Enter your password. Example: myPassword. You can show or hide the password using the eye icon.

03 Parameters

You can enter additional parameters to be added to the connection string into the table consisting of the Key and Value columns. When you fill in a row, a new blank row appears below it; you can delete an added row using the trash can icon.

Example parameters:

Key Value
Encrypt: true

Connection Timeout: 30

When you enter a parameter, you can see a preview of the connection string generated from the information you entered in the Resolves To field on the right.

The connection string generated using the example information above would look like this:

data source=myServerAddress;initial catalog=myDataBase;user id=myUsername;password=myPassword;Encrypt=true;Connection Timeout=30;

1. In the Endpoint section, select the Connection string tab.
2. Enter the connection string information for your MSSQL database in the Connection string (required) field. By default, the field appears with the following template: data source=;initial catalog=;user id=;password=

Example format:

data source=myServerAddress;initial catalog=myDataBase;user id=myUsername;password=myPassword;

Testing and Saving the Connection

1. Click the Test connection button in the Connection section on the right to verify that the connection works.
2. If the connection is successful, click the CREATE button in the upper-right corner to complete the process.

After saving, the tables in your database are automatically read and become available in Kuika.

1. Use TLS 1.2: Enable the TLS 1.2 protocol to secure data communication.
2. Port settings: Make sure that TCP port 1433, which SQL Server uses by default, is open on the server and firewall. If you are using a named instance, verify that the SQL Server Browser service is running and that UDP port 1434 is open.
3. Allow external IPs: Ensure that your server is open to connections from external IP addresses.
4. Test the connection string: Test your connection over an external network.
5. SQL Server Configuration Manager settings:
   
   • In the SQL Server Network Configuration > Protocols for [instance name] section, enable the TCP/IP protocol.
   • Restart the SQL Server service for the changes to take effect.

Viewing MSSQL Tables with an External Tool

To check the tables in the database you’re connecting to, you can use SQL Server Management Studio (SSMS) or Visual Studio Code with the MSSQL extension installed.

1. Download and install the tool.
2. Connect to the server: Complete the connection by entering the server name, database name, and your credentials.
3. Select the database: Open the desired database from the Databases section on the left.
4. View the tables: Expand the Tables folder and access the tables.
5. Run an SQL query:

SELECT * FROM [TableName];

Press the F5 key or click the Execute/Run button to run the query.

By following these steps, you can connect the MSSQL data source to your Kuika applications.

1. Download and install Azure Data Studio.
2. Connect to the server:
   
   • Click the Connect button.
   • Complete the connection by entering the server name, database name and your credentials.
3. Select the database:
   
   • Open the desired database from the “Databases” section on the left side.
4. View the tables:
   
   • Expand the “Tables” folder and access the tables.
5. Run a SQL query:

SELECT * FROM [TableName];

• Run the query by pressing the F5 key.

By following these steps you can connect the MSSQL data source to your Kuika applications.