Database lookup

Design and automate database lookups. ThinkAutomation will interact with your external database to read records, assign results to variables, and run any subsequent automations. So, you can automate any number of database actions – either as a one-step process or as part of a larger workflow.
Database lookup – overview
- Connect ThinkAutomation into your database(s) and design any desired lookup workflow – orchestrating your conditions and automations via a drag-and-drop interface
- ThinkAutomation supports native access to: Microsoft SQL Server, Microsoft SQL Server Azure, MySQL / Maria DB, SQLite, Oracle, PostgreSQL, DB2, Firebird, and Microsoft Access
- It can also connect to an ODBC DSN and use any OLEDB driver
- The baked-in lookup action will read database records and assign results to multiple ThinkAutomation variables for further processing
- ThinkAutomation offers infinite extensibility to handle as many processes, data volumes, and system connections as you need
- It will monitor connected systems 24/7, check for new data every 60 seconds, and run automations in split seconds
Database lookup – use cases
- Send an outgoing email when a new record is added to a database table
- Set up dynamic lookups to eliminate duplicates to targets
- Lookup products to check their location, quality, and if their prices and features are correct
- Validate information against a PAF file
- Add tokens for data items that you’d like to log, such as keywords or field values, and feed to a report
- Plus countless more, depending on your desired use case
- Backup emails
- Email attachment storage
- Email parsing
- Email sentiment analysis
- Email to cloud
- Email to CRM
- Email to CSV
- Email to database
- Email to spreadsheet
- Email translation
- Move email attachment to folder automatically
- Outlook export all emails
- Parse email attachment
- Translate attachment
Database
- Data ETL
- Database automation
- Database counters
- Database monitoring
- Mongo update
- SQL to Excel
- Translate database
- Update a database
Telephony
CRM
- CRM data entry
- CRM sentiment analysis
- Dynamics automation
- Salesforce automation
- SugarCRM automation
- Zoho automation
Automation actions
- Automatic compression
- Automatic encryption
- Automatic translation
- Create hash file
- Database lookup
- Date operation
- Detect language
- Execute PowerShell
- Execute script
- Extract field
- File operation
- FTP download
- FTP upload
- GeoIP lookup
- MongoDB lookup
- OAuth sign-in
- Process files
- Run a program
- Send Teams message
- Sentiment score
- Set variable
- Speak text
- SQL command to update data in a database
- SQL execute command
- String operation
- Summarise text
- Train sentiment analysis model
Product
- .NET scripting
- Automation gateway
- Automation IDE
- Automation studio
- C# scripting
- Continuous processing
- Design actions
- High speed automation
- HTTP API
- JSON parser
- Local automation
- Markdown support
- Message store
- Public web API
- RPA community
- RPA designer
- SendGrid mail server
- Text summariser
- Visual Studio code paste without formatting