Deputy and JDBC integrations and automations

Seamlessly connect Deputy and JDBC. Automate workflows, and boost efficiency with Workato.

Ratings

4.9

Peer Insights™

100%

Customer Recommendation

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…

Deputy
  • New employee
    New employee in Deputy
  • New leave
    New leave in Deputy
  • New timesheet
    New timesheet in Deputy

    • Any other trigger you can think up

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…

Deputy
  • Custom action
    Custom action in Deputy (Custom)
  • Associate employee
    Associate an employee in Deputy
  • Create employee
    Create employee in Deputy
  • Create resource
    Create resource in Deputy
  • Create sales data
    Create sales data in Deputy
  • Create task
    Create task in Deputy
  • Unassociate employee
    Unassociate an employee in Deputy
  • Get resource
    Get resource in Deputy
  • Search employees Batch
    Search employees in Deputy
  • Search resources Batch
    Search resources in Deputy
  • Search operational unit Batch
    Search operational unit in Deputy
  • Update employee
    Update employee in Deputy
  • Update resource
    Update an existing resource in Deputy

    • Any other action you can think up

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

One platform

  • Power
  • Agility
  • Speed
  • Innovation

Let’s start automating

Schedule a Demo