Microsoft SQL Server

Creating a Microsoft SQL Server data source

1. In the Navigation Panel, go to Integrations > Catalog.

2. Use the Search box OR click the Databases filter to locate the data source.

3. Hover over the Microsoft SQL Server tile, and click Start. The MS SQL Server dialog is displayed, as shown below.
   Note: If the data source has already been used, a dialog is displayed in which you can select from one of the listed sources. Alternatively, create a new source by clicking Add a new source.

   

4. Enter your Server location.

5. Either enter your MS SQL Server port number or leave the default port number [1433] as-is.

6. Enter a Database name.

7. Enter a User name.

8. Enter a user password. [Optional]

9. Select/clear the Use SSL checkbox. By default, it is selected.

10. Select the Verify Server Certificate checkbox.

11. Click CONTINUE to open the Stream Query window.

To create a Microsoft SQL Server stream query, see Creating a Stream Query from a Database .