We are planning to do Performance testing for Journal Creation functionality in PeopleSoft application. In our project we are using excel sheet that has Macros written for uploading the Journal ID. It happens like this, we will enter the Journal details, subsequently have to click the ‘Upload Journal’ button in the excel sheet. The Journal ID will be created. We need to simulate this activity in Load runner.
We have used Load Runner for recording the Excel upload activity, but the tool was not able to capture the request and response that happens between excel and the server.
Has anybody used Load Runner for doing Spreadsheet upload?
Architecturally, what is the protocol or interface used between excel and your peoplesoft instance? Is this a direct to database connection where the data is pumped into the system? Does it use Tuxedo or other sockets middleware as a broker? Does it use web services? Once you understand architecturally how this is working between excel and the data store you will then have a path to evaluate tools.
Grab your local sniffer or instance of Ethereal/Wireshark and examine the conversation between the tiers for additional insight