Microsoft Dynamics 365 and Redshift integrations and automations

Do everything in one place

Customize your Microsoft Dynamics 365 and Redshift integration with the following triggers and actions.

Triggers

When this happens…

Microsoft Dynamics 365

Export new records
Export new records in Microsoft Dynamics 365
Export new/updated records
Export new/updated records in Microsoft Dynamics 365
Deleted object
Deleted object in Microsoft Dynamics 365
Monitor changes in entities
Monitor all changes in entities in Microsoft Dynamics 365
Monitor changes in entities Batch
Monitor all changes in entities in Microsoft Dynamics 365
New object
New object in Microsoft Dynamics 365
New or updated object (batch) Batch
New or updated object (batch) in Microsoft Dynamics 365
New or updated object
New or updated object in Microsoft Dynamics 365
New object Real-time
New object in Microsoft Dynamics 365
Scheduled object search Batch
Scheduled object search in Microsoft Dynamics 365
New/updated object Real-time
New/updated object in Microsoft Dynamics 365

Any other trigger you can think up

Redshift

New row
New row in a table in Redshift
New rows Batch
New batch of rows in a table in Redshift
New rows via custom SQL Batch
New batch of rows via custom SQL in Redshift
New/updated row
New/updated row in a table in Redshift
New/updated rows Batch
New/updated batch of rows in a table in Redshift
New/updated rows via custom SQL Batch
New/updated batch of rows via custom SQL in Redshift

Any other trigger you can think up

Actions

Do this…

Microsoft Dynamics 365

Custom action
Custom action in Microsoft Dynamics 365 (Custom)
Close case
Close case in Microsoft Dynamics 365
Create object
Create object in Microsoft Dynamics 365
Create object Batch
Create object in Microsoft Dynamics 365
Get object by ID
Get object by ID in Microsoft Dynamics 365
Get object schema
Get object schema from Microsoft Dynamics 365
Search objects Batch
Search objects in Microsoft Dynamics 365
Update object
Update object in Microsoft Dynamics 365
Update object Batch
Update object in Microsoft Dynamics 365

Any other action you can think up

Redshift

Delete rows Batch
Delete rows in a table in Redshift
Export query result
Export query result as a CSV file in Redshift
Insert row
Insert row in a table in Redshift
Insert rows Batch
Insert batch of rows in a table in Redshift
Run custom SQL Batch
Run custom SQL in Redshift
Run long query using custom SQL
Run long query using custom SQL in Redshift
Select rows Batch
Select rows in a table in Redshift
Select rows using custom SQL Batch
Select rows using custom SQL in Redshift
Update rows
Update rows in a table in Redshift
Update rows Batch
Update batch of rows in a table in Redshift
Upsert row
Upsert row in a table in Redshift
Upsert rows Batch
Upsert batch of rows in a table in Redshift

Any other action you can think up

The wonders of Workato

Easily set up as many intelligent automations you need.

1000s of ready-to-use templates
Accelerate work with intelligent automation
Do it yourself, faster
Build bots. Put them to work

Market leaders run on Workato

Let’s start automating

Schedule a Demo