#5 | Automation 360 Database Insert | Insert Data into SQL Server Using A360 | Session 4| A360

Welcome to Session 4 of the Automation 360 Database Package Tutorial Series. In this session, we will learn how to insert data into a SQL Server database using Automation Anywhere Automation 360. After learning how to connect to the database and read records, we will now perform a database write operation using the Insert Query. 📌 Topics Covered: ✅ Automation 360 Database Package ✅ Insert operation ✅ Writing INSERT SQL queries ✅ Inserting data into a SQL Server table ✅ Executing database commands from Automation 360 ✅ Sending data from Automation 360 to the backend database ✅ Verifying inserted records in SQL Server ✅ Practical database automation example ================================================== Connection string: jdbc:sqlserver://DESKTOP-DPSKFB1:1433;databaseName=$databsename$;user=$username$;password=$pass$;encrypt=true;trustServerCertificate=true; =================================================== USE NewHireInfo; GO SELECT * FROM dbo.Employee; =================================================== Create table USE NewHireInfo; GO CREATE TABLE dbo.SimpleEmployeeInfo ( EmpCode INT, -- just a plain integer, not identity FirstName VARCHAR(50), -- allows NULL if not provided LastName VARCHAR(50), -- allows NULL if not provided Email VARCHAR(100) -- allows NULL if not provided ); ================================================ Insert Values USE NewHireInfo; GO INSERT INTO dbo.SimpleEmployeeInfo (EmpCode, FirstName, LastName, Email) VALUES (1, 'Reema', 'Sharma', 'reema.sharma@example.com'), (2, 'Amit', 'Verma', 'amit.verma@example.com'), (3, 'Sneha', 'Patel', 'sneha.patel@example.com'), (4, 'Ravi', 'Kumar', 'ravi.kumar@example.com'), (5, 'Priya', 'Singh', 'priya.singh@example.com'); =================================================== Display values USE NewHireInfo; GO select * from dbo.SimpleEmployeeInfo; ================================================================= This session demonstrates how Automation 360 can be used not only to read database information, but also to write data back into the backend SQL database. In the upcoming sessions, we can continue with other database operations such as UPDATE and DELETE. 🔔 Subscribe to follow the complete Automation 360 Database Package series. #Automation360 #automationanywhere #DatabaseAutomation #sqlserver #rpa #sql #a360 #rpatutorial