JDBC and Magento 2 integrations and automations

Do everything in one place

Customize your JDBC and Magento 2 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

Magento 2

New customer
New customer in Magento 2
New invoice
New invoice in Magento 2
New or updated customer
New/updated customer in Magento 2
New or updated product
New/updated product in Magento 2
New product
New product in Magento 2
New purchase order
New purchase order in Magento 2

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

Magento 2

Custom action
Custom action in Magento 2 (Custom)
Create customer
Create customer in Magento 2
Create or update product
Create or update (upsert) product in Magento 2
Get customer by ID
Get customer by ID in Magento 2
Get order by ID
Get order by ID in Magento 2
Search customer Batch
Search customers in Magento 2
Search order Batch
Search orders in Magento 2
Search product Batch
Search products in Magento 2

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