SQL Server and Process Street integration | Workato

Market leaders run on Workato

Build Powerful Workflows, fast

Triggers

When this happens…

SQL Server

New row
New row in a table in SQL Server
New rows Batch
New batch of rows in a table in SQL Server
New rows via custom SQL Batch
New batch of rows via custom SQL in SQL Server
Scheduled query Batch
Scheduled query using custom SQL in SQL Server
New/updated row
New/updated row in a table in SQL Server
New/updated rows Batch
New/updated batch of rows in a table in SQL Server
New/updated rows via custom SQL Batch
New/updated batch of rows via custom SQL in SQL Server

Any other trigger you can think up

Actions

Do this…

SQL Server

Bulk load from an on-prem file
Bulk load rows into a table in SQL Server from an on-prem file
Delete rows Batch
Delete rows in a table in SQL Server
Execute stored procedure Batch
Execute stored procedure in SQL Server
Export query result
Export query result as a CSV file in SQL Server
Insert row
Insert row in a table in SQL Server
Insert rows Batch
Insert batch of rows in a table in SQL Server
Replicate schema
Replicate table schema in SQL Server
Run custom SQL Batch
Run custom SQL in SQL Server
Run long query using custom SQL
Run long query using custom SQL in SQL Server
Select rows Batch
Select rows in a table in SQL Server
Select rows using custom SQL Batch
Select rows using custom SQL in SQL Server
Replicate rows Batch
Replicate batch of rows to table in SQL Server
Get table schema
Get table schema for SQL Server
Update rows
Update rows in a table in SQL Server
Update rows Batch
Update batch of rows in a table in SQL Server
Upsert row
Upsert row in a table in SQL Server
Upsert rows Batch
Upsert batch of rows in a table in SQL Server

Any other action you can think up

Process Street

Assign to a task
Assign to a task in Process street public API
Create a data set record
Create a data set record in Process street public API
Delete a Webhook
Delete a Webhook in Process street public API
Create a Webhook
Create a Webhook in Process street public API
Create a workflow run
Create a workflow run in Process street public API
Delete a data set record
Delete a data set record in Process street public API
Delete a workflow run
Delete a workflow run in Process street public API
Get a data set record
Get a data set record in Process street public API
Get a task
Get a task in Process street public API
Get a workflow run
Get a workflow run in Process street public API
List all approvals
List all approvals in Process street public API
List data set records
List data set records in Process street public API
List data sets
List data sets in Process street public API
List all form field values
List all form field values in Process street public API
List all form field values in a task
List all form field values in a task in Process street public API
List all task assignees
List all task assignees in Process street public API
List all tasks
List all tasks in Process street public API
Find workflow runs
Find workflow runs in Process street public API
Unassign from a task
Unassign from a task in Process street public API
Undelete a workflow run
Undelete a workflow run in Process street public API
Update a data set record
Update a data set record in Process street public API
Update multiple form field values
Update multiple form field values in Process street public API
Update a task
Update a task in Process street public API
Update a workflow run
Update a workflow run in Process street public API

Any other action you can think up

One platform

Power
Agility
Speed
Innovation