JDBC and Lookup tables by Workato integrations and automations

Seamlessly connect JDBC and Lookup tables 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

Build Powerful Workflows, fast

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
Insert rows Batch
Insert batch of rows in a table 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

Lookup tables by Workato

Add entries Batch
Add multiple entries to lookup table
Add entry
Add an entry to lookup table
Delete multiple entries Batch
Delete multiple entries from lookup table
Delete entry
Delete an entry from lookup table
Get all entries Batch
Retrieve all entries from lookup table
Lookup entry
Lookup a single entry in lookup table
Search entries Batch
Search entries in lookup table
Truncate table Batch
Truncate all entries from lookup table
Update entry
Update an entry in lookup table

Any other action you can think up

One platform

Power
Agility
Speed
Innovation