Great question..
RPA does not support two-phase commit or participation in externally initiated transactions. Any updates made through RPA database commands are committed once the commands execute successfully.
If the database is explicitly configured to operate in two-phase commit mode (which is not the default configuration), updates made by RPA SQL commands will not be committed, even if the commands themselves execute successfully.
Regarding bulk operations, these are executed within a transaction - meaning that either all rows in a BulkInsertoperation are committed, or none are, if the operation fails partway through.
Security:
We strongly recommend using a secure vault (RPA's built-in vault, HashiCorp Vault, or CyberArk) to store credentials. The database connection string should reference the credential handle stored in the vault to ensure full security. Data retrieved from the database and stored in an in-memory data table is not encrypted.
------------------------------
Suman Kalia
Sr. Development Analyst
IBM Canada Lab
Markham ON
9054133923
------------------------------
Original Message:
Sent: Thu October 30, 2025 02:47 AM
From: Cizar Abughazaleh
Subject: Webinar: IBM Robotic Process Automation (RPA) - Interactions with Database - discussion thread for post webinar
How to ensuring data integrity and security while maintaining process reliability and scalability?
------------------------------
Cizar Abughazaleh
Chief Executive Officer
MAXimuz Technology
cizar@maximuz.tech
Original Message:
Sent: Wed September 10, 2025 10:12 PM
From: Walfrey Ng
Subject: Webinar: IBM Robotic Process Automation (RPA) - Interactions with Database - discussion thread for post webinar
Please use this community thread for post webinar follow up and questions.
Webinar Event and Registration:
https://community.ibm.com/community/user/events/event-description?CalendarEventKey=e2760625-de67-4996-b80f-0198f165ea72
------------------------------
Walfrey Ng
------------------------------