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