Do everything in one place

Customize your SQL Server secondary and RegOnline® by Lanyon integration with the following triggers and actions.

Triggers

When this happens…

SQL Server secondary
  • New row
    New row in a table in SQL Server secondary
  • New rows Batch
    New batch of rows in a table in SQL Server secondary
  • New rows via custom SQL Batch
    New batch of rows via custom SQL in SQL Server secondary
  • Scheduled query Batch
    Scheduled query using custom SQL in SQL Server secondary
  • New/updated row
    New/updated row in a table in SQL Server secondary
  • New/updated rows Batch
    New/updated batch of rows in a table in SQL Server secondary
  • New/updated rows via custom SQL Batch
    New/updated batch of rows via custom SQL in SQL Server secondary
  • Any other trigger you can think up

RegOnline® by Lanyon
  • New event
    New event in RegOnline
  • New registration
    New registration in RegOnline
  • New transaction
    New transaction in RegOnline
  • Any other trigger you can think up

Actions

Do this…

SQL Server secondary
  • Delete rows
    Delete rows in a table in SQL Server secondary
  • Execute stored procedure
    Execute stored procedure in SQL Server secondary
  • Export query result Bulk
    Export result of custom SQL in SQL Server secondary
  • Insert row
    Insert row in a table in SQL Server secondary
  • Insert rows Batch
    Insert batch of rows in a table in SQL Server secondary
  • Run custom SQL
    Run custom SQL in SQL Server secondary
  • Run long query using custom SQL
    Run long query using custom SQL in SQL Server secondary
  • Select rows
    Select rows in a table in SQL Server secondary
  • Select rows using custom SQL
    Select rows using custom SQL in SQL Server secondary
  • Replicate rows Batch
    Replicate batch of rows to table in SQL Server secondary
  • Update rows
    Update rows in a table in SQL Server secondary
  • Update rows Batch
    Update batch of rows in a table in SQL Server secondary
  • Upsert row
    Upsert row in a table in SQL Server secondary
  • Upsert rows Batch
    Upsert batch of rows in a table in SQL Server secondary
  • Any other action you can think up

  • Show all 14
RegOnline® by Lanyon
  • Get event details by ID
    Get event details from RegOnline
  • Get registration details by ID
    Get registration details from RegOnline
  • Get transaction by ID
    Get transaction details from RegOnline
  • Get list of events
    Query events in RegOnline
  • Get list of registrations
    Get list of registrations for an event in RegOnline
  • Get list of transactions
    Get list of transactions for an event in RegOnline
  • Any other action you can think up

Let us tailor your SQL Server secondary and RegOnline® by Lanyon integrations

Pre-built SQL Server secondary and RegOnline® by Lanyon 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