Creating a SQL Server Data Connection

Connecting to a SQL Server database lets models in the current repository interact with the contents of that database.

This is the only type of connection compatible with T-SQL and Stored Procedure data sources.

Implementation:

  1. Switch to the Definition tab.
  2. Click .
  3. Switch to the Data Providers panel.
  4. If the KnowledgeKube Native category isn't already selected, do this now.
  5. Double-click Microsoft SQL Server. This will open the New Data Source Connection dialog.
  6. Enter a meaningful New Connection Name.
  7. (Optional) To restrict the connection to an authorised list of administrators, tick the Private Connection check box.
  8. (Optional) If you want the connection to request a password each time someone uses it to create a data source, tick the Connection Requires Authentication check box.
  9. (Optional) If you want the connection to fetch schema information (e.g. dbo.fieldname) in addition to the main data, tick the Include Connection Schema check box.
  10. Switch to the Provider Settings panel.
  11. Use the Server Name field to enter the name or IP address of the database server.

To save time, you can use the arrow next to the Server Name field to browse a list of servers previously used to create connections on the current repository.

  1. If the database server allows Windows authentication, select Use Windows Authentication as the login method; otherwise, select Use SQL Server Authentication and enter a valid User Name and Password.

You can ignore the Save My Password check box, as it serves no purpose here.

  1. Under the Connect to a Database heading, use the drop-down menu to select the name of the intended database.
  2. Click the Test Connection button. If the connection fails, check your settings and try again.
  3. After successfully testing the connection, click Save.