Hello, I am new to this forum, so i apologise if my question is not clearly structured

I have been tasked to perform a load test across the following architecture;

Windows UI > web service> SQL server .... trigger to populate table which is polled by... Windows Biztalk > Web logic appserver> Oracle databse

1) how do i determine the e2e response time? i have recorded the transaction using vgen- http/web protocol and have been able to record the transaction to the sql database only, i have tried using multiple protocol scripts but they fail to capture any data.

2)iam struggling to create a oracle databse connection so that i can run a sql script to perform a delete operation as this is required to continue to persist further identical transactions at runtime... can anyone provide some info on this? thanks