SQL Server Writer Action Agent

Description

Allows a specified database and table to be updated with stream data at any point in the flow.

Configuration

To add the SQL Server Writer Action Agent to a stream, follow the steps below:

1. Ensure you have a use case open in the stream designer, this can be a new use case or an existing use case
2. From the toolbox on the left expand the Action Agents option and scroll down until you can see “SQL Server Writer”
   • You can also use the search in the header to find the agent quickly
3. Click and drag the SQL Server Writer Action Agent from the toolbox onto the canvas
4. Rename the action agent by clicking into the text area to the right of the icon
5. Save the Stream by clicking the save button in the action bar
6. Hover over the icon for the action agent until it turns orange and then double click to open the configuration page
   • You can optionally use the configure option on the action bar once you have selected the specific agent and then clicking this option
7. Configuration options
   • The Collection drop-down allows you to associate this agent with a specific collection. The selected option would be, by default, the same as the collection that was selected for the use case. If you do need to change it to another collection, select a different collection from the drop-down.
8. Server options
   • Specify the name of the server instance you would like to connect to
   • Add your User Name
   • If you would like to use Windows Authentication, leave the “Use SQL Server Authentication” checkbox unchecked, or
   • If you would like to use SQL Server Authentication, check the “Use SQL Server Authentication” box.
     • Specify your Password.
9. Database
   • Select the database you would like to write the data to
   • To create a new table, select the “Create New Table” checkbox and specify the name of the new table in the Table Name textbox
   • To write to an existing table select the table from the Table drop-down.
10. Click Apply on the action bar, and then save the stream using the save button

Limitations

• None at this time.

Release Notes

Version:	3.08
Released:	14-Aug-2018
Release Notes:	Added Checkbox in config settings to allow firing database triggers on insert (if defined).