Do everything in one place
Customize your BlackLine and JDBC integration with the following
triggers and actions.
Triggers
When this happens…
JDBC
- New rowNew row in a table in JDBC source
- New rows BatchNew batch of rows in a table in JDBC source
- New rows via custom SQL BatchNew batch of rows via custom SQL in JDBC source
- Scheduled query BatchScheduled query using custom SQL in JDBC source
- New/updated rows via custom SQL BatchNew/updated batch of rows via custom SQL in JDBC source
Any other trigger you can think up
Actions
Do this…
BlackLine
- Import account assignmentsImport account assignments in BlackLine
- Import account balancesImport account balances in BlackLine
- Import account group mappingsImport account group mappings in BlackLine
- Import account group settingsImport account group settings in BlackLine
- Import account settingsImport account settings in BlackLine
- Import bank balancesImport bank balances in BlackLine
- Import budgetsImport budgets in BlackLine
- Import CIM mappingsImport CIM mappings in BlackLine
- Import currency ratesImport currency rates in BlackLine
- Import entitiesImport entities in BlackLine
- Import entity typesImport entity types in BlackLine
- Import item detailImport item detail in BlackLine
- Import multi-currency balancesImport multi-currency balances in BlackLine
- Import subledger balancesImport subledger balances in BlackLine
- Import task dependenciesImport task dependencies in BlackLine
- Import task descriptionImport task description in BlackLine
- Import tasksImport tasks in BlackLine
- Import tasks auto-certify completionImport tasks auto-certify completion in BlackLine
- Import team typesImport team types in BlackLine
- Import teamsImport teams in BlackLine
- Import user entitiesImport user entities in BlackLine
- Import user rolesImport user roles in BlackLine
- Import user team assignmentsImport user team assignments in BlackLine
- Import usersImport users in BlackLine
- Import variance group mappingImport variance group mapping in BlackLine
- Import variance group settingsImport variance group settings in BlackLine
- Import variance rulesImport variance rules in BlackLine
- Import variance settingsImport variance settings in BlackLine
Any other action you can think up
JDBC
- Export query resultExport query result as a CSV file in JDBC source
- Run custom SQL BatchRun custom SQL in JDBC source
- Run long query using custom SQLRun long query using custom SQL in JDBC source
- Select rows BatchSelect rows in a table in JDBC source
- Select rows using custom SQL BatchSelect rows using custom SQL in JDBC source
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