Skip to main content

Microsoft SQL Server

Connect to and interact with Microsoft SQL Server databases for enterprise data operations and automation.

Overview​

The Microsoft SQL Server package provides database connectivity for SQL Server. Use it when you need to query data, insert records, execute stored procedures, or perform transactions against Microsoft SQL Server databases.

Key Features​

  • Query Execution - Run SELECT queries and get results
  • Data Modification - INSERT, UPDATE, DELETE operations
  • Transactions - Manage database transactions
  • Wait Operations - Wait for data conditions to be met
  • Bulk Insert - Insert multiple records efficiently

Available Nodes​

  • Connect - Establish connection to SQL Server
  • Disconnect - Close database connection
  • Query - Execute SELECT query and return results
  • Non Query - Execute INSERT, UPDATE, DELETE statements
  • Insert - Insert data into a table
  • Start Transaction - Begin a database transaction
  • Commit - Commit the current transaction
  • Wait Table - Wait for table to have rows
  • Wait Row - Wait for specific row condition
  • Wait Column - Wait for column value condition

When to Use This Package​

  • Data Extraction: Query and export data from SQL Server
  • Data Entry: Insert automation results into database
  • Report Generation: Pull data for automated reports
  • System Integration: Connect RPA with SQL Server backend
  • Data Validation: Check database state during workflows

Connection​

Supports SQL Server authentication and Windows authentication. Connection string format:

Server=hostname;Database=dbname;User Id=user;Password=pass;

Typical Workflow​

  1. Connect with credentials
  2. Query to retrieve data
  3. Process data in your automation
  4. Insert or Non Query to write results
  5. Disconnect when finished

Transaction Support​

For atomic operations:

  1. Start Transaction
  2. Perform multiple operations
  3. Commit if all succeed (or let it rollback on error)

Wait Operations​

Wait nodes are useful for:

  • Waiting for data to arrive before processing
  • Synchronizing with external systems
  • Polling for status changes