JDBC and Microsoft Dynamics Great Plains integrations and automations

Do everything in one place

Customize your JDBC and Microsoft Dynamics Great Plains integration with the following triggers and actions.

Triggers

When this happens…

JDBC

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

Any other trigger you can think up

Actions

Do this…

JDBC

Export query result
Export query result as a CSV file in JDBC source
Run custom SQL Batch
Run custom SQL in JDBC source
Run long query using custom SQL
Run long query using custom SQL in JDBC source
Select rows Batch
Select rows in a table in JDBC source
Select rows using custom SQL Batch
Select rows using custom SQL in JDBC source

Any other action you can think up

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

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