SQL command to update data in a database

Build commands to update your databases automatically. ThinkAutomation provides an open-ended studio to orchestrate custom database automations, with infinitely extensible connections and actions. SQL commands are just one baked-in action for quick, drag-and-drop workflow design.

SQL command to update data in a database – overview

• This ThinkAutomation action will execute a SQL command or stored procedure
• You can pass any number of parameters and assign output parameters to variables
• Via SQL, you can insert or update a row in a database based on the results of a select statement
• Supported database types include: Microsoft SQL Server, Microsoft SQL Server Azure, MySQL / Maria DB, SQLite, Oracle, PostgreSQL, DB2, Firebird, and Microsoft Access
• ThinkAutomation can also connect to an ODBC DSN and use any OLEDB driver

SQL command to update data in a database – use cases

• Update one database table with data from another table if new entries are detected
• Parse data from inbound emails and add extracted fields to database rows / tables
• Auto-extract data from Excel or CSV files and upload to DB
• Update a database with new data from connected monitored sources – such as a reporting system or a file in a folder
• Plus countless more, depending on your desired use case