Configure Settings via Connection String

  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.