Task 4 : Bulk Updation of DB
Task ID TK 000230
Release //ReferenceTasks/Generic Tasks
Task Title Bulk Updation of DB
Description
This task demonstrates the feature of inserting multiple rows of data from an excel into DB in one insert statement and reading multiple rows as a table.
Pre-configured
Table-Def must be defined matching the schema of the excel data to be inserted into the DB.
Task DESIGN
The task consists of three nodes: Excel, Update DB(Bulk) and Read the Files db nodes.
1. Excel
| Properties Window | Value |
|---|---|
| 1. Excel Configuration | Configuration details of the machine that has the excel file to be automated |
| 2. Variables (Output Variable) | TableName (Excel values is copied to this TableName) |
| Edit UI | Controls / Expression | Input Varaibles | UI Actions | Output Variables |
|---|---|---|---|---|
| 1. Excel Command | Open Excel | Path of the Excel file (In this case, it is ‘C:\jiffyservice\Reference Tasks\Compare1.xlsx’) | - | - |
| 2. Excel Command | Copy to table | table_name and range_value (In this case, it is ‘OrderDetails_Table’ and ‘A2:C5’ respectively.) | - | TableName. In this case, it is ‘OrderDetails’ |
2. Update DB (Bulk):
| Properties Window | Value |
|---|---|
| 1. DB Configuration | DB connection string, driver, username and password to open the connection with the DB |
| 2. Query Type | Update Statement |
| 3. Query | insert into Order_Details (ItemNo) values (‘${input_table.ItemNo}‘); |
| 4. Processing Type | Bulk Processing |
| 5. Table Name | OrderDetails_Table (Table Def ) |
3. Read the Files:
| Properties Window | Value |
|---|---|
| 1. DB Configuration | DB connection string, driver, username and password to open the connection with the DB |
| 2. Query Type | Select Statement |
| 3. Query | select * from Order_Details |
| 4. Processing Type | Bulk Processing |
| 5. Table Name | OrderDetails_Table (Table Def) |
Mapping
*1. Update DB (Bulk)
Did you find what you were looking for?