Avalon: Generate synthetic test data with an UiPath Agent for Infometis "Test Data Orchestrator" (TDO)

AgentHack submission type

Agentic Testing Solutions

Name

Johannes Reitermayer

Team name

Avalon

Team members

daniel.good@lgt.com, benjamin.tan@infometis.com, serge.wolf@infometis.com

How many agents do you use

One agent

Industry category in which use case would best fit in (Select up to 2 industries)

Banking
Banking and financial services

Complexity level

Beginner

Summary (abstract)

Agent that generates synthetic test data for a set of business objects (business partner, person, address, container, money account) and writes it to Infometis “Test Data Orchestrator” (TDO) for test case-consumption. A second solution built with context grounding has also been implemented that also generates JSON-data and PL/SQL source code to execute immediately against Avaloq which can’t be shown because of security reasons, but it works.

Detailed problem statement

Testers always need test data. In a banking environment like Avaloq, using productive data is not allowed due to legal restrictions. Creation of synthetic test data is a complicated process, usually requiring to write code that produces test data.

Detailed solution

  • Our Agent allows you to create synthetic test data by simply prompting your requirements (in UiPath Assistant).
  • The agent is instructed to create scripts that run in the Avaloq Banking system.
  • To make the created test data accessible the agent also writes the test data info into the Infometis “Test Data Orchestrator” (TDO) - a Jira Addon

Demo Video

Expected impact of this automation

  • The Agent allows one to easily create synthetic test data by simple prompting and provide it visibly in Jira.
  • This saves up preparation time before test runs
  • It creates compliant synthetic test data for the Avaloq Banking System
  • Enables “Shift Left” - test data can be used by developers in early stages
  • Test data can be adjusted without coding by adding additional instructions to the user prompt (e.g., change amount or currency to be settled)
  • Example for escalation process included (e.g., a person is under the age of 18) > “Male, 17, Bonn, Reject, Current.mp4”

UiPath products used (select up to 4 items)

UiPath Agent Builder
UiPath Apps
UiPath Assistant
UiPath Automation Cloud™
UiPath Automation Ops
UiPath Autopilot™
UiPath Integration Service
UiPath Orchestrator
UiPath Studio Web
UiPath Test Suite

Automation Applications

Avaloq core banking solution

Integration with external technologies

Infometis “Test Data Orchestrator” (Jira Addon)

Sample inputs and outputs for solution execution

Generate synthetic test data for …
Male, 17 years old, Bonn > Reject age verifaction
Female, 40 years old, Vaduz, 2 money accounts, 100’000 split 70:30 to CHF and EUR

Other resources

Generation of JSON and PL/SQL-Code for Avaloq via Context Grounding >
“Avalon - Autopilot for Everyone - Source Code.mp4”
“Avalon - Autopilot for Everyone - JSON.mp4”