Update a database
Automatically push data from connected sources – mailboxes, web forms, local system folders, cloud services – into your database. ThinkAutomation enables you to build simple or complex automations to read, process, and execute actions against data in multiple systems. And part of this means fast, high-volume data flows to your database.
Update a database – overview
- ThinkAutomation can parse new inbound messages from multiple sources – POP3, IMAP and Exchange servers, Twitter feeds, web pages, RSS feeds, external databases, etc.
- It will monitor connected systems 24/7, pull and process new data every minute, and run conditional automations in split seconds
- You can configure any number of connections, conditions, and automations via our drag and drop automation studio
- An “update database” workflow could be a simple data push from A to B, or part of a larger automation sequence involving multiple systems and actions
- You also get coverage for any scale and any message / processing volume under a single licence
Update a database – use cases
- Parse inbound emails from a mailbox, extract key data, and upload to database records or tables
- Reformat invalid database invalid entries – e.g. automatically check telephone numbers against location and push changes to entries without the correct country code
- Convert data from .csv files into tables in an SQL Server database
- Create new database records based on data extracted from submitted, auto-validated web forms
- Upload documents to a database – either email attachments or new files found in connected folders
- 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