Kullanıcı Kılavuzu

MSSQL Data Source Add User Guide

MSSQL Data Source Add User Guide

MSSQL

MSSQL is one of the external data sources you can use on the Kuika platform. You can connect an existing MSSQL database as a data source to an application you develop in Kuika. In this guide, you will learn how to add a data source to your applications using MSSQL.

This training content consists of the following topics:

  • Adding a data source connection to your application with MSSQL
  • Configure MSSQL settings manually
  • Configure settings via Connection String
  • Additional solutions for the MSSQL configuration process
  • Steps to view MSSQL tables with Azure Data Studio

Add a Data Source Connection to Your Application with MSSQL

  1. Log in to the Kuika platform and open the project you will work with from the Apps screen.
  2. Open the Datasources module. In this module, you can view the data sources, actions and tables in your application and add a new data source.
  3. Add a new data source by clicking the + icon next to the Sources heading.
  1. Select the MSSQL DB option and set a name for your data source.
  2. Complete the process by clicking the CREATE button.

Configure MSSQL Settings Manually

After clicking the CREATE button, fill in the following fields on the screen that opens:

  • Server: Enter the MSSQL database server address. Example: Server=myServerAddress.
  • Database: Type the name of the database you want to connect to. Example: Database=myDataBase.
  • Authorization:
    • User Id: Enter the user name. Example: User Id=myUsername.
    • Password: Enter your password. Example: Password=myPassword.
  • Parameters: Specify additional parameters according to the needs of your application. Example:
Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;Encrypt=true;Connection Timeout=30;

Configure Settings via Connection String

  1. Activate the Use Connection String option.

MSSQL Server must be open to the Internet in order to connect to an MSSQL database you are working with locally.

  1. Enter the Connection String for the MSSQL database.
    • Example format:
Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;
  1. Check if the connection works with the Test button.
  2. If the connection is successful, click the CREATE button to complete the process.

Additional Solution Suggestions for MSSQL Configuration Process

  1. Use TLS 1.2: Enable the TLS 1.2 protocol to secure data communication.
  2. SQL Server Browser Settings: Leave port 1433 open on your server.
  3. Allow external IPs: Make sure your server is accessible to external IP addresses.
  4. Test Connection String: Test your connection over an external network.
  5. SQL Configuration Manager settings:
    • Enable “TCP/IP” and “Named Pipes” protocols in the ’Client Protocols” section.
    • Restart SQL Server to apply the changes.

Steps to View MSSQL Tables with Azure Data Studio

  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.

Other Related Content

No items found.

Glossary

No items found.

Alt Başlıklar