Do everything in one place

Customize your JDBC secondary and Magento 2 integration with the following triggers and actions.

Triggers

When this happens…

JDBC secondary
  • New row
    New row in a table in JDBC secondary source
  • New rows Batch
    New batch of rows in a table in JDBC secondary source
  • New rows via custom SQL Batch
    New batch of rows via custom SQL in JDBC secondary source
  • Scheduled query Batch
    Scheduled query using custom SQL in JDBC secondary source
  • New/updated rows via custom SQL Batch
    New/updated batch of rows via custom SQL in JDBC secondary 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 secondary
  • Export query result Bulk
    Export result of custom SQL in JDBC secondary source
  • Run custom SQL
    Run custom SQL in JDBC secondary source
  • Run long query using custom SQL
    Run long query using custom SQL in JDBC secondary source
  • Select rows
    Select rows in a table in JDBC secondary source
  • Select rows using custom SQL
    Select rows using custom SQL in JDBC secondary 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
    Search customers in Magento 2
  • Search order
    Search orders in Magento 2
  • Search product
    Search products in Magento 2
  • Any other action you can think up

  • Show all 8

Let us tailor your JDBC secondary and Magento 2 integrations

Pre-built JDBC secondary and Magento 2 Automations

See more

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