Activities

• Connect to MSSQL
• Disconnect from MSSQL
• Add User Access to Database
• Backup Database
• Delete Row(s) from Table
• Insert Row(s) into Table
• Remove User Access from Database
• Restore Database
• Run Query
• Select Row(s) from Table13669666948
• 13669666948
• 13669666948
• 13669666948
• 13669666948
• 13669666948
• 13669666948
• 13669666948
• 13669666948
• 13669666948

Connect to MSSQL

This activity connects to a Microsoft SQL Host. The Output of this activity should be used as input for all Connection parameters used for activities placed under Microsoft SQL category.

...

• Authentication (combo box control) (type: string): the authentication method. For SQL Authentication, the Username and Password parameters are mandatory. For Windows authentication they are optional.
• Database (text box editor type) (type: string): the database name to connect to.
• Impersonation Full Username (text box editor type) (type: string): the domain and username required if impersonation is used for the Windows authentication. If empty, default credentials are used. E.g. 'fmrpdomain\demouserusername'
• Impersonation Password (password editor type) (type: string): the username password if impersonation is used for Windows Authentication. If left empty default credentials are used.
• Impersonation Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the sql server. (This parameter is used only when the user wants to send an encripted password from outside the workflow, for example Flowster Portal). In case of Windows Authentication, if the user that connects to the database is the logged in one, the field can remain empty.
  
• Instance (text box editor type) (type: string): the instance name to connect to. If there is an SQL server with no instance, this field should be empty. Examples:
  
  • localhost\sqlexpress - server with instance
  • localhost - server with no instance
• Password (password editor type) (type: string): the password for the username provided in Username parameter for SQL Authentication.
• Password Binding (text box editor type) (type: string): Bind to a variable containing the encrypted password for the username provided in Username parameter for SQL Authentication. (This parameter is used only when the user wants to send an encrypted password from outside the workflow, for example Flowster Portal). In case of Windows Authentication, if the user that connects to the database is the logged in one, the field can remain empty.
• Port (text box editor type) (type: int32): the port number for the SQL Server.
• Server Name (text box editor type) (type: string): the name or IP of the SQL Server to connect to. If it is a local SQL server, localhost is also accepted as a value.
• Username (text box editor type) (type: string): the SQL username for SQL Authentication. E.g 'demouser' which represents the Login name of type SQL Server authentication.

...