Microsoft Dynamics Great Plains and SQL Collection by Workato integrations and automations

Seamlessly connect Microsoft Dynamics Great Plains and SQL Collection by Workato. Automate workflows, and boost efficiency with Workato.

Rating

4.9

Pre-built

150+

integrations

Total

100+

active users

avg

2 min

to connect

Custom Connections

Available

via HTTP connector

Market leaders run on Workato

  • monday.svg
  • box.svg
  • hp-2.svg
  • atlassian.svg
  • cisco.png

Build Powerful Workflows, fast

Triggers

When this happens…

Actions

Do this…

Microsoft Dynamics Great Plains
  • Apply document to invoice
    Apply document to invoice in Microsoft Dynamics GP
  • Create record
    Create record in Microsoft Dynamics GP
  • Create records in batches
    Create records in batches in Microsoft Dynamics GP
  • Custom action
    Custom action in Microsoft Dynamics GP
  • Get next document number
    Get next document number in Microsoft Dynamics GP
  • Search records using query
    Search records using query in Microsoft Dynamics GP
  • Update record
    Update record in Microsoft Dynamics GP

    • Any other action you can think up

SQL Collection by Workato
  • Create list Batch
    Create list
  • Create list from CSV file Batch
    Create list from CSV file
  • Insert rows Batch
    Insert rows into list in Collection
  • Insert rows from CSV file Batch
    Insert rows into list in collection from CSV file
  • Query lists Batch
    Query lists in Collection

    • Any other action you can think up

One platform

  • Power
  • Agility
  • Speed
  • Innovation