Do everything in one place
Customize your MySQL and Okta integration with the following
triggers and actions.
Triggers
When this happens…
MySQL
- New rowNew row in a table in MySQL
- New rows BatchNew batch of rows in a table in MySQL
- Scheduled query BatchNew/updated batch of rows via scheduled custom SQL in MySQL
- New/updated rowNew/updated row in a table in MySQL
- New/updated rows BatchNew/updated batch of rows in a table in MySQL
Any other trigger you can think up
Okta
- New eventsTriggers when a new event is created in Okta
- New events Real-timeTriggers immediately when a new event is created in Okta
- Scheduled event search using filter BatchScheduled event search using filter in Okta
Any other trigger you can think up
Actions
Do this…
MySQL
- Delete rows BatchDelete rows in a table in MySQL
- Execute stored procedure BatchExecute stored procedure in MySQL
- Export query resultExport query result as a CSV file in MySQL
- Insert rowInsert row in a table in MySQL
- Insert rows BatchInsert batch of rows in a table in MySQL
- Run custom SQL BatchRun custom SQL in MySQL
- Select rows BatchSelect rows in a table in MySQL
- Get table schemaGet table schema for MySQL
- Update rowsUpdate rows in a table in MySQL
- Upsert rows BatchUpsert batch of rows in a table in MySQL
- Upsert rowUpsert row in a table in MySQL
Any other action you can think up
Okta
- Custom actionCustom action in Okta (Custom)
- Activate userActivate user in Okta
- Add user to groupAdds an existing user to a group in Okta
- Create userCreate user in Okta
- Deactivate userDeactivate user in Okta
- Delete userDelete user in Okta
- Expire an existing user passwordExpire an existing user’s password in Okta
- Get group members BatchRetrieves the list of members of a group in Okta
- Get groups by name BatchRetrieves groups by name in Okta
- Get user by IDGet user by ID in Okta
- Get user groups BatchGet user groups in Okta
- Get recent log on events by IP address BatchGet recent log on events by IP address in Okta
- Get recent log on events by user BatchGet recent log on events by user in Okta
- List applications assigned to user BatchList applications assigned to user in Okta
- Remove user from groupRemoves an existing user from a group in Okta
- Reset forgotten user passwordReset an existing user’s forgotten password in Okta
- Reset user passwordReset user password in Okta
- Search Users BatchSearch users in Okta
- Suspend userSuspends an existing user in Okta
- Unsuspend userUnsuspend an existing user in Okta
- Update userUpdate user in Okta
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