Microsoft SQL Server on-premises

The Microsoft SQL Server on-premises connector Service used to define a connection required for associated actions and start events. Examples include Salesforce and Box. Method of integration to cloud services, business applications and content stores. is used to create connections for Microsoft SQL Server on-premises actions A tool for building the processes, logic, and direction within workflows..

The following actions are available:

Use these actions in a workflow to create, delete, retrieve, and update data, and run stored procedures.

Create a Microsoft SQL Server on-premises connection

You can create connections from the Automate or Designer page.

Note: Your browser-stored credentials are accessed to create connections. Either clear credentials from browser memory or make sure the stored credentials are for the intended environment.

Permissions

Permissions enable you to manage access for other users to use, edit, and delete connections.

  Use

Edit

Delete

Assign
permissions

Owners

Users

Note: By default, users with administrator role will have the same rights as a Connection owner.

Create a Microsoft SQL Server on-premises data source

Use the Microsoft SQL Server on-premises data source to retrieve data from executing a stored procedure, and querying a SQL table or view.

Example:  To allow users to select a specific column value from a SQL table in a form, add a drop-down list of blog posts to the form using a Data lookup control A form control that allows users to select from a drop-down list of values that have been fetched from a third-party service.. The Data lookup control uses a Microsoft SQL Server on-premises - Query a SQL table data source to list the column values available from the Microsoft SQL Server on-premises connection in the drop-down.

You can create a data source to:

  • Execute a SQL stored procedure: list the results of running a stored procedure in your Microsoft SQL Server on-premises account.
  • Query a SQL table: list the results of running a SQL query on a table in your Microsoft SQL Server on-premises account.
  • Query a SQL view: list the results of running a SQL query on a view in your Microsoft SQL Server on-premises account.

Each data source is configured for a specific user. You can create as many data sources as you need.

Microsoft SQL Server on-premises data source fields

When you create a Microsoft SQL Server on-premises data source, you can configure some additional fields to specify which tables, views, and stored procedures the data source should retrieve.

Section

Field or selection

Description

Add new data source Operation Displays the operations available for the selected Connector. Depending on the selection the following fields are displayed:
  • Microsoft SQL Server on-premises - Execute a SQL stored procedure:
    • Stored Procedure: The stored procedure of SQL statements that you want to run.
    • Parameters: Click Add field to define the values of any required input parameters of the stored procedure.
    • Item Limit: The number of records to return.
  • Microsoft SQL Server on-premises - Query a SQL table:
    • Table: The SQL table you want to retrieve data from.
    • Item Limit: The number of records to return.
    • Sort by: The column name to use for sorting the retrieved records.
    • Sort order: Sort the retrieved records in ascending or descending order.
    • Add condition: Click Add condition to define which records to retrieve. This builds a SQL WHERE statement defining what records to retrieve.
      • When: The column selected for the condition.

      • Operator: The operator type of the conditional case statement, such as equals, does not equal, is empty, is not empty, contains, begins with, or ends with.

      • Value: The specific value searched for.

      • Summary: A short description of your condition.

      • For example, WHEN LastName equals Smith would retrieve all the records in that table where Smith is the value of the LastName column.

  • Microsoft SQL Server on-premises - Query a SQL view:
    • View: The SQL view you want to retrieve data from.
    • Item Limit: The number of records to return.
    • Sort by: The column name to use for sorting the retrieved records.
    • Sort order: Sort the retrieved records in ascending or descending order.
    • Add condition: Click Add condition to define which records to retrieve. This builds a SQL WHERE statement defining what records to retrieve.
      • When: The column selected for the condition.

      • Operator: The operator type of the conditional case statement, such as equals, does not equal, is empty, is not empty, contains, begins with, or ends with.

      • Value: The specific value searched for.

      • Summary: A short description of your condition.

      • For example, WHEN LastName equals Smith would retrieve all the records in that table where Smith is the value of the LastName column.